Re: Before Update

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 13:09:42 +0800

Use DLookup() to see if the value is already there.

See:
    Getting a value from a table: DLookup()
at:
    http://members.iinet.net.au/~allenbrowne/casu-07.html 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Larry" <anonymous@discussions.microsoft.com> wrote in message
news:049601c48b1e$5b5abed0$a501280a@phx.gbl...
> When a user is adding a new part number I would like to
> add a BeforeUpdate statement that verifies if it already
> exists in the database and if does; have it display a
> error message " This is already in the database,. Please
> verify the Part number".

Relevant Pages

  • RE: Repost - RunTime Error - Field too small
    ... Jet won't store changes to the external database in the table ... Here is the DLookup statement in the AfterUpdate event of the FacilityNumber ... If the name is longer that 30 characters, I get the error message. ...
    (microsoft.public.access.formscoding)
  • RE: Repost - RunTime Error - Field too small
    ... Jet won't store changes to the external database in the table ... post your DLookup() code and example data that ... I get an error message and I cannot ... > It seems to die if the field has more than 30 characters. ...
    (microsoft.public.access.formscoding)
  • Re: Whats happened to my Database?
    ... The mesage you refer to can also occur if one of the wizards or references ... try decompiling a copy of the database by ... Tips for Access users - http://allenbrowne.com/tips.html ... >an error message popped up said "Module not found" whenever I clicked on a ...
    (microsoft.public.access.formscoding)
  • Re: Whats happened to my Database?
    ... The mesage you refer to can also occur if one of the wizards or references ... try decompiling a copy of the database by ... Tips for Access users - http://allenbrowne.com/tips.html ... >an error message popped up said "Module not found" whenever I clicked on a ...
    (microsoft.public.access.modulesdaovba)
  • Re: Bad Form!!!! Please help!!!
    ... Compact the database. ... Tips for Access users - http://allenbrowne.com/tips.html ... The error message is '2004 there isn't enough memory to ... the form, copying it from an old copy of the database, renaming, changing the ...
    (microsoft.public.access.forms)