=Format(Now(); "ww")

[Jan Eikeland]

Environment : Windows XP home edition and Access97 sr-1
hello.

This expressen soons make me crazy.

Everytime i try to put it in a textbox in field controlsource, ACCESS
changes
expression to =Format(Now(); """ww""") and happily writes ww in the textbox.

Ive tried to use double ' and more or less " without any sucess.
Ive also tried to use Date instead of Now.
Ive checked the References and three first checkboxes are checked.

This is way to far beyond my level to cope with.
Can anyone help out?
Thank You.
reg Jan

 

[Jan Eikeland]

hi, thanks for reply
the case is that the expression doesnt work in my tekstbox.I try to add it
in the controlsource field.
Access changes it by adding two semicolons at each side of ww and
therefore shows ww in the textbox instead of the weeknumber of date.

reg jan

 

[jmonty]

Well I am not quite sure what is happening then. Sounds
like something is corrupted. Try this:
Creat a NEW, blank form and add a textbox.
Enter =Format(Now(), "ww") into the ControlSource.
If it works on this form then it's the form and not the
software. Your old form may have some problems that Access
can't seem to fix. This happened to me once. If it works
copy and paste all the controls form the old form into the
new, along with the code and delete the old form.
Or, I hate to say it, but re-create the form from scratch.
Try it and if it doesn't work repost it under a new
heading and maybe someone else can help.
That's about the best suggestion I can give you, sorry.

 

[Jan Eikeland]

ive done what u suggested , except from starting at the beginning, no
results.

tks for ur time
reg jan

 

[Jan Eikeland]

Oh my.
Week is same as Uke in Norwegian.
My thoughts : ww (week...) uu(uke....)
Parameter uu gave me weeknumber.
I havent found a signgle notice about it in Norwegian version of Access97.
regards jan

 

[John Vinson]

Everytime i try to put it in a textbox in field controlsource, ACCESS
changes
expression to =Format(Now(); """ww""") and happily writes ww in the textbox.

That's bizarre.

This needs to be fixed - see below - but try using a completely
different expression:

DatePart("ww"; Date())

This 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.

 

[John Vinson]

Oh my.
Week is same as Uke in Norwegian.
My thoughts : ww (week...) uu(uke....)
Parameter uu gave me weeknumber.
I havent found a signgle notice about it in Norwegian version of Access97.
regards jan

Uuuuuu....

Glad you got it figured out. And score another point for the dreadful
indexing of the Help files!