[microsoft:access] Forum Topics

how can i save the path of the picture i've browsed. i'm using vb.net as my front-end and ms access as my back-end. thanks in advance :)

hi, tkx to welcome me in here! i have wrttien a program in vb6 that uses ms access. the program is a attendance monitoring system, that uses the time to calculates hrs late and early of employees. im having problem i dnt know how to make validations in vb6 ex: …

Please provide MS Acess Application which create Business Cards and can be change feilds accoding to card type.

I have 2 fields in my database namely username and password.i also created a login form with 2 textbox and 2 command buttom.textbox1 is for username and textbox2 for password.i have link the form to the database already.now how can i get data in the textbox to correspond to data …

hi i need help with add edit and delete records in access using vb.net. i got textbox 1 to5 and three buttons which named addnew ,edit, delete. my database is in name records.mdb i want user to enter the information and click addnew button and the system save the records …

I'm having a problem in connecting my access database using php. The wampserver displays a message of Parse error. I have connected my access db through control pannel's option administrative tools,but no output.plz help me.... The server shows the following message: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Microsoft Access Driver] …

Hello. I have searched, and found database tool the [URL="http://www.powerdbtools.com"]PowerDBTools[/URL]. Who knows how can I convert my Access database to SQL 2008 with this tool? Thank you.

ok so i two columns , one is type and the other is price. what i need to do is add everything up. so instead of like many rows of computers and their costs i need like said computer and the total sold are $346488 for example note i havent …

Please can anyone tell me how to write a program that will auto suggest or auto complete a search word from a MSAccess database using PHP and Ajax. Thanks

hey there, i am creating a program, and i have text fields such as Customer Name, address, postcode, telephone email etc. and i also have a button 'add record' what do i have to code in add record to actualy save the records.. will i have to make a file …

[b]Split from - [url]http://www.daniweb.com/forums/thread106146.html[/url] [/b] [QUOTE=GeniXmeN;517655]Thanks man a lot for the help i solve the problem!!! :) I put the new button for Deleting and now is working. Once again thanks for the ideas and for the link!!![/QUOTE] I tried almost everything but did not got success. I am not …

pls can any one tell me how to connect vb 6.9 with access 2007 using adodc.

[b]Split from - [url]http://www.daniweb.com/forums/thread148211-2.html[/url][/b] hi can u send me the table related to vb project using ms-access as backend so that i see the relationship between tables.

I have a database, which keeps track of peoples training dates, they have to complete the training yearly. I can run reports to see who is overdue, or comming due in 60 days. I would like to be able to run a report like this, however, I would like it …

I have a C# desktop application project for school that uses an Access 2003 database (not designed by me) and I am running into issues using OleDBDataReader. It has been awhile since I have programmed anything and I have never had to connect to an Access database before, so this …

hi i have a problem if any one can help me please. i have 2 tables in Access database- Drug_Name and Chemistry. i have to retrive the from DB to the ASP. the Drug_Name has Drug_ID, D_name, Synonyms as the fields. once the user write a name it should check …

Hello everyone, my task once again is to design a video rental database. I have done all i need to but but am having problem in getting the due date. from the dateRented and DueDate. what query or code will i use? i will appreciate an urgent reply Thanks Y'all.

guys help me to connect access to VB.. the user name in access to be inputted in VB must be correct..only registered ID in access can go

Greetings, I am creating a data entry form with a subform. Currently I am able to save the mainform without filling out the subform. What needs to be done to stop the user from saving the main form with the subform blank? Thanks in advance Asha

I have an Access database (Databas1.mdb) with one table (Tabell1) containing one column only (SomeData). The column is Text and has the primary key assigned to it. Executing the code, i.e. clicking btnAdd gives a synrax error on the INSERT INTO-command when reaching the cmd.ExecuteNonQuery()-statement. [CODE] using System; using System.Collections.Generic; …

Hello, I have created a program and i have managed to publish my application. I have set it up to be installed via CD but it does not attach the MSAccess DB. My question is how do I add the DB?

Hi, I have got the complete vb6 application for doing graphic and costing estimation. I am currently using microsoft access database. The problem is: my client is currently using a quickbook application for their accounting package (for paying employees, suppliers and making an invoice for the customer). As far as …

I have this problem from time to time, and at the moment. I set a breakpoint in the code to debug. I remove the breakpoint after I am finished but the program still pauses at that point. Press F5 and it continues fine. Close the database and reopen it and …

im trying to add a new records to database access but when i click the button submit it say's Syntax error in INSERT INTO statement, OledbException was unhandled da.Update(ds, "MSHS") = syntax error INSERT INTO here's my code [CODE]Public Class StudentRegistrationForm Dim inc As Integer Dim con As New OleDb.OleDbConnection …

Hello. Somehow i managed that my program works with access databse located on my computer: con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Documents and Settings\company.mdb" Now i would like that program will open the database company.mdb from my web page exp. [url]www.page.com/company.mdb[/url] Can you suggest how? THX

hello please help me how to connect my program to microsoft acces...please help me because i don't have any idea on how to connect ...hoping for your positive responds...here's my code.. Private Sub cmdAdd_Click() For i = 1 To Len(txtLname) If IsNumeric(Mid(txtLname.Text, i, 1)) = True Or (Mid(txtLname.Text, i, 1)) …

