ACCESS FEED: RE: [MS_AccessPros] Create a date stamp table

Jumat, 03 Mei 2013

RE: [MS_AccessPros] Create a date stamp table

Jim-

CurrentDb.Execute "INSERT INTO tblTransferDate Values(Date() + Time())",
dbFailOnError

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Friday, May 03, 2013 5:48 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Create a date stamp table

Hello all,

I have a simple question but I think that it is Friday brain freeze day. I
want to have a table named tblTransferDate with just one Field named
TransferDate be appended with the current date and time that the user clicks
the button to transfer records to a table. I just want to capture the time
that the user clicks the button on the form and append the date to the
transferdate table. We want to keep a record of the time that the single
user clicks the button. Is there a way of doing this?

Thank You

Jim Wagner

------------------------------------

Yahoo! Groups Links