yourfriendangela
Registered User.
- Local time
- Today, 01:07
- Joined
- Jul 24, 2012
- Messages
- 22
Hello all,
I would really appreciate it if someone could help me out with this nagging problem! (Access 2007-2010)
I created a form with a SendObject VBA code so I can simply click a cmd button to e-mail out a report.
This process works fine normally, but occasionally and randomly, when I open up my database and use the button, an error appears: "Return without GoSub." It says "the location of the logic for the event cannot be evaluated."
The report has an On Open [Event Procedure] vba code to send an e-mail. So, the problem is that it won't run the procedure since the report is running into an error when opening, i.e. "Return without GoSub."
I don't have any subforms or subtables in my form or report. My VBA code should be fine, and it's pretty simple. I can put it on here if that would help...
Anybody have any ideas what the problem is?? I could use any advice! Thanks!!
I would really appreciate it if someone could help me out with this nagging problem! (Access 2007-2010)
I created a form with a SendObject VBA code so I can simply click a cmd button to e-mail out a report.
This process works fine normally, but occasionally and randomly, when I open up my database and use the button, an error appears: "Return without GoSub." It says "the location of the logic for the event cannot be evaluated."
The report has an On Open [Event Procedure] vba code to send an e-mail. So, the problem is that it won't run the procedure since the report is running into an error when opening, i.e. "Return without GoSub."
I don't have any subforms or subtables in my form or report. My VBA code should be fine, and it's pretty simple. I can put it on here if that would help...
Anybody have any ideas what the problem is?? I could use any advice! Thanks!!
