Date input shortcut

[sdawson]

If memory serves me right, I've seen code or maybe a shortcut somewhere for inputting a date value in a form along the following lines.
'
To input today's date, input "0"
Yesterday = "-1"
A week ago = "-7"

and so on.


Any ideas?

 

[David R]

Not a clue. In any Access form, Ctrl+; will input today's date, but i don't know of shortcuts for the others.

You could do it via code, but why not just use the DatePicker?

 

[sdawson]

As I understand it, Datepicker is normally set with Onload when opening a form. I require a to input a variety of dates when the form is open.
I'll look at some code then.

Thanks

 

[David R]

Can you explain in plain English what you are trying to do? You can autocalculate a lot of dates based on Today() or the input in your 'first' date field.

The DatePicker I am speaking of is an inherent feature of Access 2007+, and will give your user a mini calendar to pick a date from. http://answers.microsoft.com/en-us/...n-access/8c34e1ca-f133-4e70-9943-1fb81a86cf7d

 

[sdawson]

In plain English............

To input today's date, input "0"
Yesterday = "-1"
A week ago = "-7"

and so on.

 

[David R]

Not plain enough.

WHY do you want today's date to be zero, rather than Date() automatically prompted?
WHAT do you want to do with a day ago, and a week ago, and why can't they be autocalculated from the first datefield?

We're trying to help you. Help us help you by giving us good information in your question.

 

[sdawson]

OK, here we go.

If the user wants to input today's date, they would in put "0". The date field would then be populated with today's date. The user would then carry on inputing data.

The user would then move onto the next record. This requires yesterday's date to be entered so the operator would input "-1" and the date field would be populated with yesterday's date. And so on.
Basically the calculation is as you say, Today()-0, or Today()-1 in the example above.

I am trying to speed up data input. Picking a date from a popup calender or typing in a date is to slow.

I know I've seen this a few years ago in another db. I guess, it is some coding based on Today() as you say.