what is the right way to connect the data which the user entered in a text boes to a database access?????:confused:
Printable View
what is the right way to connect the data which the user entered in a text boes to a database access?????:confused:
Uh??Quote:
Originally posted by look
what is the right way to connect the data which the user entered in a text boes to a database access?????:confused:
You mean use the data entered to filter a returned recordset?
Or how to store entered data to Access?
If the latter have a look at the tutorials on vbworld in the database section.
For the former, have a look at filtering via the Sql statement and 'where' clause.
Vince
hi, i did see several examlples using Datacontrol, flex grid,dbgrid,
i also read about rdo,ado,adodc
but all of them are working or given examples with nwind db but when i try to connect the my from to my db it gives me an error that my db is unrecognized....:confused:
Connecting from VB?
Its possible you are trying to connect a 97 mdb to 2k mdb - which gives unrecognised format. or visa versa which may give that error message.
Also check the MDac downloads for the upto date stable version. This should change the 97/2k problem.
Vince
i'm working with access2000,and VB6..
my form has text boxes, and a data control, which i set it datasource to my DB,and when i try to set the recordsource it gives me that error.
and my DB fields are empty and i want to fill them from these textboxes.. what should i do
is it becuase i have 97,2000 access..
read my thread: How to connect MDB with VB. It is easy to understand.
You will have no questions anymore about this ..... hopefully, hehe
Franky
could you post the link so i can read it...
Here is the thread:
FREE MODULE: How to open a Database in VB (Access, DBF)
It is in the Database section. I never pasted a thread, sorry, I don't know how to do it.
Franky
Ah database unrecognised error is because you are using Access 2000. Which connection method? For DAO you have to reference the 3.6 version... Beaker has an ADO tutorial in the first post on this forum, which will cover ADO connection to Access 2000.
Hope it helps...
i'm using data control to connect my db to vbfrom . not DAO...AND i know when coonect to access97 use 6.3 and access2000 use4
so does that solve my problem?????
1) Dta contorols suck badly
2) The data control your using uses DAO!
3) To solve your problem download sp5 from MS!
b :)