Command button to display a report

[Not Me]

Hi,

This must be a simple problem, I can't beleive I was unable to find a
solution on google, but anyway here's the problem:

I have a command button, in it's onclick property I have an event procedure:

Private Sub Command15_Click()
DoCmd.OpenReport "My Report", acViewPreview
End Sub

Now when I click the command button I get the following error:

"The expression on click you entered as the event property setting produced
the following error: a problem occured while MS Access was communicating
with the OLE server or ActiveX Control.. blah blah"

[Allen Browne]

The error message indicates that there is a general problem with your
database.

First, from the code window choose References on the Tools menu.
Does the word "MISSING" appear beside any references?
If so, see:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Not Me" <su**@sumwhere.fake> wrote in message
news:bo**********@ucsnew1.ncl.ac.uk...

This must be a simple problem, I can't beleive I was unable to find a
solution on google, but anyway here's the problem:

I have a command button, in it's onclick property I have an event procedure:
Private Sub Command15_Click()
DoCmd.OpenReport "My Report", acViewPreview
End Sub

Now when I click the command button I get the following error:

"The expression on click you entered as the event property setting produced the following error: a problem occured while MS Access was communicating
with the OLE server or ActiveX Control.. blah blah"

[Not Me]

"Allen Browne" <al*********@SeeSig.invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

"Not Me" <su**@sumwhere.fake> wrote in message
news:bo**********@ucsnew1.ncl.ac.uk...

Now when I click the command button I get the following error:

"The expression on click you entered as the event property setting produced

the following error: a problem occured while MS Access was communicating
with the OLE server or ActiveX Control.. blah blah"

The error message indicates that there is a general problem with your
database.

First, from the code window choose References on the Tools menu.
Does the word "MISSING" appear beside any references?
If so, see:
http://allenbrowne.com/ser-38.html

Sadly I don't have that problem - any other ideas?

Chris

[Not Me]

"Not Me" <su**@sumwhere.fake> wrote in message
news:bo**********@ucsnew1.ncl.ac.uk...

"Allen Browne" <al*********@SeeSig.invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

"Not Me" <su**@sumwhere.fake> wrote in message
news:bo**********@ucsnew1.ncl.ac.uk...

Now when I click the command button I get the following error:

"The expression on click you entered as the event property setting

produced

the following error: a problem occured while MS Access was communicating with the OLE server or ActiveX Control.. blah blah"

The error message indicates that there is a general problem with your
database.

First, from the code window choose References on the Tools menu.
Does the word "MISSING" appear beside any references?
If so, see:
http://allenbrowne.com/ser-38.html

Sadly I don't have that problem - any other ideas?

Hmm I might be on the way to fixing it - I don't get the error if I create a
new form and copy&paste the button in so it must be to do with some other
controls..

Chris

[wodge]

This link solved the problem for me:

http://p2p.wrox.com/archive/access/2002-12/16.asp

Read post #4, by Hagai Gold - I followed the procedure and am now happy.

:)

[WannaKatana]

Renaming the form worked, don't have to go through all those steps mentioned in the referred to link.

Joel