Export SNP Format

[FlaSquid]

Is there a way to automatically generate a filename to use in a macro
that exports an Access Report in SNP (Snapshot) format?

I have a set of reports which I wrote in Accessthat I run often
against different customer's data (a commercial accounting program
with MS/SQL Server data. Would really like the macro to put the
customer's name in the filename of the export file.

Something like this in the Macro Properties Grid: ??

Object Type: Report
Object Name: CashReceipts
Output Format: Snapshot Format
Output File: "C:\My Documents\"CashReceips" &
"DLookUp("ClientName","Customers","CustID=" & 1)""

Where the DLookup would pull the Client's name from a table called
Customers.

You prolly figgered out that I don't know how to write code or use
Modules.

Thanks < Advance,

Chris Cave

 

[Tom Wickerath]

Hi Chris,

It's time to learn how to write code, in order to achieve the goal you desire. Turns out you can
change the caption property of a report on-the-fly, using VBA code. A snapshot will pick up the
caption as the root portion of it's filename, as in MyCaption.snp.

Tom
_______________________________


Is there a way to automatically generate a filename to use in a macro
that exports an Access Report in SNP (Snapshot) format?

I have a set of reports which I wrote in Accessthat I run often
against different customer's data (a commercial accounting program
with MS/SQL Server data. Would really like the macro to put the
customer's name in the filename of the export file.

Something like this in the Macro Properties Grid: ??

Object Type: Report
Object Name: CashReceipts
Output Format: Snapshot Format
Output File: "C:\My Documents\"CashReceips" &
"DLookUp("ClientName","Customers","CustID=" & 1)""

Where the DLookup would pull the Client's name from a table called
Customers.

You prolly figgered out that I don't know how to write code or use
Modules.

Thanks < Advance,

Chris Cave