<div>
Thanks for the quick response and accurate solution!
</div>


Thanks for the quick response and accurate solution!

<div>
<div class="content wysiwyg-content">
I'm trying to use TimeOfDay in my code to enter the system time into a table (field &quot;Time&quot;) each time the user enters a record.<br />
<br />
My code (simplified):<br />
Dim currentTime As Date<br />
currentTime = TimeOfDay<br />
sql=&quot;Insert into tblTime (Time) Values (&quot; &amp;&nbsp;currentTime &amp;&nbsp;&quot;)&quot;<br />
<br />
The actual dbconnection and sql statement worked until I added the &quot;Time&quot; field and &quot;&nbsp;&amp; currentTime &amp;&quot;.<br />
<br />
Is my reference to the varible correct?<br />
<br />
Thanks in advance.
</div>
</div>


I'm trying to use TimeOfDay in my code to enter the system time into a table (field "Time") each time the user enters a record.

My code (simplified):
Dim currentTime As Date
currentTime = TimeOfDay
sql="Insert into tblTime (Time) Values (" & currentTime & ")"

The actual dbconnection and sql statement worked until I added the "Time" field and " & currentTime &".

Is my reference to the varible correct?

Thanks in advance.

TimeOfDay

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

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.