I have a table that has a WORD file embedded in it. The word file is
opened succesfully through a command button located on the form with
the following:

Me![gpcopy].Verb = -2
Me![gpcopy].Action = acOLEActivate

I attempted to duplicate this approach with another access 2000
database, but I get the error message that the VERB and ACTION
properties are not available. What is even more surprising, I created
a new form with a command button on the working database, the new form
also fails. The existing working form still works as expected.

Any clues as to why the VERB and ACTION properties cannot now be
accessed?.

What type of control are you trying to do this with in the cases that don't
work? Only the Bound Object Frame Control, the Chart Control and the Unbound
Object Frame Control has an Action property. The Verb property only applies
to those three control types as well, plus to ActiveX controls.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a table that has a WORD file embedded in it. The word file is
> opened succesfully through a command button located on the form with
> the following:
>
> Me![gpcopy].Verb = -2
> Me![gpcopy].Action = acOLEActivate
>
> I attempted to duplicate this approach with another access 2000
> database, but I get the error message that the VERB and ACTION
> properties are not available. What is even more surprising, I created
> a new form with a command button on the working database, the new form
> also fails. The existing working form still works as expected.
>
> Any clues as to why the VERB and ACTION properties cannot now be
> accessed?.
>

Doug: There is no bound control as I am opening the Word Document
directly through the use of VBA code in a command button. Basically, I
am directly accessing the OLE field on the table.

Also I am troubled by the fact that when I create a new form that
duplicates what the existing form does, the VBA code fails?????????
When I created the form that works (the existing form), I do not recall
setting anything special, yet the new form fails???

I suspect that your original sample which worked did have a bound control,
with the same name as the field in the underlying recordset.

The controls I listed are the only ones that allow the Action and Verb
properties: you cannot use them with fields in a recordset.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Doug: There is no bound control as I am opening the Word Document
> directly through the use of VBA code in a command button. Basically, I
> am directly accessing the OLE field on the table.
>
> Also I am troubled by the fact that when I create a new form that
> duplicates what the existing form does, the VBA code fails?????????
> When I created the form that works (the existing form), I do not recall
> setting anything special, yet the new form fails???
>

Figured it out. Doug, you are correct there was a bound control. The
control was set to NOTvisible and I was refering to the control, which
had the same name as the field in the table. Because I failed to "see"
the control, I ended up referring to it in an incorrect manner. Thanks
for the help.