Running a report from a VB script
in [Reports]
|
Prev: amizade
Next: 2007 Toolbars On Reports
From: TonyWilliams via AccessMonster.com on 6 Apr 2010 09:57 Hi John I now have a moduke called ModmacInvoice and a Function called macinvoice. When I run the script Access opens briefly on the screen then disappears. So I've got rid of the error message but nothing is happening now. Any more ideas? No comment from Albert but I hope he picks this up as it's his script I'm using. Cheers tony John Spencer wrote: >Did you change the name in the script? You should not do that. >You change the name of the VBA code module. > >SO in the AccessApp (TimeAndBilling) you would have a module named >ModMacInvoice and in that module you would have a FUNCTION named MacInvoice. >If that does not fix the problem, then I hope Albert Kallal happens onto this >thread. > >Then the script would use MacInvoice. > >John Spencer >Access MVP 2002-2005, 2007-2010 >The Hilltop Institute >University of Maryland Baltimore County > >> Thanks John. I changed the name as you suggested but still get a message that >> says Access can't find the procedure "Modmacinvoice" with error code 800A09D5 >[quoted text clipped - 22 lines] >>>>> Thanks >>>>> Tony -- Why don't my grey cells communicate with each as fast as they used to? I hate getting old! Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201004/1
From: John Spencer on 6 Apr 2010 16:02 I really don't have anything further. I might try to actually PRINT the report instead of attempting to preview it. However in either case, you need to correct the code. 'Note that your report name has a space in it. That means you are going to have to bracket the name in order to use it or change the report name to get rid of the spaces. DoCmd.OpenReport "[Invoice List]",acViewNormal or perhaps the following will work with the corrections to the arguments. DoCmd.OpenReport "[Invoice List]",acViewPreview,,,acWindowNormal John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County TonyWilliams via AccessMonster.com wrote: > Hi John I now have a moduke called ModmacInvoice and a Function called > macinvoice. When I run the script Access opens briefly on the screen then > disappears. So I've got rid of the error message but nothing is happening now. > > Any more ideas? No comment from Albert but I hope he picks this up as it's > his script I'm using. > Cheers > tony > > John Spencer wrote: >> Did you change the name in the script? You should not do that. >> You change the name of the VBA code module. >> >> SO in the AccessApp (TimeAndBilling) you would have a module named >> ModMacInvoice and in that module you would have a FUNCTION named MacInvoice. >> If that does not fix the problem, then I hope Albert Kallal happens onto this >> thread. >> >> Then the script would use MacInvoice. >> >> John Spencer >> Access MVP 2002-2005, 2007-2010 >> The Hilltop Institute >> University of Maryland Baltimore County >> >>> Thanks John. I changed the name as you suggested but still get a message that >>> says Access can't find the procedure "Modmacinvoice" with error code 800A09D5 >> [quoted text clipped - 22 lines] >>>>>> Thanks >>>>>> Tony >
From: TonyWilliams via AccessMonster.com on 7 Apr 2010 06:06 John I've put brackets around the report name and this time I get an error message that says can't find the report [Invoice List] I've also changed the name to InvoiceList and when I run the script Access opens fleetingly then closes. Really frustrating! Thanks for your suggestions though. Tony John Spencer wrote: >I really don't have anything further. I might try to actually PRINT the >report instead of attempting to preview it. However in either case, you need >to correct the code. > >'Note that your report name has a space in it. That means you are going to >have to bracket the name in order to use it or change the report name to get >rid of the spaces. > >DoCmd.OpenReport "[Invoice List]",acViewNormal > >or perhaps the following will work with the corrections to the arguments. > >DoCmd.OpenReport "[Invoice List]",acViewPreview,,,acWindowNormal > >John Spencer >Access MVP 2002-2005, 2007-2010 >The Hilltop Institute >University of Maryland Baltimore County > >> Hi John I now have a moduke called ModmacInvoice and a Function called >> macinvoice. When I run the script Access opens briefly on the screen then >[quoted text clipped - 25 lines] >>>>>>> Thanks >>>>>>> Tony -- Why don't my grey cells communicate with each as fast as they used to? I hate getting old! Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201004/1
From: John Spencer on 7 Apr 2010 08:27 Sorry. I get so used to bracketing anything that does not follow my naming convention that I got carried away. You are correct that the brackets should NOT be there in this case. I am out of ideas at this point. And I don't have time to attempt testing. You might try reposting your problem. By now, the thread has gotten long enough that many people that might help are no longer watching the thread. I hope you solve this one. I am looking forward to seeing a solution. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County TonyWilliams via AccessMonster.com wrote: > John I've put brackets around the report name and this time I get an error > message that says can't find the report [Invoice List] I've also changed the > name to InvoiceList and when I run the script Access opens fleetingly then > closes. > > Really frustrating! > Thanks for your suggestions though. > Tony > > John Spencer wrote: >> I really don't have anything further. I might try to actually PRINT the >> report instead of attempting to preview it. However in either case, you need >> to correct the code. >> >> 'Note that your report name has a space in it. That means you are going to >> have to bracket the name in order to use it or change the report name to get >> rid of the spaces. >> >> DoCmd.OpenReport "[Invoice List]",acViewNormal >> >> or perhaps the following will work with the corrections to the arguments. >> >> DoCmd.OpenReport "[Invoice List]",acViewPreview,,,acWindowNormal >> >> John Spencer >> Access MVP 2002-2005, 2007-2010 >> The Hilltop Institute >> University of Maryland Baltimore County >> >>> Hi John I now have a moduke called ModmacInvoice and a Function called >>> macinvoice. When I run the script Access opens briefly on the screen then >> [quoted text clipped - 25 lines] >>>>>>>> Thanks >>>>>>>> Tony >
From: TonyWilliams via AccessMonster.com on 7 Apr 2010 08:33
Thanks John for your help anyway. Is reposting OK? I know someforums don't like it. Tony John Spencer wrote: >Sorry. I get so used to bracketing anything that does not follow my naming >convention that I got carried away. You are correct that the brackets should >NOT be there in this case. > >I am out of ideas at this point. And I don't have time to attempt testing. > >You might try reposting your problem. By now, the thread has gotten long >enough that many people that might help are no longer watching the thread. > >I hope you solve this one. I am looking forward to seeing a solution. > >John Spencer >Access MVP 2002-2005, 2007-2010 >The Hilltop Institute >University of Maryland Baltimore County > >> John I've put brackets around the report name and this time I get an error >> message that says can't find the report [Invoice List] I've also changed the >[quoted text clipped - 29 lines] >>>>>>>>> Thanks >>>>>>>>> Tony -- Why don't my grey cells communicate with each as fast as they used to? I hate getting old! Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201004/1 |