Date manipulations

[Ron]

Hi All (yet again today...)

Input clerk gets to "date of order" control on order form and is supposed to
enter the date of the order. I've got that defaulting to today's date,
which sounds logical...excep t that sometimes orders are made on Friday, but
not entered until the following Tuesday, or whatever. Of course, it's a
standard control, so the default date can be replaced by typing another data
with month, day, year, etc. For the lazies I've also got a calendar routine
available upon a double click of the date of order field so they can just
"click" on a day and boom, the date's entered.

Being your average SUPER LAZY USERS, this doesn't seem to suffice. They
want to change the date for the order to 2 days ago, or a week, or whatever,
but just have to type in the month number, and day number, and have the year
default to this year's date. That of course doesn't work, because the
year's blank.

I recall an old, old version of QuickBooks had this feature--you could just
enter the month, day and hit enter and get the year defaulted to the current
year--so it's not a new idea.

Any way to get Access2000 to operate this way?

TIA
ron

[fredg]

On Wed, 07 Mar 2007 01:00:00 GMT, Ron wrote:

Hi All (yet again today...)

Input clerk gets to "date of order" control on order form and is supposed to
enter the date of the order. I've got that defaulting to today's date,
which sounds logical...excep t that sometimes orders are made on Friday, but
not entered until the following Tuesday, or whatever. Of course, it's a
standard control, so the default date can be replaced by typing another data
with month, day, year, etc. For the lazies I've also got a calendar routine
available upon a double click of the date of order field so they can just
"click" on a day and boom, the date's entered.

Being your average SUPER LAZY USERS, this doesn't seem to suffice. They
want to change the date for the order to 2 days ago, or a week, or whatever,
but just have to type in the month number, and day number, and have the year
default to this year's date. That of course doesn't work, because the
year's blank.

I recall an old, old version of QuickBooks had this feature--you could just
enter the month, day and hit enter and get the year defaulted to the current
year--so it's not a new idea.

Any way to get Access2000 to operate this way?

TIA
ron

If I understand your message correctly, it works fine for me.
Enter month/day , i.e. 3/4 Access will assume the current year,
3/4/2007.
That is an Access default.
If you enter the month/year, i.e. 3/2007 Access will assume the first
day of the month 3/1/2007. That is an Access default as well.

If your users are entering a valid month and day, then you must have
something else going on which is not permitting Access to assign the
current year.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Don Leverton]

How about...
LOCKING the control, and not allowing them an option? <grin>
=============== =============== =========
Private Sub MyCalendar_Afte rUpdate()
Me![txtOrderDate] = Me.MyCalendar
End Sub
Private Sub txtOrderDate_Ke yDown(KeyCode As Integer, Shift As Integer)
MsgBox ("Please Select a date from the Calendar.")
Me.MyCalendar.S etFocus
Me![txtOrderDate] = Me.MyCalendar
End Sub
=============== =============== =========
HTH,
Don

"Ron" <ro************ ********@verizo n.netwrote in message
news:k8oHh.366$ mh.361@trnddc05 ...

Hi All (yet again today...)

Input clerk gets to "date of order" control on order form and is supposed

to

enter the date of the order. I've got that defaulting to today's date,
which sounds logical...excep t that sometimes orders are made on Friday,

but

not entered until the following Tuesday, or whatever. Of course, it's a
standard control, so the default date can be replaced by typing another

data

with month, day, year, etc. For the lazies I've also got a calendar

routine

available upon a double click of the date of order field so they can just
"click" on a day and boom, the date's entered.

Being your average SUPER LAZY USERS, this doesn't seem to suffice. They
want to change the date for the order to 2 days ago, or a week, or

whatever,

but just have to type in the month number, and day number, and have the

year

default to this year's date. That of course doesn't work, because the
year's blank.

I recall an old, old version of QuickBooks had this feature--you could

just

enter the month, day and hit enter and get the year defaulted to the

current

year--so it's not a new idea.

Any way to get Access2000 to operate this way?

TIA
ron

[storrboy]

On Mar 6, 11:45 pm, "Don Leverton"
<leveriteNoJunk M...@telusplane t.netwrote:

How about...
LOCKING the control, and not allowing them an option? <grin>
=============== =============== =========
Private Sub MyCalendar_Afte rUpdate()
Me![txtOrderDate] = Me.MyCalendar
End Sub

