Prev: hi people check email now
Next: Access 2007 and connecting to SQL server 2008
From: Dorian on 31 Dec 2009 13:10
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: Duane Hookom on 31 Dec 2009 13:14
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 31 Dec 2009 13:24
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: Dorian on 31 Dec 2009 16:31
No to both questions.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Duane Hookom" wrote:

> 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: Dorian on 31 Dec 2009 16:33
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".
>
>
> .
>
 |  Next  |  Last
Pages: 1 2 3
Prev: hi people check email now
Next: Access 2007 and connecting to SQL server 2008