<div>
Date and Time Functions in VBA<br />
<br />
<a href="http://www.classanytime.com/mis333k/sjdatetime.html" rel="ugc">http://www.classanytime.com/mis333k/sjdatetime.html</a>
</div>


Date and Time Functions in VBA

http://www.classanytime.com/mis333k/sjdatetime.html [http://www.classanytime.com/mis333k/sjdatetime.html]

<div>
@Dhaest, Thank you for the link...my problem now is: <br />
<br />
What code I need to add to the command button's &quot;on click&quot; event, which will input&quot; time() &quot;&nbsp;into a field?<br />
<br />
Also...is it better, or possible to write a macro for this function, instead of VBA?<br />
<br />
It is likely I missed the solution in your reply...please point it out...I am new at this.<br />
<br />
Thanks much
</div>


@Dhaest, Thank you for the link...my problem now is:

What code I need to add to the command button's "on click" event, which will input" time() " into a field?

Also...is it better, or possible to write a macro for this function, instead of VBA?

It is likely I missed the solution in your reply...please point it out...I am new at this.

Thanks much

<div>
Thank you so much, Gugro, your solution worked perfect!
</div>


Thank you so much, Gugro, your solution worked perfect!

<div>
<div class="content wysiwyg-content">
The Form in question, has four task categories and four adjacent time entry fields, currently users type in current time as they complete each task...and they complain about having to type.<br />
<br />
I would like to create a command button for each time stamp, this would make it much easier for users to enter time as each task is completed.<br />
<br />
I have very little experience in VBA.<br />
<br />
<br />
Thanks much
</div>
</div>


The Form in question, has four task categories and four adjacent time entry fields, currently users type in current time as they complete each task...and they complain about having to type.

I would like to create a command button for each time stamp, this would make it much easier for users to enter time as each task is completed.

I have very little experience in VBA.


Thanks much

VBA code to activate timestamp button on Access 2007 form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.