Aug 6, 2006 #1 kopy Technical User May 30, 2002 141 US I would like to start the Report Wizard from VBA using a command button. I'm not sure where to begin. Any help is appreciated. Thanks, Kopy
I would like to start the Report Wizard from VBA using a command button. I'm not sure where to begin. Any help is appreciated. Thanks, Kopy
Aug 6, 2006 #2 ZmrAbdulla Technical User Apr 22, 2003 4,364 AE [tt]DoCmd.RunCommand acCmdNewObjectReport[/tt] ________________________________________________________ Zameer Abdulla Help to find Missing people Sharp acids corrode their own containers. Upvote 0 Downvote
[tt]DoCmd.RunCommand acCmdNewObjectReport[/tt] ________________________________________________________ Zameer Abdulla Help to find Missing people Sharp acids corrode their own containers.
Aug 6, 2006 Thread starter #3 kopy Technical User May 30, 2002 141 US Thanks for the reply. What I am trying to do is go directly into the Report Wizard for a designated query. I found the following code: Application.Run "acwztool.frui_entry", "qryQBF", acReport When I run it, I get an error message: The form name 'frui_frmMain' is misspelled or refers to a form that doesn't exist. Upvote 0 Downvote
Thanks for the reply. What I am trying to do is go directly into the Report Wizard for a designated query. I found the following code: Application.Run "acwztool.frui_entry", "qryQBF", acReport When I run it, I get an error message: The form name 'frui_frmMain' is misspelled or refers to a form that doesn't exist.
Aug 6, 2006 #4 TheAceMan1 Programmer Sep 23, 2003 11,174 US How are ya kopy . . . Have a look here Run wizards from code See Ya! . . . . . . Upvote 0 Downvote