Date fields with macro

[Dan]

I need to open a form, select a field called InvoiceDate,
select all records, and set the date to the current date
using a macro. The first problem I run into is the date. I
can open the form and set the date, but the date set is
12/30/1899. I have tried the Date() and Now() but both do
the same thing. The second problem is I can only set the
first record. How can I correct the date and select all
records? I am using Access 2002. Any suggestions is
greatly appreciated.

 

[Ken Snell]

Use an update query to update fields in a number of records; this doesn't
require a form to be opened unless you want to use the form for other things
(such as to input the value to which the fields' values should be updated).
You can run an update query via a macro if desired.

 

[Guest]

-----Original Message-----
Use an update query to update fields in a number of records; this doesn't
require a form to be opened unless you want to use the form for other things
(such as to input the value to which the fields' values should be updated).
You can run an update query via a macro if desired.


--
Ken Snell
<MS ACCESS MVP>




.

Ken

Great suggestion, the update query works great!! Thanks
for getting my brain out of the "rut".

Dan

 

[Ken Snell]

You're welcome. Good luck!