Not without knowing what date you're passing to get that value and how
you're calculating it...

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"cel504" wrote in message
...
That's great and I have mangaged to do that now, one other point, the
weeks
are out of sync by one, ie, 200505, should be 200504, any ideas on why.

"Douglas J. Steele" wrote:

Functions like DatePart and Format (both of which can be used to
calculate
week) have two optional arguments that let you specify the first day of
the
week (use vbMonday, or 2 in your case) and first week of the year. Check
the
Help file for details.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"cel504" wrote in message
news
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