Prev: hi people check email now
Next: Access 2007 and connecting to SQL server 2008
From: Dorian on 31 Dec 2009 17:21
If I rename the function to begin with an X, it starts working.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Douglas J. Steele" wrote:

> Also, is the function in a stand-alone module, as opposed to a class module
> (or a module associated with a form or report)?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Duane Hookom" <duanehookom(a)NO_SPAMhotmail.com> wrote in message
> news:2AD3CD2C-E17F-4272-8120-8D0AADA53978(a)microsoft.com...
> > Do you have two functions with the same name?
> > Does the function share the same name as a module?
> >
> > --
> > Duane Hookom
> > Microsoft Access MVP
> >
> >
> > "Dorian" wrote:
> >
> >> Access 2003.
> >> I'm trying to run a function from an autoexec macro and am getting the
> >> message 'access cannot find the function'.
> >> I selected the function from the macros runcode ... prompt via the
> >> expression builder!
> >> Yes its a public function.
> >> Any ideas?
> >> -- Dorian
> >> "Give someone a fish and they eat for a day; teach someone to fish and
> >> they
> >> eat for a lifetime".
>
>
> .
>
From: John W. Vinson on 31 Dec 2009 17:30
On Thu, 31 Dec 2009 14:21:01 -0800, Dorian <Dorian(a)discussions.microsoft.com>
wrote:

>If I rename the function to begin with an X, it starts working.
>-- Dorian
>"Give someone a fish and they eat for a day; teach someone to fish and they
>eat for a lifetime".

What is (now) the name of the function?
What is the name of the module?

--

John W. Vinson [MVP]
From: Duane Hookom on 31 Dec 2009 17:30
I would try these trouble-shooting steps:
1) open the debug window and test your function
Press Ctrl+G then
? ClaimsCheck()
2) try create a different function that is very simple and place it in your
Autoexec macro

--
Duane Hookom
Microsoft Access MVP


"Dorian" wrote:

> I'm not sure what you mean, the function was created in a module that was
> created with Modules--New. The type is 'Module'.
> It's declared with:
> Public Function ClaimsCheck() As Boolean
> -- Dorian
> "Give someone a fish and they eat for a day; teach someone to fish and they
> eat for a lifetime".
>
>
> "Douglas J. Steele" wrote:
>
> > Also, is the function in a stand-alone module, as opposed to a class module
> > (or a module associated with a form or report)?
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no private e-mails, please)
> >
> >
> > "Duane Hookom" <duanehookom(a)NO_SPAMhotmail.com> wrote in message
> > news:2AD3CD2C-E17F-4272-8120-8D0AADA53978(a)microsoft.com...
> > > Do you have two functions with the same name?
> > > Does the function share the same name as a module?
> > >
> > > --
> > > Duane Hookom
> > > Microsoft Access MVP
> > >
> > >
> > > "Dorian" wrote:
> > >
> > >> Access 2003.
> > >> I'm trying to run a function from an autoexec macro and am getting the
> > >> message 'access cannot find the function'.
> > >> I selected the function from the macros runcode ... prompt via the
> > >> expression builder!
> > >> Yes its a public function.
> > >> Any ideas?
> > >> -- Dorian
> > >> "Give someone a fish and they eat for a day; teach someone to fish and
> > >> they
> > >> eat for a lifetime".
> >
> >
> > .
> >
From: Douglas J. Steele on 1 Jan 2010 11:30
That's what I was trying to say: that where the code is stored must have
been created as a Module, not a Class Module.

What did you name the module when you saved it?

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



"Dorian" <Dorian(a)discussions.microsoft.com> wrote in message
news:974897FE-5192-495D-BE4D-D7D8FDA2626E(a)microsoft.com...
> I'm not sure what you mean, the function was created in a module that was
> created with Modules--New. The type is 'Module'.
> It's declared with:
> Public Function ClaimsCheck() As Boolean
> -- Dorian
> "Give someone a fish and they eat for a day; teach someone to fish and
> they
> eat for a lifetime".
>
>
> "Douglas J. Steele" wrote:
>
>> Also, is the function in a stand-alone module, as opposed to a class
>> module
>> (or a module associated with a form or report)?
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Duane Hookom" <duanehookom(a)NO_SPAMhotmail.com> wrote in message
>> news:2AD3CD2C-E17F-4272-8120-8D0AADA53978(a)microsoft.com...
>> > Do you have two functions with the same name?
>> > Does the function share the same name as a module?
>> >
>> > --
>> > Duane Hookom
>> > Microsoft Access MVP
>> >
>> >
>> > "Dorian" wrote:
>> >
>> >> Access 2003.
>> >> I'm trying to run a function from an autoexec macro and am getting the
>> >> message 'access cannot find the function'.
>> >> I selected the function from the macros runcode ... prompt via the
>> >> expression builder!
>> >> Yes its a public function.
>> >> Any ideas?
>> >> -- Dorian
>> >> "Give someone a fish and they eat for a day; teach someone to fish and
>> >> they
>> >> eat for a lifetime".
>>
>>
>> .
>>

From: Douglas J. Steele on 1 Jan 2010 11:32
That implies to me that you may have named the module ClaimsCheck.

As we've been trying to tell you, the name of the module cannot be the same
as the name of any function or sub within the module.

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



"Dorian" <Dorian(a)discussions.microsoft.com> wrote in message
news:33620508-DE80-45D2-A6FF-52E33CB4B45F(a)microsoft.com...
> If I rename the function to begin with an X, it starts working.
> -- Dorian
> "Give someone a fish and they eat for a day; teach someone to fish and
> they
> eat for a lifetime".
>
>
> "Douglas J. Steele" wrote:
>
>> Also, is the function in a stand-alone module, as opposed to a class
>> module
>> (or a module associated with a form or report)?
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Duane Hookom" <duanehookom(a)NO_SPAMhotmail.com> wrote in message
>> news:2AD3CD2C-E17F-4272-8120-8D0AADA53978(a)microsoft.com...
>> > Do you have two functions with the same name?
>> > Does the function share the same name as a module?
>> >
>> > --
>> > Duane Hookom
>> > Microsoft Access MVP
>> >
>> >
>> > "Dorian" wrote:
>> >
>> >> Access 2003.
>> >> I'm trying to run a function from an autoexec macro and am getting the
>> >> message 'access cannot find the function'.
>> >> I selected the function from the macros runcode ... prompt via the
>> >> expression builder!
>> >> Yes its a public function.
>> >> Any ideas?
>> >> -- Dorian
>> >> "Give someone a fish and they eat for a day; teach someone to fish and
>> >> they
>> >> eat for a lifetime".
>>
>>
>> .
>>

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: hi people check email now
Next: Access 2007 and connecting to SQL server 2008