<div>
Change to Format(Now(), &quot;mm-dd-yyyy-hhmmss&quot;) <br />
to get seconds
</div>


Change to Format(Now(), "mm-dd-yyyy-hhmmss")
to get seconds

<div>
Thanks sir bounty... Working well....
</div>


<div>
For the records: This doesn't work as advertised, as VBA doesn't know of milliseconds natively.<br />
<br />
However, it can be done. Follow the link here:<br />
<br />
<a href="https://www.experts-exchange.com/questions/23725904/Access-to-the-millisecond-article-Examples.html" rel="ugc">https://www.experts-exchange.com/questions/23725904/Access-to-the-millisecond-article-Examples.html</a><br />
<br />
/gustav
</div>


For the records: This doesn't work as advertised, as VBA doesn't know of milliseconds natively.

However, it can be done. Follow the link here:

https://www.experts-exchange.com/questions/23725904/Access-to-the-millisecond-article-Examples.html [https://www.experts-exchange.com/questions/23725904/Access-to-the-millisecond-article-Examples.html]

/gustav

<div>
<div class="content wysiwyg-content">
The output below spceifies Month-day-year and -time hours- Mins. can I include seconds or tenths of seconds?<br />
<br />
&nbsp; sOutput = CurrentProject.Path &amp;&nbsp;&quot;qryReactorBatch_&quot; &amp;&nbsp;Format(Now(), &quot;mm-dd-yyyy-hhmm&quot;) &amp;&nbsp;&quot;.xls&quot;
</div>
</div>


The output below spceifies Month-day-year and -time hours- Mins. can I include seconds or tenths of seconds?

  sOutput = CurrentProject.Path & "qryReactorBatch_" & Format(Now(), "mm-dd-yyyy-hhmm") & ".xls"

VBA Time Hour Mins Seconds

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.