Jumat, 03 Mei 2013

RE: [MS_AccessPros] Create a date stamp table

 

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)
Recent Activity:
MARKETPLACE


.

__,_._,___

Tidak ada komentar:

Posting Komentar