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

Jumat, 03 Mei 2013

Re: [MS_AccessPros] Create a date stamp table

John,

That worked great. I have a thought. How could I add another field to the table to show what button was clicked. We might add this to the other button on the form and would like to capture that also. How could I define which button was clicked?

Thank You

Jim Wagner
________________________________

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, May 3, 2013 8:59 AM
Subject: 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

[Non-text portions of this message have been removed]