Results 1 to 12 of 12

Thread: what is the right way to do

  1. Jul 3rd, 2002, 03:01 AM #1
    look
    look is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2002
    Location
    Here in our Planet
    Posts
    76

    what is the right way to do

    what is the right way to connect the data which the user entered in a text boes to a database access?????
    If there is a will. there is a way....
    Reply With Quote Reply With Quote
  2. Jul 3rd, 2002, 03:51 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: what is the right way to do

    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?????
    Uh??

    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

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  3. Jul 3rd, 2002, 04:26 AM #3
    look
    look is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2002
    Location
    Here in our Planet
    Posts
    76

    i know but

    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....
    If there is a will. there is a way....
    Reply With Quote Reply With Quote
  4. Jul 3rd, 2002, 04:46 AM #4
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    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

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  6. Jul 5th, 2002, 11:06 PM #5
    look
    look is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2002
    Location
    Here in our Planet
    Posts
    76

    Connection VB form to DB

    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
    Last edited by look; Jul 6th, 2002 at 10:56 PM.
    If there is a will. there is a way....
    Reply With Quote Reply With Quote
  7. Jul 5th, 2002, 11:43 PM #6
    look
    look is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2002
    Location
    Here in our Planet
    Posts
    76

    Ecniv

    is it becuase i have 97,2000 access..
    If there is a will. there is a way....
    Reply With Quote Reply With Quote
  8. Jul 6th, 2002, 03:58 PM #7
    Franky
    Franky is offline
    Fanatic Member
    Join Date
    Nov 2001
    Location
    Bangkok
    Posts
    969

    hi look

    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
    Reply With Quote Reply With Quote
  9. Jul 6th, 2002, 10:53 PM #8
    look
    look is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2002
    Location
    Here in our Planet
    Posts
    76

    Franky

    could you post the link so i can read it...
    If there is a will. there is a way....
    Reply With Quote Reply With Quote
  11. Jul 7th, 2002, 01:10 AM #9
    Franky
    Franky is offline
    Fanatic Member
    Join Date
    Nov 2001
    Location
    Bangkok
    Posts
    969
    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
    Reply With Quote Reply With Quote
  12. Jul 7th, 2002, 02:15 AM #10
    Jethro
    Guest
    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...
    Reply With Quote Reply With Quote
  13. Jul 7th, 2002, 02:36 AM #11
    look
    look is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2002
    Location
    Here in our Planet
    Posts
    76

    i'm using

    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?????
    Last edited by look; Jul 7th, 2002 at 11:01 PM.
    If there is a will. there is a way....
    Reply With Quote Reply With Quote
  14. Jul 7th, 2002, 08:39 PM #12
    Beacon
    Beacon is offline
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    1) Dta contorols suck badly
    2) The data control your using uses DAO!
    3) To solve your problem download sp5 from MS!

    b
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width