Private Sub txtOrderDate_Ke yDown(KeyCode As Integer, Shift As Integer)
MsgBox ("Please Select a date from the Calendar.")
Me.MyCalendar.S etFocus
Me![txtOrderDate] = Me.MyCalendar
End Sub
=============== =============== =========
HTH,
Don

"Ron" <ronSPAMBLOCKIN Gwest...@verizo n.netwrote in message

news:k8oHh.366$ mh.361@trnddc05 ...

Hi All (yet again today...)

Input clerk gets to "date of order" control on order form and is supposed

to

enter the date of the order. I've got that defaulting to today's date,
which sounds logical...excep t that sometimes orders are made on Friday,

but

not entered until the following Tuesday, or whatever. Of course, it's a
standard control, so the default date can be replaced by typing another

data

with month, day, year, etc. For the lazies I've also got a calendar

routine

available upon a double click of the date of order field so they can just
"click" on a day and boom, the date's entered.

Being your average SUPER LAZY USERS, this doesn't seem to suffice. They
want to change the date for the order to 2 days ago, or a week, or

whatever,

but just have to type in the month number, and day number, and have the

year

default to this year's date. That of course doesn't work, because the
year's blank.

I recall an old, old version of QuickBooks had this feature--you could

just

enter the month, day and hit enter and get the year defaulted to the

current

year--so it's not a new idea.

Any way to get Access2000 to operate this way?

TIA
ron

If they really want to be lazy try this. Make a form to play with and
put one textbox on it - name it Text11 to match what I've done. Add to
the appropriate event the following (one is a function that just gets
pasted in as is - no event for it.). User can enter date in I think
any recognized format, your calendar picker would still work and the
user could enter +3 to add three days to current date, or -2 to
subtract 2 days.
Private Sub Text11_AfterUpd ate()
FormatDateBox
End Sub

Private Sub Text11_BeforeUp date(Cancel As Integer)
If Not IsDate(Me!Text1 1.Text) And Not IsNumeric(Me!Te xt11.Text)
Then
MsgBox "The date supplied is in an invalid format.", vbOKOnly,
"Invalid Date"
Cancel = True
End If
End Sub

Function FormatDateBox()
Dim lngVal As Long

If IsDate(Me!Text1 1) Then
Me!Text11 = Format(Me!Text1 1, "Short Date")
Exit Function
End If

If IsNumeric(Me!Te xt11) Then
Me!Text11 = Date + CLng(Me!Text11)
Exit Function
End If
End Function

[Ron]

"fredg" <fg******@examp le.invalidwrote in message
news:15******** *************** *******@40tude. net...

On Wed, 07 Mar 2007 01:00:00 GMT, Ron wrote:

>Hi All (yet again today...)

Input clerk gets to "date of order" control on order form and is supposed
to
enter the date of the order. I've got that defaulting to today's date,
which sounds logical...excep t that sometimes orders are made on Friday,
but
not entered until the following Tuesday, or whatever. Of course, it's a
standard control, so the default date can be replaced by typing another
data
with month, day, year, etc. For the lazies I've also got a calendar
routine
available upon a double click of the date of order field so they can just
"click" on a day and boom, the date's entered.

Being your average SUPER LAZY USERS, this doesn't seem to suffice. They
want to change the date for the order to 2 days ago, or a week, or
whatever,
but just have to type in the month number, and day number, and have the
year
default to this year's date. That of course doesn't work, because the
year's blank.

I recall an old, old version of QuickBooks had this feature--you could
just
enter the month, day and hit enter and get the year defaulted to the
current
year--so it's not a new idea.

Any way to get Access2000 to operate this way?

TIA
ron

If I understand your message correctly, it works fine for me.
Enter month/day , i.e. 3/4 Access will assume the current year,
3/4/2007.
That is an Access default.
If you enter the month/year, i.e. 3/2007 Access will assume the first
day of the month 3/1/2007. That is an Access default as well.

If your users are entering a valid month and day, then you must have
something else going on which is not permitting Access to assign the
current year.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Boy, there for a second, I thought we were on different planets. A date
field defaulting to 3/1/2007 if all you put in is 3/2007? Defaulting to
3/27/2007 if all you put in was 3/27? Mine don't allow that on ANY of my
screens!

