Re: Update Query Follow-up

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Luther (lbernadel_at_cdc.gov)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 08:19:41 -0700

Hi,

How would I incorporate this SQL in a parameter query to
update the date field when records are changed/updated.
The parameter query opens a form to display the records
found.

Thanks

1. I have a parameter query that opens a form
>-----Original Message-----
>You can use an SQL like:
>
>UPDATE YourTable
>SET DateField = Now()
>WHERE {criteria if required}
>
>See Access Help on UPDATE Query / SQL
>
>--
>HTH
>Van T. Dinh
>MVP (Access)
>
>
>"Luther" <lbernadel@cdc.gov> wrote in message
>news:50e701c42c89$bae41cf0$a501280a@phx.gbl...
>> Thank you very much for your help....Now I have another
>> question. With the update queries that I created, is it
>> also possible to have a Date field update itself with
the
>> current date when these queries are run. I can do it in
>> forms, when you actually do something to that record,
but
>> I kind of want a global thing when the table is updated
>> with all these codes.
>> Looking forward to hear from you.
>
>
>.
>

Relevant Pages

  • Re: Reporting dates from 2 tables
    ... The Parameters declaration will bring up a message box that prompts the user ... If it is indeed a parameter query you're after, then in the SQL view you can ... Then you can base your report on the query, so that every time the user ...
    (microsoft.public.access.gettingstarted)
  • Parameter default value
    ... PROCEDURE a.k.a Parameter Query? ... I created the proc/Query using this SQL: ... Set oCat = CreateObject ...
    (microsoft.public.access.queries)
  • Re: see all in a combo box
    ... I have 4 fields in the reqeust form these fields feed into the parameter ... "Van T. Dinh" wrote: ... > Post the SQL String of your Parameter Query. ... This combo box feeds into a parameter query. ...
    (microsoft.public.access.forms)
  • Re: access querries in excel
    ... 'parameter Query' with appropriate parameters ... for the required permissions on the table, ... 'parameter Query' for which the *database* developer has control over ... I often see replies about how to embed the UPDATE SQL ...
    (microsoft.public.access.queries)
  • Re: Reporting dates from 2 tables
    ... pull correct dates. ... want a Parameter Query ... that prompts the user ... the SQL view you can ...
    (microsoft.public.access.gettingstarted)