How can I set the work week to be Monday to Sunday, or even Sunday to Saturday?

Can anybody help please?


"cel504" wrote:

Can anyone help with this.
When I enter a date onto the database, I need to convert the date to a year
and week format. I have two problems.

The first is the year and week becomes say 20059, but I need it to be
200509, how can I get the extra nought before the 9.
When I enter the date, the data baseconverts it ok, but is currently 1 week
out of sync. ie, 07/02/05 convers to week 11 and not week 10......any ideas
please.


"Rick Brandt" wrote:

cel504 wrote:
Does anybody know how to stop the screen from flickering when
switching between forms. I know in Excel the code is
Application.ScreenUpdating.False, I have tried using this in Access
without success. Is there a way of closing one form, when another is
opened?

Application.Echo False
(do some stuff)
Application.Echo True

Make sure you include an error trap that also sets the Echo back to true or your
user could get stuck with an app that won't update the screen.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com