Date in the form

[yanf7]

Is it possible to save in the table the date that the line was entered.
I am using a form to enter a data to the table and one of the field in the table should be the date the data was entered.
I am looking for any solutions.
Also how can i make the form to open on the next empty record

 

[Gemini32]

Hi yanf7

I'm not sure about the saving of the date that data is enter but I might be able to help on the record to open on a new form everytime...You do this...

In the Microsoft database....Open your mdb then once that is open click on the tools menu then move to the Database Utilities ... there are options there and one of them is the Switchboard Manager. Chose that one Switchboard Manager.,.. You'll have a pop up of saying this

The Switchboard Manager was unable to find a valid switchboard in this database. Would you like to create one? Click yes


Step 1: When the Switchboard Manager comes up click Edit

Step 2: Then click New a box will pop up and have three entries

Step 3: The first entry is one called text... Type what you want
your form is called...

Step 4: Now the second entry is called the command .... See the
drop down arrow and choose this one
Open Form in Add Mode....This will allow you to accomplish
what you want to do with your form by having a new
form when you open it.....

Step 5: Now the final entry is called Form: you need to choose the
form you want to open to a new record everytime it's open...

Now for the last step click ok when done....Now to be able to make
changes to the switchboard easily follow the steps to you finish the second entry then click ok..


Have the Text be : Make changes to the switchboard

then the command is : choose design application

then click ok.... to have your switchboard be up first before the database
click on the Tools menu and click on Startup

A pop up will appear and you'll see Display form/Page click on the drop down arrow and choose the switchboard then if you don't want the database to be there in behind the switchboard uncheck the Display Database Window .. If you want it there just put a check mark back by the Display Database Window...


Hope this helps you...

Gemini32

 

[yanf7]

Thanks, for you help.
If someone can help me with the date it would be great

 

[yanf7]

Thanks, for your help.
If someone can help me with the date it would be great

 

[Tanis]

Create a new field in your table, say DateEntered. Format the datatype as date/Time. In the after update event of a control on the form put Me.DateEntered = Date. The DateEntered field does not need to be on the form.


David

 

[yanf7]

Thanks, but can you please explain the second part of your note?