form to print reports from

G

grws86

I would like to have a event to populate a table with all table names of
current db that I could us in a form to print a report from diffrent tables..
each table is just like the other one only the name is different..

Thanks for any help ..

Paul
 
O

Ofer Cohen

This SQL will display the names of all the tables withinh the current db,
using the MSysObjects table

SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Type=1
 
T

tina

if you have multiple identical tables which are only differentiated by their
names, then it seems that you are storing data in the table names - which
breaks data normalization rules. suggest you combine all your data into one
table, with an additional field to store the data currently held in the
table names (months of the year, perhaps? productnames? whatever...). once
that's done it's easy enough to use a Totals query or SELECT DISTINCT query
as the RowSource for a listbox control in a form, so that the values in that
field are displayed. then you can write *one* report, filtering its' source
data by the value chosen in the form's listbox.

hth
 
G

grws86

Thank you for your responce..
These tables are a excell report sent daily and converted to a table in a
database.. to keep from making a new report each day I want to just change
table names on the report and print. There is too much data to just add to
one table.. I will keep looking for a simple way to update a query with all
the tables and print report from there..

Paul
 
Top