Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: alananderson
- Order by date
-
Hide the Access Window
Hi All, Problem solved. I had entered those lines on the corresponding lines of the report's property list. By changing those lines to event prcedure and placing these lines in code as in following example it now works : Private Sub Report_Open(Cancel As Integer) DoCmd.RunMacro "mcrRestore"...- alananderson
- Post #8
- Forum: Microsoft: Access Forms
-
Hide the Access Window
Hi, I really do appreciate your help. When I insert those lines in the on open and OnClose Events I get error message: Error 2485: Microsoft Office Access can't find the macro 'DoCmd' Any ideas? Thanks, Alan- alananderson
- Post #7
- Forum: Microsoft: Access Forms
-
Hide the Access Window
Hi All, I found the problem with the print. JKLO is correct - printing without preview will work IF one does NOT put: In the OnOpen: DoCmd.RunMacro "mcrRestore" In the OnClose: DoCmd.RunMacro "mcrHide" However, leaving that out means one can't preview reports. Anyone...- alananderson
- Post #5
- Forum: Microsoft: Access Forms
-
Hide the Access Window
Hi, jklo - I get the same error for preview and print. The code used for printing is : DoCmd.OpenReport stDocName, acNormal - is this the problem? Lionel hill - thanks for that but I really don't understand what you are saying. My case involves a Main Menu (unbound form) which calls...- alananderson
- Post #4
- Forum: Microsoft: Access Forms
-
Hide the Access Window
thread702-1494964 Hi, Firstly I'm developing in Access 2003 and need programme to run on both 2003 and 2007 (at least) I've used the code as posted in FAQ705-2562 which works well for forms. Two issues: 1. When I run reports I get Error Message 2486:MS Access ant find the macro 'DoCmd' - any...- alananderson
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
-
Hide the Access Window
thread702-1494964 Hi All, I'm using Access 2003 and need to run my programme on 2003 and 2007 (at least) I've used the code from FAQ705-2562 which is working really well for my forms but I'm getting error messages when I try to run reports. Error 2485: Microsoft Office Access can't find the...- alananderson
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
