Access 2000 populate form with different tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. when I declare my db as database I receive error not defined - is this a
2000 issue? (just trying to access the current db w/in the program)
2. From main menu - user opens form which updates labels w/current
information. User can not modify these labels. The updated information
comes from five different tables all located w/in the current program
ex. Pierce Cnty tbl 1 tbl 2 tbl 3 etc
I have successfully completed this task before - but for whatever reason am
running into a brick wall this time on how to accomplish it this time.
ANYONE willing I would love ideas...
Denise
 
A1.
From any code window, choose References on the Tools menu.
Check the box beside:
Microsoft DAO 3.6 Library.
More info:
http://allenbrowne.com/ser-38.html

A2.
It would be possible to create a UNION query into the 5 tables, and include
the literal table name as a calculated field. You could then try creating a
crosstab that uses these table names as Column Heading.

That would be a fairly nasty workaround for something that probably should
have all 5 tables in one, with another field to distinguish them.
 
Back
Top