Search results

Thank you, your code worked!

I do not know anything about writing code. I got the code I am using from a YouTube video. I need some to tell me the exact code to use.

I am creating a financial report in Access 2007. My report has a subreport. I am trying to pull subtotals from the subreport. Some of my fields from the subreport do not have any data, so I am receiving an #error in the text box. I need a code to turn the #error into 0. I currently have the...

The combo box is on a form and there is an after update event procedure code. I am attaching to screenshots.

I have a bound combo box on my access form. I keep getting a Null Value debug error, when I clear the contents of the box. Say for example I start to type a name in the box and for whatever reason I want clear the name and not continue with inputting information on the form, I get Run-time...

Thanks The_Doc_Man, for your reply! I am new to Access and I don't know how to write event procedure codes. I don't want my form auto save records. I only want it to save records to my table when I hit the new record button. I also, want it to update existing records in my table, when I hit...

The access form is bound, however currently when I try to change a clients address it creates a new record on my table. I want to be able to add new clients with my form and update current client information.

Is it possible to add an update record button to my Access form? I want to be able to update an existing record in my database. I all read have a record search combo box on my form, that auto-fills the form with the info from my table. I would really appreciate the help.

Also, is it possible to add an update button to my form? I want to be able to update an existing record in my database. I already have a record search combo box on my form, that auto-fills the form with the info from my table.

I have add the codes below to my form. When I click the save button the pop to confirm saving comes up, but when I click yes it does not save the data on the form to my table. What am I doing wrong? Private Sub Form_BeforeUpdate(Cancel As Integer) If Not blnSave Then Cancel = True...