It has been years since my VB courses (for VB 4), and I am sure it has changed anyway. I know that I did this once before, but I can't remember how and can't find any examples on the web.
I have a form where the user will key in a value in a text box that will be a primary key in a table in an MS Access database. I do it all the time using C on Unix accessing Oracle, but I need to do it using VB on Windows accessing MS Access.
How can I get the results of a PK select query -- where I am sure that there will be either no row returned or only one row returned -- into a VB variable. Once it is there, I know what to do.
Also -- I am probably going to sound like a rank amatuer by this statement, but, again, I do it all the time with C (and COBOL) accessing Oracle, DB2, and Informix -- does VB not support ESQL to access MS Access database?
Any help would be appreciated greatly.
Enter your message below
Sign in or Join us (it's free).