Auto name a report upon export/e-mail

[Guest]

Hi,

I am using a macro with sixteen steps. Those steps essentially involve
opening a report with certain "where" conditions, sending the report to a
particular group, closing the report, opening the same report under different
"where" conditions, sending to a different group, exporting to a shared
drive, and closing.

I do this every day, and the only missing link is that I would like Access
to auto name the report with the date as a suffix (e.g. instead of
"unresolved", I would like "unresolved_07-09-11"). I found a tip on how to
do this in VBA; however, I don't feel comfortable at all with VBA. I'm
become proficient in primarily using the gui methods (macros, QBE grid, etc.)
and am pretty comfortable with several different commands.

I tried using the format function in the output to field within the macro,
as in output to: "i:\reports\unresolved_"&Format(Date(),"yy-mm-dd")&".snp"

But I get an error saying "The report snapshot was not created......not
enough free disk space for temporary work files..." I've definitely narrowed
the problem down to trying to use the format command - is it impossible to do
this within a macro? I really have no idea how to do all 16 commands within
VBA.

Sorry to be so detailed - and I appreciate any tips/advice on this issue!
Thanks, Jenny

 

[Guest]

try
"i:\reports\unresolved_"&Format(Date,"yymmdd")&".snp"

 

[Guest]

Hi Chris,

I tried that but get the same error message

 

[Guest]

Have you tried converting the macro to VB using the macro to VB converter?

 

[Guest]

No! That sounds GREAT! How do I do that? I've never even heard of a macro
to VB converter! Thank you!!

 

[Douglas J. Steele]

Right-click on the macro in the database window, select Save As/Export...
from the context menu, and choose Save as Visual Basic Module.

You can also do it through the File menu.