Error before opening a report.

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Error before opening a report.

Post by Pat »

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.

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Error before opening a report.

Post by Pat »

I have solved it, i redeigned the form that calls the reports. I haven't worked out why the old one bombed though.

User avatar
Tom Wickerath
NewLounger
Posts: 4
Joined: 06 Mar 2011, 22:30
Status: Microsoft MVP

Re: Error before opening a report.

Post by Tom Wickerath »

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;

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Error before opening a report.

Post by Pat »

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.