MS Access 2003 Report VBA coding that looped through the report and assigned a number based on a single field to add a table of content page numbers to first page (report header) doesn't fully load/activate unless the user switches to design view and then back to print view.
I am having IT check for any security or computer policy changes that may have impacted this code. In the meantime, I would like to have the report automatically (using VBA or macro) open as it normally would then switch to design view and back to print preview so that the end users wouldn't have to do this each time.
Is there a way to automate these view changes and where do I put the coding to do so?
I am having IT check for any security or computer policy changes that may have impacted this code. In the meantime, I would like to have the report automatically (using VBA or macro) open as it normally would then switch to design view and back to print preview so that the end users wouldn't have to do this each time.
Is there a way to automate these view changes and where do I put the coding to do so?
