Recent content by hazeleyre23

the subform uses a different table to the main form. So the main form has 3 different sub forms on it as they are all linked a different table. Therefore my main form does not have a record source. Yes I can update/alter the data in the subform if I open it separately to the main form.

Hi, I keep getting a message "Record set is not update able" when I try can to update my fields in access. I have looked at many forums and I have removed the distinct, checked my has table a primary key and it does not link to any other tables, however I am still getting the error message...

I have worked out how to do it: If Weekday(DateChased) = vbThursday Then dtedate2ndchase = DateAdd("d", 4, [DateChased]) Else If Weekday(DateChased) = vbFriday Then dtedate2ndchase = DateAdd("d", 3, [DateChased]) Else dtedate2ndchase = DateAdd("d", 2...

Hi, I have a date controls (Date Entered) which is manually entered in Access, however I have another date controls (Date Chased) in which I want this controls to automatically populate with +2 working (Monday - Friday) days from Date Entered. Therefore If the date happens to be a Friday on the...

thank you for pointing me in the right direction. I have now fixed it :)

Thank you both for your replies. Is the format "YYYY-MM-dd" in VBA access? thank you

Hi, I have an update statement which works but only with dates 1st - 12th and I can't understand why. Currentdb.Execute "UPDATE dbo_Agent_Data SET ToDate = #" & Me.txtUpdateToDate & "# , LogTime = '" & LogTime & "' WHERE id_NEW = " & Me.txtUpdateID & "", dbSeeChanges The code updates the...

Thank you so much, you have been very helpful and patient :D

sorry to be a pain! Yes, I want to find the max ToDate then add one day onto this. thank you for your help

Sorry, but If I wanted to find the Max ToDate would I just add it into the same formula or would this have to be done on it own. The reason I want to find the Max ToDate is so it always picks the latest date. thanks

PERFECT! Thank you

Thanks, do i put this in the code or in the default value (from the properties sheet)? As when i put it in my VBA Code it says 'Expected: = ' thanks

Using that code, how do I add a day onto this. So if the ToDate = 2016/04/04, how do I + a to this to get 2016/04/05. Thanks

thank you. that works perfectly :)

Hi, My main form : Maintenance Subform (within main form): UpdateAgentInfo Form I want to populate the date onto: UpdateAgent. What I want to be able to do is use the FromDate field from my subform to populate on my UpdateAgent form txtUpdate field when it is opened: I have tried...