Re: Before Update

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

anonymous_at_discussions.microsoft.com
Date: 08/26/04 

Date: Thu, 26 Aug 2004 05:00:00 -0700

This is what I need.
Thank you
PS GREAT SITE!
>-----Original Message-----
>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: DLookup Problem
    ... > Concatenate the value into the 3rd string in DLookup(): ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ... >> Dim varUP as Varient ...
    (comp.databases.ms-access)
  • Re: How to get elapsed time?
    ... What I want is for the DLookUp to find the "Out ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.queries)
  • Re: DLookup Date Syntax
    ... > For an explanation, see: ... > Getting a value from a table: DLookup() ... > Allen Browne - Microsoft MVP. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.reports)
  • Re: 2 problems: Date and Combo Box-DID IT & ??
    ... learned about Dlookup and am using that. ... >If you want to record details of all changes - edits, ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.forms)
  • Re: Run time error problem
    ... rather than allenbrowne at mvps dot org. ... The Null and DLookup test is checking for valid data being input into a form ... also have a like of similar code that checks a numeric field. ...
    (microsoft.public.access.formscoding)