But then I tried a new table with date field, text field and started adding
dates to just the table, and viola...it works as you say. So, what am I
doing differently on all my forms?

Every single date control I brought onto a form I ALSO set up with a Input
Mask. THAT is what's requiring the year, etc.

I'll play around with taking the format off and see how that floats my
user's boats.

Of course, if I make it too easy for them to enter data the only next step
is to allow entry by osmosis. Oh, wait. That would require them to
think...

Thanks much for the tip.
ron

[storrboy]

On Mar 7, 1:50 pm, "Ron" <ronSPAMBLOCKIN Gwest...@verizo n.netwrote:

"fredg" <fgutk...@examp le.invalidwrote in message

news:15******** *************** *******@40tude. net...

On Wed, 07 Mar 2007 01:00:00 GMT, Ron wrote:

Hi All (yet again today...)

Input clerk gets to "date of order" control on order form and is supposed
to
enter the date of the order. I've got that defaulting to today's date,
which sounds logical...excep t that sometimes orders are made on Friday,
but
not entered until the following Tuesday, or whatever. Of course, it's a
standard control, so the default date can be replaced by typing another
data
with month, day, year, etc. For the lazies I've also got a calendar
routine
available upon a double click of the date of order field so they can just
"click" on a day and boom, the date's entered.

Being your average SUPER LAZY USERS, this doesn't seem to suffice. They
want to change the date for the order to 2 days ago, or a week, or
whatever,
but just have to type in the month number, and day number, and have the
year
default to this year's date. That of course doesn't work, because the
year's blank.

I recall an old, old version of QuickBooks had this feature--you could
just
enter the month, day and hit enter and get the year defaulted to the
current
year--so it's not a new idea.

Any way to get Access2000 to operate this way?

TIA
ron

If I understand your message correctly, it works fine for me.
Enter month/day , i.e. 3/4 Access will assume the current year,
3/4/2007.
That is an Access default.
If you enter the month/year, i.e. 3/2007 Access will assume the first
day of the month 3/1/2007. That is an Access default as well.

If your users are entering a valid month and day, then you must have
something else going on which is not permitting Access to assign the
current year.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Boy, there for a second, I thought we were on different planets. A date
field defaulting to 3/1/2007 if all you put in is 3/2007? Defaulting to
3/27/2007 if all you put in was 3/27? Mine don't allow that on ANY of my
screens!

But then I tried a new table with date field, text field and started adding
dates to just the table, and viola...it works as you say. So, what am I
doing differently on all my forms?

Every single date control I brought onto a form I ALSO set up with a Input
Mask. THAT is what's requiring the year, etc.

I'll play around with taking the format off and see how that floats my
user's boats.

Of course, if I make it too easy for them to enter data the only next step
is to allow entry by osmosis. Oh, wait. That would require them to
think...

Thanks much for the tip.
ron

Keep in mind the Format and Input Mask are different things. The Input
Mask *requires* you to enter data a certain way, a format will display
the underlying value a different way.

[Don Leverton]

....

If they really want to be lazy try this. Make a form to play with and
put one textbox on it - name it Text11 to match what I've done. Add to
the appropriate event the following (one is a function that just gets
pasted in as is - no event for it.). User can enter date in I think
any recognized format, your calendar picker would still work and the
user could enter +3 to add three days to current date, or -2 to
subtract 2 days.

OR

They could just click on a different date on the Calendar control. <grin>
("KISS" rule)
(I am assuming, however, that your users CAN count to 3.) <big grin>

The (correctly formatted) date changes as the use selects a date on the
calendar.
I'm not trying to be a real smarty-pants here ... I've just had all I can
take of "MM/DD/YY vs DD/MM/YY vs MM/DD/YYYY vs DD/MM/YYYY formats and '# &
Mydate & #' issues!

It's especially an issue here in Canada, where the "official" format is
DD/MM/YYYY.
We also spell words like "colour" instead of "color" :)

Like I said earlier ... my theory is: "Don't give them the chance to mess it
up."

[Tom]

Another option, if most of the back dates fall within a small range,
is to set up a combobox with values of:
* today
* today -1 day
* etc

Works pretty well for 5-7 days, and still allows the user to enter any
date they want (if you set LimitToList = false) if they are really
behind the curve.

Tom