Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Access10 does update the date.

30 views
Skip to first unread message

Peter Jason

unread,
May 24, 2012, 6:19:56 PM5/24/12
to
I upgraded from Access2003 to Access10, and I use
it for my small business.

When I leave the computer on all night I find the
date remains the same as the previous day, and I
have to close & reopen the program to get the date
updated.

Is there any way to have the date match the
computer one?

Peter

bsn

unread,
May 25, 2012, 2:38:02 AM5/25/12
to

"Peter Jason" <p...@jostle.com> skrev i en meddelelse
news:gqctr7dau4vmudav1...@4ax.com...
You can use the forms Timer event and a little VBA code...
Bjarne


Patrick Finucane

unread,
May 25, 2012, 9:25:21 AM5/25/12
to
Could you define the date? Is it on a date of a form? Let's say you
have a form. In the OnOpen event of the form you have
Me.DateField = Date()

That date will stay the same until closed and reopened. A better
place to update the date is in the OnActivate event. Still, you'd
have to move off that form and return to activate the action to reset
the date.


Peter Jason

unread,
May 25, 2012, 7:08:53 PM5/25/12
to
Thanks, but it's the system date. The old
versions of Access didn't have this problem. We
leave the computer running all the time so I think
I will need some way to update at 12.01am every
day.

Access10 also has a problem where the combos in a
sub form don't drop down with the F4 key; a most
annoying problem. Surely there's a switch
somewhere to fix this?

Peter

bsn

unread,
May 26, 2012, 4:57:26 PM5/26/12
to

"Peter Jason" <p...@jostle.com> skrev i en meddelelse
news:k240s7lt188b4tsi6...@4ax.com...
Did u try the Timer event...???
Bjarne


Phil

unread,
May 27, 2012, 4:31:15 AM5/27/12
to

>>
>
> Thanks, but it's the system date. The old
> versions of Access didn't have this problem. We
> leave the computer running all the time so I think
> I will need some way to update at 12.01am every
> day.
>
> Access10 also has a problem where the combos in a
> sub form don't drop down with the F4 key; a most
> annoying problem. Surely there's a switch
> somewhere to fix this?
>
> Peter
>

There have been other posts on the F4 not working.
I have never had a problem with it either on forms or subforms.
The only way I can reproduce the problem is I have a key on my keyboard
calles "F Mode". If this has been pressed, F4 no longer works. I think
instead the F4 key switches on or off a second monitor. Try pressing the "F
Mode" key and see if that works

Phil
0 new messages