Search results

Hi everyone I have a problem with my VB code not running when inserting triple state button value containing NULL values in the script bellow: The check boxes are all triple state with default value of NULL but can contain a yes or no when required. This loop work fine when the value is yes or...

Is there any way for me to get the dates inserted by using the default in WeekNo field?

Thanks a Mil, this is working 100% Thank you again for your assistance

I have trimmed it down.

Hi arnelgp, I have tried changing my db with what you did with the db you attached but I am doing something wrong with it. May I load my db on box for you as it is about 30mb in size.

Thanks arnelgp this is exactly what I was looking for

Thanks Minty but I am not sure if it would work, see my image attached. The top portion is part of the main table and the bottom is a sub form. What I want to achieve is when I select the week in the main form the sub form creates the new records automatically for that week by default based on...

Hi Everyone, I need some assistance with a VBA function that can assist me to pre-populate my subform with dates linked to a WeekNumber drop down in my main form. The sub form needs to be pre-populated as soon as I select the week number from the drop down and the user have to be able to still...