[Solved] Date textbox and "enter" button

[streub]

I have a simple database for recording store visitors. I need to have the date textbox to always display the current date.
Lastly, after completing the data entry I want a command button that can be clicked to enter the data into the table.

Finding the exact information I need has been difficult.

Thank you

Streub

[F3K Total]

Hi,
find attached an example. If you store a new record, the current timestamp will be set automatically.
The timestamp is not previously displayed.
It's created, if you click on "save".
To have this function, i had to execute once, via Tools/SQL ... this command:

Code: Select all

alter table "Visits" alter column "Timestamp" set default "Current_Timestamp"

R
EDIT: If you only want to have the current date, apply a command similar to the following to a DATE column:

Code: Select all

alter table "Visits" alter column "date_of_visit" set default "Current_Date"

[streub]

You are most kind providing me with your advise.

Thank you

Streub