Search results

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...

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...

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...

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...

Do I just add the dbSeeChanges to the end of the statement. Do I need to do anything before as currently is this is my full code, from reading other forums I think I might be missing parts?! Private Sub cmdUpdateToDate_Click() CurrentDb.Execute "UPDATE dbo_Agent_Data SET ToDate =...

Hi, I am trying to use an UPDATE statement in VBA. Below is my code, however when I try run it, I am getting an error message. currentdb.Execute "Update dbo_Agent_Data set ToDate = #" & me!txtUpdateToDate & "# WHERE id_new = " & me!txtUpdateID the error message I am getting is: "You must...