Recent content by johnbongrovey

Thanks Paul & Marvin Works fine and a better understanding of the syntax :)

I am trying to edit an existing record in my database.It goes to the correct record to update but will not update if "RecordUpdate" is specified as auto numbered. If the "RecordUpdate" is just specified as a number in the query it is fine. CurrentDb.Execute "UPDATE QryIssueData " & _...

I would like to thank you for the information Galaxiom. Worked fine and good to go. The biggest issue I have with the VBA is the "') and where they are supposed to go. Another learning experience for me.

I am trying to delete a record from a table and when I pass the variable as a text value it works but when I pass as a number I am getting a mismatch error. I have to use it as a number as I am doing other update code in my database and it is a number. Code: DoCmd.RunSQL "DELETE * FROM...

Thanks Paul I found the issue with my "Where statement" Changed from: "Where UnitNumber =" & Me.UnitNumber.Tag Changed to: WHERE UnitNumber =" & Me.txtUnitNum.Tag I was using the UnitNumber on both ends of the statement Thanks again for your assistance with this issue

The only thing that I really want to do is to take a record in a table and update the data from the form data that I put in. I am struggling with something that I would think would be simple. I am using Unbound fields in my form and I have a primary key in my table. I would like to select the...

I am taking the tblvehicle and trying to take the variable's from the form and put into the table. Private Sub Update_Click() CurrentDb.Execute "update tblVehicle " & _ " set Me.txtUnitNum =" & UnitNumber & _ ", Department ='" & Me.cboDepartment & "'" & _...

I have a form that I am inputting data into. I have been able to Clear the form. I have created an edit script and it brings the data from the table to populate the form. When I try to change the data in the form and run a VBA update to push the data down to the table I am having no luck. I can...

Hello all, I am presently employed in Fort McMurray AB Canada and I am a novice, self-taught user. Most of my exposure to access and VBA has come from manuals and YouTube. I have learned many interesting things from this forum and look forward to participating as I grow with the community. VBA...