Thanks Lightning,
But as before the switchboard continues to print. The following is the code for the switchboard.
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.
' Move to the switchboard page that is marked as the default...
Thanks for the reply. I tried it nut it continues to print the switchboard. I modifed the macro code to and it now looks like the following but it stil prints the report followed by the switchboard.
Print_NHP_List
'
'------------------------------------------------------------
Function...
The following link will take you to a MSDN library article explaining pivot tables for Access 2002. If the link does not work search the MSDN Library for:
Programming PivotTable Reports in Microsoft Access 2002
Keith Fink, Frank C. Rice...
I created a macro to print a report using a switchboard command button, the report prints followed by a print of the swtichboard screen. I can not seem to find a way to stop it. I recreated the macro, the switchboard and converted the macro to VBA to find the error but can not find it. Below is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.