Solved

Short time auto-generated

Posted on 2013-06-07
2
348 Views
Last Modified: 2013-06-07
I have an application people are using the 'scan into' work.

I want to store hours and minutes only, but am using "default value" of time$(); which returns long value (hh:mm:ss).  The reason it is important to not record seconds is that I want to ensure that a person isn't able to scan in twice (accidentally), so time is part of the key field.

how can I store a default value of hh:mm only?
0
Comment
Question by:TIgerV
2 Comments
 
LVL 20

Accepted Solution

by:
clarkscott earned 500 total points
ID: 39229838
= format(YourValue, "hh:nn")

Scott C
0
 

Author Closing Comment

by:TIgerV
ID: 39229855
Thank You!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now