SnapShot file

[Jim W]

Could someone please tell me how to creat a command button on a tool bar so I can export a report to a snap shot file.

Jim

 

[Cosmos75]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46567&highlight=snapshot

DoCmd.OutputTo acReport, stDocName, "SnapshotFormat(*.snp)", FileName, True, ""

replace
- stDocName with name of your report
- FileName with what you wish to name the file.

Hopefully the above thread will help.

 

[IMO]

For the button you will need to create a macro and drag it onto the menu bar.

IMO

 

[Jim W]

DoI have to use a macro or can I use code?

Jim

 

[Cosmos75]

U can use either a macro or VBA code. VBA code gives you more control over what happens.

Hope this helps!

 

[Jim W]

Could you please assit. I think I have the code right but how do I get a command button on the toolbar to attach the code to

 

[Cosmos75]

Scratch my response. I did not notice you needed to put the button on the toolbar. For that you need to use a macro.

Once you've created the Macro you just need to drag the icon of the macro to the toolbar.

 

[Jim W]

Ok I understand but am having a bit of trouble - I creat a marco that outputs a report to a snapshot file and then drag to to the tool bar and that does work. However, I want the tool bar macro to work with different reports. meaning which ever report is shown then that is the one it outputs. Does this make sense?
Is there a nother way to do this?

Thanks for the help and time

Jim

 

[Cosmos75]

Here's an example with;

1) Macro Buttons in toolbar (one for each report)
2) Form with buttons to handle saving as snapshot files. tblReports holds the name of the report in Access and a description.

 

[Jim W]

Thank you. That works great.

Jim

 

[Cosmos75]

Jim W,

No problem, glad to be of help! (a rare occurance )

Just curious, Did you end up using a form for your reports of putting a macro button for each report?

 

[Jim W]

I used the form it works well.
Thank you

Jim