Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Mon Feb 2 01:17:46 CST 2004
Are you sure its a function and not a sub? Sub's can not be run from Marco. As already specified below the function must be calle with () at the end, even when no parameters Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Oleg_123 at xuppa.com Sent: Monday, February 02, 2004 1:44 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] macro can't find function hmm, the function when run by itself works fine. Could the problem possibly bee that the module in which it is located is called the same name as function ? > Well all I can think is a) rename the function (could BreakName > possibly be a reserved word?) and/or b) decompile, repair etc to be > sure it isn't just glitchy. Other than that I cn't see what the problem is. > > Andy Lacey > http://www.minstersystems.co.uk > >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >> Oleg_123 at xuppa.com >> Sent: 30 January 2004 16:47 >> To: accessd at databaseadvisors.com >> Subject: RE: [AccessD] macro can't find function >> >> >> still gives me the same error :--( >> >> >> >> > Beat me to it Lambert :-) >> > >> > Andy Lacey >> > http://www.minstersystems.co.uk >> > >> >> -----Original Message----- >> >> From: accessd-bounces at databaseadvisors.com >> >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, >> Lambert >> >> Sent: 29 January 2004 17:08 >> >> To: 'Access Developers discussion and problem solving' >> >> Subject: RE: [AccessD] macro can't find function >> >> >> >> >> >> I'd suggest you get rid of the space between "BreakName" and the >> opening parentheses. >> >> >> >> Lambert >> >> >> >> > -----Original Message----- >> >> > From: Oleg_123 at xuppa.com [SMTP:Oleg_123 at xuppa.com] >> >> > Sent: Thursday, January 29, 2004 11:52 AM >> >> > To: accessd at databaseadvisors.com >> >> > Subject: RE: [AccessD] macro can't find function >> >> > >> >> > it's public (of course ;-) >> >> > and this is how it looks -- BreakName () >> >> > >> >> > i decided to try to make that macro call another macro >> >> which contains >> >> > the function >> >> > >> >> > > Oleg >> >> > > >> >> > > In a macro the function has to be expressed as fn(), ie. >> >> no = sign >> >> > > before it but must have the parentheses. May be worth >> >> checking. Oh >> >> > > and the function must of course be Public. >> >> > > >> >> > > Andy Lacey >> >> > > http://www.minstersystems.co.uk >> >> > > >> >> > >> -----Original Message----- >> >> > >> From: accessd-bounces at databaseadvisors.com >> >> > >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >> >> Oleg_123 at xuppa.com >> >> > >> Sent: 29 January 2004 16:12 >> >> > >> To: accessd at databaseadvisors.com >> >> > >> Subject: RE: [AccessD] macro can't find function >> >> > >> >> >> > >> >> >> > >> Group, >> >> > >> >> >> > >> I have a long macro that opens several queries, at the end >> >> > >> its >> >> suppose to RunCode - function, however it gives me an message "The >> >> > >> expression you entered has a function name that xxx >> can't find". >> >> When I run that function separetely it works fine, and the name is >> >> > >> spelled correctly since i didn't type it but selected it >> >> > >> using >> >> their device what should i do ? >> >> > >> >> >> > >> >> >> > >> ----------------------------------------- >> >> > >> Get Breaking News from CNN, ABC, NBC, CBS Now. >> >> > >> http://www.xuppa.com/news/?link=webmail >> >> > >> >> >> > >> >> >> > >> >> >> > >> _______________________________________________ >> >> > >> AccessD mailing list >> >> > >> AccessD at databaseadvisors.com >> >> > >> http://databaseadvisors.com/mailman/listinfo/a> ccessd >> >> > >> Website: >> >> > >> http://www.databaseadvisors.com >> >> > >> >> >> > >> >> >> > > >> >> > > _______________________________________________ >> >> > > AccessD mailing list >> >> > > AccessD at databaseadvisors.com >> >> > > http://databaseadvisors.com/mailman/listinfo/accessd >> >> > > Website: http://www.databaseadvisors.com >> >> > >> >> > >> >> > >> >> > ----------------------------------------- >> >> > Get Breaking News from CNN, ABC, NBC, CBS Now. >> >> > http://www.xuppa.com/news/?link=webmail >> >> > >> >> > >> >> > _______________________________________________ >> >> > AccessD mailing list >> >> > AccessD at databaseadvisors.com >> >> > http://databaseadvisors.com/mailman/listinfo/accessd >> >> > Website: http://www.databaseadvisors.com >> >> _______________________________________________ >> >> AccessD mailing list >> >> AccessD at databaseadvisors.com >> >> http://databaseadvisors.com/mailman/listinfo/a> ccessd >> >> Website: >> >> http://www.databaseadvisors.com >> >> >> >> >> > >> > _______________________________________________ >> > AccessD mailing list >> > AccessD at databaseadvisors.com >> > http://databaseadvisors.com/mailman/listinfo/accessd >> > Website: http://www.databaseadvisors.com >> >> >> >> ----------------------------------------- >> Get Breaking News from CNN, ABC, NBC, CBS Now. >> http://www.xuppa.com/news/?link=webmail >> >> >> >> _______________________________________________ >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/a> ccessd >> Website: >> http://www.databaseadvisors.com >> >> > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com ----------------------------------------- Get Breaking News from CNN, ABC, NBC, CBS Now. http://www.xuppa.com/news/?link=webmail _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com