MartyConnelly
martyconnelly at shaw.ca
Mon Feb 19 12:19:32 CST 2007
I don't think this type of code line will work DoCmd.Echo False, "" You haven't disambiguated the call so it will force a reference check and any missing reference at that point will fail. You have to add Access. or VBA. to your code Should be Access.DoCmd.Echo False, "" See Kaplan's Musings on this Subject: INFO: How to guarantee that references will work in your applications http://www.trigeminal.com/usenet/usenet026.asp?1033 Drew Wutka wrote: >Why not make a function, and just use RunCode in the AutoExec macro.... > >Drew > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte >Sent: Friday, February 16, 2007 10:23 AM >To: accessd at databaseadvisors.com >Subject: Re: [AccessD] Missing references > >Thanks Gustav, > >This is almost embarrassing...I see the code...I know what the code >does...I >can write VBA...ALL...DAY...LONGGGG...But I don't know how to convert >your >IF statement back to a macro??? lol...Not sure why but I find this fact > >amusing, but I do. Here is the VBA/Macro... > ><macro> > >'------------------------------------------------------------ >' AutoExec >' >'------------------------------------------------------------ >Function AutoExec() > > DoCmd.Echo False, "" > If (CheckReferences() = False) Then > Call VerifyReferences(True) > DoCmd.OpenModule "USysReferencesCheck", "" > DoCmd.RunCommand acCmdCompileAndSaveAllMod > DoCmd.Close , "" > End If > DoCmd.Echo True, "" > >End Function > ></macro> > >I got the echo part...lol...but how do you do the if statement? > >Thanks, > >Mark A. Matte > > > >>From: "Gustav Brock" <gustav at cactus.dk> >>Reply-To: Access Developers discussion and problem >>solving<accessd at databaseadvisors.com> >>To: <accessd at databaseadvisors.com> >>Subject: Re: [AccessD] Missing references >>Date: Fri, 16 Feb 2007 00:03:43 +0100 >> >>Hi Mark >> >>Some years ago we had a lengthy thread on this. >>Look up here: >> >>http://databaseadvisors.com/pipermail/accessd/2003-July/011034.html >> >>/gustav >> >> >> >>>>>markamatte at hotmail.com 15-02-07 23:02 >>> >>>>> >>>>> >>Thanks John, >> >>I'm not referencing any other app or docs...I was referring to when you >> >> >are > > >>in a module and goto TOOLS---REFERENCES...and there is something >> >> >missing or > > >>incorrect. >> >>Is binding relevant at this point? If not...back to the original >>question:...how to handle the 'missing'??? >> >>Am I still confused>..lol...??? >> >> >>Thanks, >> >>Mark A. Matte >> >>-- >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com >> >> > >_________________________________________________________________ >With tax season right around the corner, make sure to follow these few >simple tips. >http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTi >ps.aspx?icid=HMFebtagline > > > -- Marty Connelly Victoria, B.C. Canada