Custom Report File Name

  • Thread starter chopper57 via AccessMonster.com
  • Start date
C

chopper57 via AccessMonster.com

I would like to have my report auto input fields from the report for its file
name. My report name is Daily Report, I would like the file name to include
the following fields:

Site, ReportNo, Date, Shift, and save as a snapshot.

I have been reading a lot of items concerning this on the site and will be
trying them. Hoping I get lucky also looking to designate a path to a folder.

Any help would be appreciated.
 
V

Vincent Johns

What are you doing to output the Report? For example, are you using a
Macro? My guess is that you may need to write some VBA code (in a
Module) to be able to compute your file name at run time. If you're
already doing that, please post your code, and someone here can suggest
how to have it compute the file name.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top