week number in Access 2002

  • Thread starter Thread starter papa
  • Start date Start date
P

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
 
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
 
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
Click to expand...
Take your pick:
=DatePart("ww",Date())
or...
=Format(Date(),"ww")
 
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.
Click to expand...

Set the Control Source of an unbound textbox to

=DatePart("ww", Date())
 
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
 
Hi Guys,
I'm probably doing something stupid but none of the above
seem to work!!!! I also upgraded to Access 2003 last
night.
Click to expand...

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.

\
 
Back
Top