Help

F

Fletchmeister

Board Regular
Joined
May 20, 2003
Messages
114
I am not in excel i'm in access but I thought I would throw this into the pot.

I am looking for an automated procedure to enter a Date/Time stamp into a field once the user enters this field.

i.e. Tuesday 20 May 2003 11:55

Once this is entered I want it to carriage return to the next line for the user to enter data. However, I want this date/time stamp to remain static once the user has left and untouchable. When the next user comes along I want a new date and time stamp to be entered on a new line in the field and so on.

Can anyone help please, I think this is a tough one!! (A Bit of VB required!!) :cry:
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sort by date Sort by votes
Hullo. In the form design, make the Default Value =Date(), and set the Enabled property to False. This should do the trick!

HTH

P
 
Upvote 0
Hullo. If you ensure that the Enabled property is set to False, the only way to change it is for the users to manually edit the table.

P
 
Upvote 0
Actually, it might serve your purposes better to use the Now function rather than Date as Now will stamp the time as well as the date. Also, you may want to do this in the Form's After_Insert event so that anytime a new record is begun, the date/time will be stamped. The code's not too bad:

Code: 
YourForm_AfterInsert()
Me.YourTextbox=Now
End Sub
[/code]
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Unique ID field based on other fields entered in a record
Replies
7
Views
334
JAccess1706
J
tourless
  • Question
Pain in the Access
Replies
6
Views
591
alansidman
A
K
  • Question
VBA for Check box Select then sends target field data in form to another table
Replies
1
Views
465
welshgasman
welshgasman
P
  • Question
Open a form with data from another form and then update a table
Replies
2
Views
803
Pettor
P
G
  • Solved
Enter a Date in a table when access opens
Replies
3
Views
414
welshgasman
welshgasman

Forum statistics

Threads
1,214,653
Messages
6,120,748
Members
448,989
Latest member
mariah3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top