From: Gratton on
I built a very small database in Access 2003 SP3 on a Windows 7 PC.
Everything works fine on My PC, but when I send the MDB file to Someone to
view my demo Form they get the following Error.
"The expression ON Click you entered as the event property setting produced
the following error: Object or Class does not support the set of events."
What is going wrong on thier PC.

Thanks for any help...
From: Arvin Meyer [MVP] on
They may have a missing reference. Open any code window, and go to Tools >>>
References and look for any marked as missing. Browse to it and make sure it
is found.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Gratton" <Gratton(a)discussions.microsoft.com> wrote in message
news:9C04A85B-B86F-4B95-8FE6-EEFAADC70392(a)microsoft.com...
>I built a very small database in Access 2003 SP3 on a Windows 7 PC.
> Everything works fine on My PC, but when I send the MDB file to Someone to
> view my demo Form they get the following Error.
> "The expression ON Click you entered as the event property setting
> produced
> the following error: Object or Class does not support the set of events."
> What is going wrong on thier PC.
>
> Thanks for any help...


From: Gratton on
Thanks Arvin,

But i'm a little confused. I built this DB after doing a fresh install of
Access 2003. I didn't add any Additional references myself. I just went with
what was installed. So; when i start adding code for my button on a form, do
refences get added based on certain bits of code i write. I used a piece of
code from the help file that allows the user to browse thier system to select
a file to work with. This is the first line of that code. "With
Application.FileDialog(3)" I've never used this code before. So maybe that 's
the problem. My confusion is; if it's working on my pc after a fresh install
why would it not work on someone elses PC; AND how does one go about sending
DB's to friends, family, Potentail employers so that Forms and Code Work as
they do on my PC and still allow them to view the code if needed. In other
words, I DON"T want to send an mde file.

Thanks for any advice.

"Arvin Meyer [MVP]" wrote:

> They may have a missing reference. Open any code window, and go to Tools >>>
> References and look for any marked as missing. Browse to it and make sure it
> is found.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.accessmvp.com
> http://www.mvps.org/access
>
>
> "Gratton" <Gratton(a)discussions.microsoft.com> wrote in message
> news:9C04A85B-B86F-4B95-8FE6-EEFAADC70392(a)microsoft.com...
> >I built a very small database in Access 2003 SP3 on a Windows 7 PC.
> > Everything works fine on My PC, but when I send the MDB file to Someone to
> > view my demo Form they get the following Error.
> > "The expression ON Click you entered as the event property setting
> > produced
> > the following error: Object or Class does not support the set of events."
> > What is going wrong on thier PC.
> >
> > Thanks for any help...
>
>
> .
>
From: Arvin Meyer [MVP] on
Were the references checked? Are any marked missing?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Gratton" <Gratton(a)discussions.microsoft.com> wrote in message
news:04F99197-2F31-4875-BE39-3B5BBD29E118(a)microsoft.com...
> Thanks Arvin,
>
> But i'm a little confused. I built this DB after doing a fresh install of
> Access 2003. I didn't add any Additional references myself. I just went
> with
> what was installed. So; when i start adding code for my button on a form,
> do
> refences get added based on certain bits of code i write. I used a piece
> of
> code from the help file that allows the user to browse thier system to
> select
> a file to work with. This is the first line of that code. "With
> Application.FileDialog(3)" I've never used this code before. So maybe that
> 's
> the problem. My confusion is; if it's working on my pc after a fresh
> install
> why would it not work on someone elses PC; AND how does one go about
> sending
> DB's to friends, family, Potentail employers so that Forms and Code Work
> as
> they do on my PC and still allow them to view the code if needed. In other
> words, I DON"T want to send an mde file.
>
> Thanks for any advice.
>
> "Arvin Meyer [MVP]" wrote:
>
>> They may have a missing reference. Open any code window, and go to Tools
>> >>>
>> References and look for any marked as missing. Browse to it and make sure
>> it
>> is found.
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.accessmvp.com
>> http://www.mvps.org/access
>>
>>
>> "Gratton" <Gratton(a)discussions.microsoft.com> wrote in message
>> news:9C04A85B-B86F-4B95-8FE6-EEFAADC70392(a)microsoft.com...
>> >I built a very small database in Access 2003 SP3 on a Windows 7 PC.
>> > Everything works fine on My PC, but when I send the MDB file to Someone
>> > to
>> > view my demo Form they get the following Error.
>> > "The expression ON Click you entered as the event property setting
>> > produced
>> > the following error: Object or Class does not support the set of
>> > events."
>> > What is going wrong on thier PC.
>> >
>> > Thanks for any help...
>>
>>
>> .
>>