Mark A Matte
markamatte at hotmail.com
Fri Jun 20 14:09:46 CDT 2008
You can assign nulls all day long...its when you do something with it that things get upset. Also, Susan's idea about references...specifically the order of references...is a good place to look. Thanks, Mark A. Matte > From: Donald.A.McGillivray at sprint.com > To: accessd at databaseadvisors.com > Date: Fri, 20 Jun 2008 13:47:52 -0500 > Subject: Re: [AccessD] Error 3001 - invalid argument - What the . . . . ? > > Hmmm. I'll check, but don't think so. If that were the case, wouldn't I expect the error to occur at the line where I attempt to assign the value, rather than the .Update line? > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte > Sent: Friday, June 20, 2008 11:41 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Error 3001 - invalid argument - What the . . . . ? > > > Is there possibly a null being passed? > > Mark A. Matte > >> From: Donald.A.McGillivray at sprint.com> To: accessd at databaseadvisors.com> Date: Fri, 20 Jun 2008 13:28:12 -0500> Subject: [AccessD] Error 3001 - invalid argument - What the . . . . ?>> Out of the blue, I'm getting the above error (minus the "What the . . .?") in a proc that has been running rock solid forever. It's in a block of code where I'm using DAO to write a record to a table:>> .AddNew> !field1 = SomeValue1> !field2 = SomeValue2> .Update>> Code is puking on the .Update line.>> I suspect some sort of corruption, but all my usual remedies (decompile/recompile, compact/repair) don't seem to be having any effect. This is probably my weakest area of understanding with Access, etc., so I'm not even sure I'm using those approaches correctly.>> Hoping somebody might be able to suggest a more reeliable way to the problem . . . .>> Don McGillivray>>> --> AccessD mailing list> AccessD at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/accessd> Website: ! > http://www.databaseadvisors.com > _________________________________________________________________ > The other season of giving begins 6/24/08. Check out the i'm Talkathon. > http://www.imtalkathon.com?source=TXT_EML_WLH_SeasonOfGiving > -- > 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/accessd > Website: http://www.databaseadvisors.com _________________________________________________________________ Earn cashback on your purchases with Live Search - the search that pays you back! http://search.live.com/cashback/?&pkw=form=MIJAAF/publ=HMTGL/crea=earncashback