Error before opening a report.
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Error before opening a report.
I keep getting the following error when hitting the button to open the report. I have put a stop as the first command in the sub that calls the openreport and it doesn't even reach the stop.
You do not have the required permissions to view the files attached to this post.
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: Error before opening a report.
I have solved it, i redeigned the form that calls the reports. I haven't worked out why the old one bombed though.
-
- NewLounger
- Posts: 4
- Joined: 06 Mar 2011, 22:30
- Status: Microsoft MVP
Re: Error before opening a report.
Hi Pat,
I would verify that you do not have any references marked as MISSING, and that your VBA code compiles without any errors. Here are some good articles on references in Access applications:
Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html" onclick="window.open(this.href);return false;
Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/Acces ... rrors.html" onclick="window.open(this.href);return false;
I would verify that you do not have any references marked as MISSING, and that your VBA code compiles without any errors. Here are some good articles on references in Access applications:
Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html" onclick="window.open(this.href);return false;
Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/Acces ... rrors.html" onclick="window.open(this.href);return false;
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: Error before opening a report.
All references are NOT missing, that was one of the first things i checked.
As i said i won't worry about it now, but thanks for the references.
Thinking about this further, i believe the form is corrupt, as i put another button on it to do nothing at first (no code behind it) and that worked (meaning it did nothing which is what i expected), then put code behind it and up came the error again.
As i said i won't worry about it now, but thanks for the references.
Thinking about this further, i believe the form is corrupt, as i put another button on it to do nothing at first (no code behind it) and that worked (meaning it did nothing which is what i expected), then put code behind it and up came the error again.