Welcome to UtterAccess! Active Topics. Search this forum only? More Search Options. Please Wait Site Message.
|Published (Last):||5 February 2017|
|PDF File Size:||5.13 Mb|
|ePub File Size:||10.62 Mb|
|Price:||Free* [*Free Regsitration Required]|
Forums New posts Search forums. What's new New posts New profile posts Latest activity. Members Current visitors New profile posts Search profile posts. Log in Register. Search titles only. Search Advanced search….
SetFocus command, but once that. SetFocus has been run, the DoCmd. PrintOut code on the form wouldn't be run Rich Guest. Use a custom menu bar. Custom menu bar Anyway, what I did was save the values in various text boxes on the form to variables. Then I closed the form with a DoCmd.
The report becomes active by default but code in form is still running. Then I printed the Report still in the code on the Form that is closed. Then I opened the form back up with a DoCmd, and restored the text boxes' values from the variables. When did I become a senior member? Does membership have its privilages? Local time Today, Joined Apr 25, Messages You mean you did: DoCmd.
PrintOut , , , , qty DoCmd. Not quite, CALV. Close acForm, "FORM 2", acSaveNo It would probably be better to set the focus here to the report, just to make sure something else doesn't have it for some reason, but since the report is currently the only object open PrintOut DoCmd. Local time Today, Joined Jun 21, Messages RunCommand acCmdPrint This will give you the option of the dialog box, and should also keep the focus on the Report Preview.
Wayne gave me this code and I use it quite a bit. The only thing is you need to put error handling for "Cancel". I knew someone would have a better way of doing this. Thanks, rube. You must log in or register to reply here. Top Bottom.
DoCmd.PrintOut method (Access)
Log In. Hope This Helps, PH. FAQ How can I maximize my chances of getting an answer? Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
Subscribe to RSS
print report from form with DoCmd
Forums New posts Search forums. What's new New posts New profile posts Latest activity. Members Current visitors New profile posts Search profile posts. Log in Register. Search titles only.