Ask a Question related to Microsoft Access, Design and Development.
-
LLR #1
Autofill current date in field on form
Need a field to autofill the current date on a form. The
user will be filling in one field with a control number
and the date field will be the current date. Cant't get
it to autofill with the current date.
LLR Guest
-
Get current date/time? Use them in hidden field?
I've got an app that works as a reception log for clients coming in our agency. The receptionist logs each client's name into our log database. ... -
Autofill date field
I have been trying to get a Date field filled automatically whenever the form I created in Mac Acrobat 7 is opened. I have defined the field as a... -
adding current date into Access using DW form
I've looked all over this forum finding similar solutions but not exactly what I'm looking for. Relatively simple. My Access 2002 database has a... -
date & time in form field
I want to put the current date and time into a form field which will them be submitted to a database. Is this possible? If so, what code should I... -
Autofill text field with stored db results?
Currently, Im using a populated select box containing a list of customers. I would like to instead have a textbox in which the user would type in... -
Dean #2
RE: Autofill current date in field on form
Set the default value to date()
Ex: =(Date)
- - Dean
The>-----Original Message-----
>Need a field to autofill the current date on a form.>user will be filling in one field with a control number
>and the date field will be the current date. Cant't get
>it to autofill with the current date.
>.
>Dean Guest
-
Mike Mueller #3
Re: Autofill current date in field on form
: Need a field to autofill the current date on a form. The
: user will be filling in one field with a control number
: and the date field will be the current date. Cant't get
: it to autofill with the current date.
I am assuming that this form is data entry only, and the
form is not being used to edit existing records. I am using
the field name of Control_Number for what the user enters &
Date_Entered for the date, format as short date. I would
use something similiar to this:
Private Sub Control_Number_Exit(Cancel As Integer)
Date_Entered = Format(Now, "mm/dd/yyyy")
End Sub
Mike Mueller Guest



Reply With Quote

