Recent content by chizzy42

HI, i was just playing around there with the dates and that was the last number, they were actually several years overdue, now its all good and up to date...hurrah

thanks for the info, i was just looking at a preventative database i did several years ago and was looking to update the dates in the due column to try it out , it was just a bulk update to realign the dates to play with the database again ie have the maintenance due dates spread over the next...

Gasman, GPGeorge,bastanu,theDBguy.... Thanks for your time and patience on this, i got well confused on this one and its working now how id like it, i went to try python and ended up with a mental block with vba....need to brush up on dao Private Sub Command0_Click() Dim DQRY As String Dim dbs...

Hi GPGeorge, i ran the update query Update tblDataLog Set [PM Due] = DateAdd(IntervalType, Number, [PM Due]); and filled in the d requirement and number of days and it does update ok, so that helps me in that i can forward the dates but when i try to run it as the vba function, i now get run...

thanks for that (and the dbGuy) couldnt see that one for looking at it,

Thanks for replying gas man im not sure if im getting what you mean..is it like this you mean : Dim IntervalType As String Dim Number As Integer Number = 6 IntervalType = "d" DQRY = "Update tblDataLog Set [PM Due] = DateAdd(IntervalType, Number, [PM Due]);"

I was a bit fuzzy on this part i was sure whether to add the field into the Dateadd part as i thought it was being added to the field at the Set part??? DQRY = "Update tblDataLog Set [PM Due] = DateAdd('d', 6,[PM Due]);"

HI GpGeorge just to clarify im trying to update the entire date values in the column by a certain amount by a certain factor of days, its a database i made up years ago for maintenance and was looking to upgrade it to use again. [PM Due] is the date column in the table tbDataLog. i was nt sure...

hi gas man i think i see what you mean DQRY = "Update tblDataLog Set [PM Due] = DateAdd('d', 6);" db.Execute DQRY i changed it to the above but still getting the same error

Hi Gasman tblDataLog holds the column PM DUE which has the dates

I used dbs and the object problem moved to db.execute DQRY

HI theDBguy and GP George, thanks for the quick replies.I noticed i had missed the select from also and the table was wrong, im getting the object required now on db.Execute DQRY line Dim sql As String Dim DQRY As String Dim data1 As Date Dim dbs As DAO.Database Dim rst As DAO.Recordset sql =...

Hi, hope all is well . I was looking to update a date column in a table and was trying to do it by a button with VBA and seem to have got into a fankle. (ive been messing with python and getting confused now with vba). Im trying to update a column called "PM Due" in a table tblDataLog which...

Thanks for that dbGuy for bringing that to my attention : RPSno = Nz(DLookup("[cell]", "tblSkills", "[cell]='" & Forms![frmcellskills]![Text24] & "' "), "") 'RPSno = Nz(DLookup("[Cell]", "tblSkills", " [Cell] = ' " & str & " ' "), 0) If RPSno <> "" Then just realised i was tring to compare...

hi dbguy , command19 button has a data mismatch error13 and the command26 button still doesnt return a value