RunCommand and Save As and PivotChart and Data Access Page (1 Viewer)

MSAccessUser

Registered User.
Local time
Today, 02:25
Joined
Aug 17, 2005
Messages
21
Ok, reading the numerous search posts on 'Data Access Pages' it appears there are more questions than answers on this topic.

Unfortunately, I'm adding to the questions and hoping that I can get a response to this one.

I would like to use VBA to save my 'Pivot Chart' view on a table as a Data Access Page. Currently I do this manually by using the 'Save As' command in the File menu.

How can I do this using VBA? I thought the docmd.RunCommand would be an option but unexplicitly the 'Save As' Data Access Page is unavailable.:confused:
 

MSAccessUser

Registered User.
Local time
Today, 02:25
Joined
Aug 17, 2005
Messages
21
Please, any assistance on this would be so appreciated. This is the last piece of the equation and I'm all done with this project.
 

Users who are viewing this thread

Top Bottom