Recent content by nemodied

Thanks for all the help! It just seemed that I forgot to set the connection haha! Here is the working code I used to Update/Insert Customer Information! Private Sub Save_Click() Dim db As ADODB.Connection Dim rs As ADODB.Recordset Dim X As Integer Forms("Reservation")!Rents.Enabled =...

Hey guys, I have an error in my Validation Rule Property... I get this error everytime I enter the Reservation Number (autonumber) into the field, to grab the Customer ID. "The macro or function set to the beforeupdate or validationrule property for this field is preventing access from saving...

Re: Update/Insert Query with AutoNumber.. Noobie here :( EDIT: working on something.

Update/Insert Query with AutoNumber.. Noobie here :( Hi guys, I'm trying to do an Insert/Update VBA code into my project, but everytime I try to run it it gives this error: Object variable or With block variable not set. It happens on both the Insert and Update. The CustomerID is an...