Macro Output File Naming Problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: tawana_white@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx (data123)
Date: Thu, 11 Aug 2005 11:47:47 -0500

I 'm setting up a macro to export a file. How do I export a file with
a specific parameter as the file name? For instance I wanted to name
the file based on the specific field in the report.
I am running muliple reports for muiltple users and I want to name the
report based on the user Id I'm running the report on.

I tried using
c:\[reports]![test]!_usagereport.rtf as the file name
I getting the file name as [reports]![test]![userid]_usagereport.rtf

instead of userid1_usagereport.rtf

How do I fix this?

.

Follow-Ups:
- Re: Macro Output File Naming Problem
  - From: Steve Schapel

Prev by Date: Re: Macros and SubForms
Next by Date: Automatically create labels from my database
Previous by thread: Access 2003 - Sandbox Mode - Setting Macro Security to Low
Next by thread: Re: Macro Output File Naming Problem
Index(es):
- Date
- Thread

Relevant Pages

Export file with parameter in file name
... I am running muliple reports for muiltple users and I want to name the ... report based on the user Id I'm running the report on. ... Prev by Date: ...
(microsoft.public.access.externaldata)
Re: Macro Output File Naming Problem
... Steve Schapel, Microsoft Access MVP ... the file based on the specific field in the report. ... I am running muliple reports for muiltple users and I want to name the ...
(microsoft.public.access.macros)
Re: Date range on reports
... box to your report with a control source like: ... > In the Database window (Database window: The window that appears when you ... > In the New Form dialog box, click Design View, and click OK. ... > Begin by clicking Macro Names to display the Macro Name column. ...
(microsoft.public.access.reports)
Re: Date range on reports
... Create an unbound form (unbound form or report: A form or report that isn't ... In the Database window (Database window: The window that appears when you ... In the New Form dialog box, click Design View, and click OK. ... Begin by clicking Macro Names to display the Macro Name column. ...
(microsoft.public.access.reports)
Re: Date range on reports
... Without knowing where your report parameters were coming from, ... >>> open an Access database or an Access project. ... >>> In the New Form dialog box, click Design View, and click OK. ... >>> Begin by clicking Macro Names to display the Macro Name column. ...
(microsoft.public.access.reports)