List of Tables

  • Thread starter Thread starter Jason Rhymes
  • Start date Start date
J

Jason Rhymes

I'm trying to make a form that will show all my tables in a combo box and
allow me to pick one and use that same table in a report template I already
set up, if that makes since. Is it possible? Any place to see an example?
 
I'm trying to make a form that will show all my tables in a combo box and
allow me to pick one and use that same table in a report template I already
set up, if that makes since. Is it possible? Any place to see an example?
Click to expand...

As the Combo Box Rowsource:

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],4))<>"MSys") AND ((MSysObjects.Type)=1)) ORDER BY
MSysObjects.Name;
 
Thanks, that worked great but I thought it would be easy from there to pass
that to the report. I'm having problems with that. Can I get help here or do
I need to ask again in the report NG?
 
Thanks, that worked great but I thought it would be easy from there to pass
that to the report. I'm having problems with that. Can I get help here or do
I need to ask again in the report NG?
Click to expand...

You can ask here or in reports, but you need to give more information
than you did in your first post, as to what you want to do with the
list of tables.
 
Back
Top