Missing Reference or Macro???

[Ashley]

I use a program within Access that allows me to
automatically send a letter with the persons address
already entered into the letter from the database.

When I try to use this function from one part of the
program, Word should pop up with the letter. Nothing
happens.

When I try and use this function from another area, this
pops up: "The expression On Click you entered as the
event property setting produced the following error:
There was a problem accessing a property or method of the
OLE object. The expression may not result in the name of
a macro, the name of a user-defined function, or [Event
Procedure]. There may have been an error evaluating the
funciton, event, or macro."

I tried using the help that told me that I needed to get
rid of a missing reference, but that did not work either.

Can anyone help me!?!?!?!

 

[Steve Schapel]

Ashley,

Can you supply details of the macro?

 

[Guest]

Steve-

I tried to email you directly, but the email bounced back
to me. I don't know how to get the details of a
macro...I tried reading the help, but it just confused me
even more. Can you help? Where can I find the info on
the macro so I can supply the details? I know nothing
about Access, macros, or references. Thanks so much!

Ashley

-----Original Message-----
Ashley,

Can you supply details of the macro?

--
Steve Schapel, Microsoft Access MVP

I use a program within Access that allows me to
automatically send a letter with the persons address
already entered into the letter from the database.

When I try to use this function from one part of the
program, Word should pop up with the letter. Nothing
happens.

When I try and use this function from another area, this
pops up: "The expression On Click you entered as the
event property setting produced the following error:
There was a problem accessing a property or method of the
OLE object. The expression may not result in the name of
a macro, the name of a user-defined function, or [Event
Procedure]. There may have been an error evaluating the
funciton, event, or macro."

I tried using the help that told me that I needed to get
rid of a missing reference, but that did not work either.

Can anyone help me!?!?!?!

.

 

[Steve Schapel]

I tried to email you directly, but the email bounced back
to me.

This is "by design"

I don't know how to get the details of a
macro...I tried reading the help, but it just confused me
even more. Can you help? Where can I find the info on
the macro so I can supply the details?

The first step is to identify the "Event" which is supposed to activate
the macro. For example, if the action is supposed to happen when you
click a command button on a form, then we are talking about the Click
event of the button. In this case, to find the details, you would open
the form in design view, select the command button, open its property
sheet, find the On Click line, and see what's written there. It will
either be the name of a macro, which you can then find in the Macros tab
of the Database Window, open it in design view, and see what the macro
details are. Or it will say Event Procedure, in which case we are
talking about a VBA procedure and not a macro. In this case, you can
click the ellipsis (...) button to the right of the property box, and
this will open the Visual Basic Editor window and show you the VBA code
which is running on the button's Click event.

Hope that helps. It is a big topic.

 

[Guest]

So I found everything you were talking about. There
isn't anything in the block beside On Click. Also, I saw
no macros. When I tried to open the VBA, it was blocked
by a password (probably by the guy that developed our
program).

The thing is, my other co-worker that also has the system
didn't have anything written in those blocks either, but
doesn't have a problem.

I have Office 2003, and I thought that maybe my Access
2002 program wasn't communitcating properly, so I
upgraded to Access 2003. It still hasn't helped.

The guy that developed our program said it was something
with my computer...something with Word and Access not
communicating properly. I just don't know if that's the
case. I guess it is since it works fine for my co-
worker. She runs on 2002. Do you think it's something
with 2003?

Got any more suggestions?

 

[Steve Schapel]

Ashley,

I am sorry, I am not able to help with this. I think you will need to
get an experienced Access programmer to have a look at the database.
What you're saying doesn't quite make sense to me... in my experience,
if something happens (or is supposed to happen) when you click a Command
Button, then there must be a macro or VBA procedure assigned on the On
CLick event handler of the command button.

 

[Ashley]

Steve,

Okay. Thanks so much for your time and for trying to
help!

Ashley

 

[Eric]

The button could be using the Hyperlink Subaddress.

Open the form, click on View then Design View.
Doubleclick on the button and select the Format tab.
It's the 7th item down.

Eric