Reply here please: access2000 queries via VB

[JHausmann]

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

http://forums.vb-world.net/showthread.php?threadid=26942

[HumanBeing]

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

[JHausmann]

Does Access 2000 support "views" ?

[HumanBeing]

i don't know

could always convert to 97 tho

[JHausmann]

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...

[HumanBeing]

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

[JHausmann]

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).

[HumanBeing]

Thanks a lot for your help.

-Jason