neillovell
Programmer
Hi,
in MS Access I have a form set up so when the user selects a date from a drop down menu the following code executes for the Week field
Me.txtWeek = DatePart("ww",Me.txtDate)
So if 16/10/2002 was chosen the function would output 44 to the week field (as it's in the 44th week of the year).
Unfortunately when the form has been converted to a data access page this VBA code doesn't work, so I was wondering if anyone had some javascript code that does the same?
I'd really appreciate it.
in MS Access I have a form set up so when the user selects a date from a drop down menu the following code executes for the Week field
Me.txtWeek = DatePart("ww",Me.txtDate)
So if 16/10/2002 was chosen the function would output 44 to the week field (as it's in the 44th week of the year).
Unfortunately when the form has been converted to a data access page this VBA code doesn't work, so I was wondering if anyone had some javascript code that does the same?
I'd really appreciate it.
