week number in Access 2002

[papa]

Hi Guys,

Just a quick question.

Does anyone know how to get the week number to appear on
a form in access?

as in this is currently week 8.

What I need for reference purposes is for the week number
to appear and update itself.

Rgds,
Papa

 

[Jeff Conrad]

Hi,

How about this as the Control Source for a text box:

=DatePart("ww",Date())

Returns 8.

Hope that's what you're looking for.

Jeff Conrad
Bend, Oregon

 

[fredg]

Hi Guys,

Just a quick question.

Does anyone know how to get the week number to appear on
a form in access?

as in this is currently week 8.

What I need for reference purposes is for the week number
to appear and update itself.

Rgds,
Papa

Take your pick:
=DatePart("ww",Date())
or...
=Format(Date(),"ww")

 

[John Vinson]

Hi Guys,

Just a quick question.

Does anyone know how to get the week number to appear on
a form in access?

as in this is currently week 8.

What I need for reference purposes is for the week number
to appear and update itself.

Set the Control Source of an unbound textbox to

=DatePart("ww", Date())

 

[papa]

Hi Guys,
I'm probably doing something stupid but none of the above
seem to work!!!! I also upgraded to Access 2003 last
night.

Can anyone offer advice?

Rgds,
Papa

 

[John Vinson]

Hi Guys,
I'm probably doing something stupid but none of the above
seem to work!!!! I also upgraded to Access 2003 last
night.

Try typing Ctrl-G to open the VBA editor and typing

?DatePart("ww", Date())

in the Immediate window. If you get an error message,
it may be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

\