Solved Save Form As Report using VBA (1 Viewer)

[andreaerdna]

In MS Access it's possible to convert a Form to a Report using the "Save Object As" functionality (Office Button -> Save As -> Save Object As "Save the current database object as a new object").

I'd like to have the same functionality using VBA but it seems to me that none of the following relevant DoCmd methods are suitable CopyObject, OutputTo, Save, TransferDatabase.

I was unable to find any useful information, except a blog post in which a code sample is provided using the SendKeys statement, but it seems not working.

Any advice on how to proceed or to fix the SendKeys statement string in the that blog post?

 

[Gasman]

Cross posted with reply, presumably not to the o/p's liking.?

Save a Form as a Report using VBA

In MS Access it's possible to convert a Form to a Report using the "Save Object As" functionality (Office Button -> Save As -> Save Object As "Save the current database object ...

stackoverflow.com

 

[andreaerdna]

Probably I thought there was someone more experienced in this forum than on stackoverflow.

 

[theDBguy]

Hi. Welcome to AWF!

Have you checked if RunCommand will work?

Sent from phone...

 

[MajP]

Have you checked if RunCommand will work?

I did and it works. This suggests there should be a way to do this from the ribbon as well.

 

[MajP]

Demo. I can do
acCmdSaveas but not acCmdSaveAsReport. But this will save the form as a report.

 

[andreaerdna]

Thank you very much @MajP and @theDBguy !

@MajP your is a step forward!

Now I see the light!

I'd like to do it programmatically, for a given Form, without the need of the user (me) intervention (like inserting the name of the Report to be saved or selecting "Report" from the drop down list in the "Save As" window).

So, thanks to your tips I managed to obtain a working (for me) code (but also using SendKeys):

strFormName = "formname"
strReportName = "reportname"
DoCmd.SelectObject acForm, strFormName, True
SendKeys strReportName & "~"
RunCommand acCmdSaveAsReport

This however will not solve another problem: do the same thing, but in an external database.

Is there a way to avoid to:
- import the Form from the external db into the current db
- save the form as a report applying the above procedure
- delete the imported Form from the current db
- export the report to the external db
- delete the report from the current db?

Andrea