Jim-
You need a second column for that. Let's call it ButtonClicked (text).
CurrentDb.Execute "INSERT INTO tblTransferDate (TransferDate, ButtonClicked) " & _
"Values(Date() + Time(), 'Buttonx')", dbFailOnError
.. where Buttonx is the name of the button being clicked hard-wired into each Click event.
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 Jim Wagner
Sent: Friday, May 03, 2013 6:17 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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]
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar