Store report names in a table

  • Thread starter Thread starter TK
  • Start date Start date
T

TK

Is there a way to store report names in a table in which I can have a user
press a button on a form and have a select query run where all the user had
to do is enter the form "Number" and it be automatically sent to a specific
pritner? Don't want the user to see the list of reports and have to make a
decision as to which one to choose - only print report based on report
number?

Thanks,
TK
 
Do you really need to store the report names in a table? Are you going to be
storing anything else in that table, or are you going to be linking to
another table?

You can get a list of what reports are in a database using:

SELECT Name
FROM MSysObjects
WHERE Type=-32764
ORDER BY Name

That may be enough. If not, you can use that to populate a table.
 
Douglas: Thanks for the information. Yes, I am storing other info in the
table. The reports are actually labels that are printed in a production
facility. The plant workers are using a touch screen and the form on the
screen ask for them to enter a product code. A macro runs a series of
queries to pull the appropriate information from several tables via queries.
This information is gathered into a temp table for a report (label) to be
printed. Because several of the labels are almost identical, we want the
correct label to be printed based on the product code number. In other
words several product codes use the same lable, but other product codes use
a slightly different label.

Hope this makes sense as to what I am trying to do.

TK
 
Back
Top