Hi I have a database with two tables 1. iSet(which contains data) 2.Table1(which is empty) I have a program that can read from iSet. It uses OleDB Its working properly The problem is that i don't know a thing about writing to a database. The table Table1 has two fields …

Hi everyone, I'm a Hungarian who lives in Sydney, Australia. I do Access databases but am self-educated. I'm happy to find this forum as I don't know anybody who can answer my questions. Access books are too basic to me. Cheers, Alexandra

i have an access table that contains the following: ID Number, Store Number, Sales Region, Item Number, Item Description, Unit Price, Units Sold and Week ending. One of the queries requires us to find the best selling products by quantity and another by units sold. I'm confused on the formula …

Hello Friends… Before going into why I am writing this, first I want to confess one thing. I am not a very experienced professional like some of you reading this post. I am just a beginner in learning Ms-Office. As a sincere amateur, I so far explored most of the …

Hi, I really need some help I've got a program in visual basic designed for entering order information into a database. I've got radio buttons where you can select the product and i need these when selected to declare that the rest of the information following is reffering to the …

Can Somebody plz tell me how to give the form ,a footer & header. I want to write in Heaer-REPORT FIRST But i m not getting how to type the text in Header & Footer, plz reply. Bydefault the user is able to resize the form,I also want that the …

Hey guys, I'd posted earlier about creating a database for a vaccination clinic is a slum. All the responses were really helpful (thank you!) but I'm encountering some further problems. In a table named "Table Children" I have a "Date of Birth field" and and an "Age at the time …

Hi, Can you please let me know how can I use MS-Access in my C/C++ project.I m try to develop a project of ATM machine and I must have to use MS-Access in my project. Can you please help me ASAP. Pradip S. Mali

I made a query for inserting a value from text box to MS ACCESS db [CODE] sql = "INSERT INTO Equipment (port_number,display_name,equipment,tonnage,user_privilage) VALUES (" & CLng(txtPort.Text) & ", '" & CStr(txtDisplay.Text) & "', '" & CStr(txtCA.Text) & "', " & CLng(txtTonnage.Text) & ", '" & CStr(cmbUser.Text) & "')"[/CODE] Actually I …

can anybody explain what the difference between the 2 codes below? i'm using visual basic 6 and i'm connecting access dbase. and one other thing, i'm trying to connect access 2007 with my vb6 but i can't remember the code, i know the code below works with access 2003 and …

Hi experts Here I am with yet another problem. I want to add data in a tree viewer controller dynamically from my database. I am using ms-access as my back-end Please help me ASAP. Thank you in advance

Hello everyone...can anyone modify my code below....i have a database named "Database1.accdb" with a table "Applicants"...The columns are ID(auto incremented),Name,and Age.... on this code, i can display the data from my database... My problem is that how can i add a new record to my database...or delete a record... I …

Hi community, I have the weirdest error happening in my VB6 program when I try to execute an "INSERT INTO" query. Here are the premises: [code=VB]Public conn as ADODB.Connection Public rs1 as ADODB.Recordset[/code] - the database is Access 2003 this will be migrated to SQL server later. - conn has …

Hi, Im building a database in Access with the use of VB. If I have 2 tables, both of which will be used as a subreport/form: 1 - Invoice Details a - Invoice Number : Integer b - Item: String c - Quantity - Number d - Rate/Cost/Wateva - Currency …

Hi I am a new user in access and created a database to use in accounting practice. I want to create a query control that will show the opening balance, plus fees less closing balance = 0 as all data are imported from another system. The problem is that the …

[CODE]Private Sub cmdgetdata_Click() For i = 0 To lstsoftware.ListCount - 1 If lstsoftware.Selected(i) Then sSQL = "select * from Master_final" With adorsRAM .ActiveConnection = cn '.CursorLocation = adUseClient .CursorType = adOpenDynamic .LockType = adLockOptimistic .Open sSQL End With If Not adorsRAM.EOF Then Set msh.DataSource = adorsRAM msh.Refresh Else MsgBox "No …

Please this is my code to display records from my ms-access database whenever i click the [B]button next[/B]. But the code is only displaying the[B] last record[/B] in the database. Please HELP is needed. I have tried using for loop but it is giving me error. [code] Imports System.Data.OleDb Public …

How can we add data from multiple columns of an access table in a list box. Please explain with the help of a code. Thanks in advance.

hi everyone im trying to update access from vb.net application. when excuting im getting this error: the microsoft.jet.oledb.4.0 source="c:\...."provider was not registered on the local machine. when i go and run cmd to register ddl files. i was able to register msjet40.dll and msjetoledb40.dll with the other dll a box …

Dear all, I've thus far created a simple Access database to keep track of all the pumps my (mining) company uses. What I want to do, is create a form which will automatically archive previous data if new data is written into it. For example, I have a pump that …

how can i insert an image to ms-access database using java swing form and vice versa.

Dear All, I have a small database which has two tables, table A = Stock and table B = Sold, these both has same fields including quantity, I have all my items in stock table, but what I want to do is when I sold something and entered in sold …

I'm trying to paste some text into a memo field and am getting the message "The text is too long to be edited". The text is 64K, which I believe is the max. I even did a character count on it that came to 64,360 and the limit I learned …

Hi there! First off I´m new here, so, I'd say HELLO EVERYONE an thanks for years helping. I have the following problem: I need create a installation of a C# app that uses a SQL SERVER 2008. I am using INNO Installer because I thought it could be the best …