Search results

Sorry SV & Neil, gave you the wrong credits there...must be getting old...

In answer to your problem, I am assuming that you are trying the "WeekdayName" function solution. We need to check to see if there is anything in the date field before attempting the calculation. To do this, change the controlsource formula to...

I bow to Neil's expertise - I seem to have found the proverbial sledge-hammer! In both of our solutions, just create another field with it's ControlSource property set to the date input field. Rgds Rod

Hi Adrian I am running Access 2002 and have the WeekdayName function available which will do the trick for you. The syntax is ... =WeekdayName(Weekday([<DateField>]),<Abbreviate>,<FirstDay>) Where: WeekDay[...] function returns the day index number <DateField> = the field name of the date...

I absolutely agree with RV. If you intend to have what is typed into the combo-box displayed in the drop-down at a later stage, then you have to save it to its' own table. If you don't mind typing "Dr", "Sir" each and every time in the future, then ... ...you can set the "LimitToList"...

Here is some code to get you going... Good luck. Rod Some assumptions: 1) Your list of dates are in column A and the first one is in row 2. If not, change the Range("XX").Activate to that cell. 2) There are no blank cells in the list. If there are, the macro will only convert up to the first...