Name of the week

[seb]

Hello
I think I have a very basic problem but cannot find any solution.
I Have googled and searched a lot but no success!

Also I tried many times Function DatePart, but any time I failed
In MS Access 2013, I have a Form named Jorns. In Txtbox Dte I write dates. Also I have TxtBok wkk.

Could someone tell me how to display the week of the year in field wkk any time I write a date in field Dte?


In my case the first week of the year is the first Monday of the year.

Many thanks

[ssanfu]

In text box "wkk", maybe try:

= DatePart("ww",Dte,vbMonday)

[seb]

ssanfu
Hello. I tested the code, does not work.

[orange]

See this info re DatePart. Pay particular attention to the firstWeekOfYear. See if your requirement fits one of the options.

Also, does not work does not help. Did you get an error message? Did you get a value that you didn't expect?

[ssanfu]

Apparently, Access does not understand "vbMonday".
Try changing "vbMonday" to 2.

DatePart("ww",Dte, 2)

[seb]

Hello orange.


According to the Function DatePart, in mycase the firstWeekOfYear is the first week of January
Now, when I Type
DatePart("ww",Dte, 2)


Access change to:
DatePart("ww";[Dte]; 2)


Theres is not error message. Also there is no value al all.


I also tryed this code with no succees


'Function ww() As String
ww = Me!Dte & ""
End Function'


'Function ww() As String
ww = Me!Dte & ""
End Function'


This code works well in another db Form I designed in Access 2010.



I am really

Many thanks for your help

[pbaldy]

Apparently, Access does not understand "vbMonday".

Sure it does...in VBA code.

[orange]

Now, when I Type
DatePart("ww",Dte, 2)


Access change to:
DatePart("ww";[Dte]; 2)


Theres is not error message. Also there is no value al all.

Where did you type that?

The substitution of ";" for "," is because of your regional settings.

In the immediate window, I type and get

?datepart("ww",Date,2)
42

[seb]

Hello
I Typed in "On Click" in Field ww of the Form

[orange]

Type your code into the immediate window. And see if there is an answer.

Start the line with ? which indicates Print the value.