Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Week 53 and week 1, 2010
I just got perfect answer from Michiel: ------------ I suppose that when you use =Format(Date();"ww";0;3) as ControlSource for the field, you'll be a happy man. You can leave the 'Format' and 'DefaultValue' of the field empty. hope this helps Michiel > Hello, > I have a problem within...- avi951
- Post #20
- Forum: Microsoft: Access Forms
-
Week 53 and week 1, 2010
Well thanks guys for your replies but still it ain't clear to me. Can I accomplish correct WW within the form by adjusting properties or do you mean some hard coding is needed (eg. Herman's "format cmd (vbmonday,vbFirstFourDays)..." - where do I enter this? please clarify, TIA- avi951
- Post #15
- Forum: Microsoft: Access Forms
-
Week 53 and week 1, 2010
Hello, I have the same problem within the form. In form I have a date with default value 'Date()' which is formatted as week ('ww')showing week numbers. It was ok for the previous year but now it reads date Jan, 4th as week No 2 while I need it to be No 1. Please help.- avi951
- Post #12
- Forum: Microsoft: Access Forms
