Re: Custom Report File Name

Tech-Archive recommends: Speed Up your PC by fixing your registry

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 <vjohns@xxxxxxxxxxxxxxxxxx>
Please feel free to quote anything I say here.


chopper57 via AccessMonster.com wrote:

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.

.

Relevant Pages

  • Re: Create macro which automaticallly creates PDF of a report
    ... It will automatically convert a report into a pdf file. ... when the macro is executing. ... function that then runs the desired VBA code. ...
    (microsoft.public.access.reports)
  • Report to Output
    ... A macro to sent query by form data to a report works. ... VBA code to replace the macro I get an error. ... The error states that using ...
    (microsoft.public.access.reports)
  • RE: matching data from 3 different sources
    ... Whilst I agree that macros (VBA code) can be very useful, ... setup I would have thought that you could ideally have an ODBC sheet set up ... for all the employees you wish to report on and have simply added the various ... vlookup you can automatically show it as not attempted. ...
    (microsoft.public.excel.misc)
  • Re: Creating a directory
    ... I tried to adapt this code to my database. ... Allen Browne - Microsoft MVP. ... In another report I use the On Format event for the Detail Section to trigger an option to add a border to a field's value "if IsNull" is true or no border if false. ... I tried something similar but there were no events to trigger the VBA code I want to use which would open the second table and find a record/name. ...
    (microsoft.public.access.reports)
  • Re: How calculate percent difference between fields in same group
    ... Tips for Access users - http://allenbrowne.com/tips.html ... because of the way i have the report configured the yearly totals are ... > with VBA code outside usiing recommendations of others. ... My> calculation ...
    (microsoft.public.access.reports)