Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 9th, 2006, 09:53 AM
Registered User
 
Join Date: Feb 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Tracking record entry by date

I was wondering if it is possible to pull a users system date and time when they enter a new record and attach it to the record being entered in a separate field. I need to be able to point to specific times when a manager asks why an employee did not record their time and thought that this might be the easiest way while not depending on the employee to be responsible for the entry. Any thoughts would be greatly appreciated.

Thanks,

Steve
 
Old August 9th, 2006, 09:42 PM
Friend of Wrox
 
Join Date: Jul 2005
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The simplest way it to add a field to the table with a default value of: Now()

You do not even need to add the field to a form or the form's query. Whenever a record is added, the field will automatically be filled out with the default value.


Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to display record number in data entry form markw707 Access 5 August 28th, 2014 12:08 PM
date entry Tim Johnson Access 1 December 26th, 2007 08:18 AM
Need to dup a whole record in a data entry form markw707 Access 4 August 29th, 2005 10:09 AM
Cancelling a record entry dlamarche Access 8 March 10th, 2005 11:53 PM
New Record Data entry one form lgpatterson Classic ASP Basics 1 February 8th, 2005 12:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.