If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
input mast
Got the following to turn into a input mast
130800z Jan 06 Which means in layman's turns, the first two digits are the date for today, the following 4 digits are the time, the z has to remain, well you can work out the rest, What I have got so far is the following 000000z LLL 00 which works but what I need to know how to do is simplify things a little is how to auto generate the date and time and month and year, in the above format any ideas fie |
#2
|
|||
|
|||
input mast
Fie,
I don't think you need an Input Mask for this. Depends a bit when this is going to happen. If it's when a new record is created, you could set the Default Value property of the control on your form to this... Format(Now(),"ddhhnnz mmm yy") -- Steve Schapel, Microsoft Access MVP Fie wrote: Got the following to turn into a input mast 130800z Jan 06 Which means in layman's turns, the first two digits are the date for today, the following 4 digits are the time, the z has to remain, well you can work out the rest, What I have got so far is the following 000000z LLL 00 which works but what I need to know how to do is simplify things a little is how to auto generate the date and time and month and year, in the above format any ideas fie |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
input box | Monty | General Discussion | 2 | October 7th, 2005 08:33 AM |
Input mask not working for importing | Dion van Overdijk | Database Design | 1 | August 30th, 2005 10:08 PM |
Input Parameters Fail To Reach SP | MikeC | Setting Up & Running Reports | 3 | April 11th, 2005 02:25 AM |
Input Form vba help | mdalzell | General Discussion | 0 | April 8th, 2005 03:57 PM |
Input Mask | Loi | New Users | 1 | November 18th, 2004 05:44 PM |