Reply here please: access2000 queries via VB

A search of this newsgroup will yield what you want. For starters, try:

http://forums.vb-world.net/showthrea...threadid=26942

this link is very close to my problem but this fellow runs his queries in access, and makes reports, which are called from VB

i want to type in a company code and get all the information about that company to appear...all this information is spread in a half dozen tables though

thanks for the help and PLEASE help again...this is awful for me

thanks,
Jason Harrison
TNL Consulting

Does Access 2000 support "views" ?

i don't know

could always convert to 97 tho

Access 97 does not. In case you don't know, a view is a kind of virtual table tha can contain elements from many different tables. You could create a view that would retrieve and display all the particular information. SQL Server supports views. You can also create multiple bound controls that you could use to retrieve your data...

thank you! this makes more sense

ok i have dropped on the form, four controls bound to each of the 4 tables i need data from

what sort of code do i need please sir?


the tables are like this:

TABLENAME: AGENTS COMPANYDETAILS COMPANYCONTACT CONTACTS
pr keys : agent companyid companyid contactid
fields : coName agent contactid firstname
address lastname
website job
phoneNum


those are the four tables

you're a lifesaver!

thanks again,

jason

I'm afraid I can't help you, I don't use bound controls (but there are others that read this newsgroup that can help you).

Thanks a lot for your help.

-Jason