By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,765 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

question about time

100+
P: 243
hey i was wondering is it possible that when a form opens it inserts the current time into a field called start time on my table... and when they click the finished button on my form it inserts the current time into a field on my table called end time... ive gotten it to work ut its inserting the same time in both fields... if anyone can help that would be great thanks...
Nov 5 '08 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
Your actual intent here is a little unclear. You don't insert anything into a field on a table. You insert data into a field in a record on a table.

Do you want the Start Time/End Time inserted into all new records, when they're first created? What do you want to happen with these times if you go back and edit a record?

You might also post the code you're currently using for both of these events.

Linq ;0)>
Nov 5 '08 #2

puppydogbuddy
Expert 100+
P: 1,923
Hi Justin,
On your form, you need four textboxes as follows:

Any of the below that you want filled in when record created, place in default value property without the = sign; otherwise place in control source property as shown.


txtStartDate bound to expression>>> = Date()
txtStartTime bound to expression>>> = TimeValue(Now())


txtEndDate bound to expression>>> = Date()
txtEndTime bound to expression>>> = TimeValue(Now())
Nov 5 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.