Base DS form on QueryDef?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J. Shrimp, Jr. - 12 Feb 2005 21:40 GMT

Got small tables - hundreds of 'em.
If someone selects a table to view,
don't wanna create a hundred forms
Planning on creating a temp table
and emptying, then appending data
from selected table (there's only one field
in all the tables and its a datasheet form).
Will base form on that one temp table.
Each time a new table is selected,
the process will start again.
Seems like many postings here are down on
temp tables, so I was planning on trying
using a querydef as source, but don't
know how.

Reply to this Message

Stefan Kowalski - 12 Feb 2005 22:30 GMT

> Got small tables - hundreds of 'em.
> If someone selects a table to view,
[quoted text clipped - 10 lines]
> using a querydef as source, but don't
> know how.

You could try having a form with a recordsource which is sent in the
OpenArgs when you open the form. For example, if you had two tables:
tblStudent, tblTeacher you could have two queries:

SELECT tblStudent.StdFirstName AS FirstName, tblStudent.StdLastName AS
LastName FROM tblStudent

SELECT tblTeacher.TchFirstName AS FirstName, tblTeacher.TchLastName AS
LastName FROM tblTeacher

Your form then has fields bound to the fields FirstName and LastName. It
doesn't matter that neither table has the field FirstName - each query has
an alias for this field.
Of course, if you have hundreds of tables with datasets to be displayed in a
similar manner, then perhaps these tables deserve to be consolidated into
one table.

Reply to this Message