Search results

I have a report which runs over three pages for each record. I have different sections of data from different tables in the report. Each of these sections is a different sub report. In order to force each section on a new page I've selected Force New Page before Section in the Report Header...

Hi Pat, as I said in my previous comment, the code was given to me and it didn't really do what I was hoping. This is a bulk update. I select all puppies from a specific litter to update wormings and vaccinations which are the same for all of them. It saves time rather than updating them one...

Thank you so much ArnolGP, it's working! I might get there one day 😊

The code was given to me by someone else. Not having much experience with vba code I just don't know how to fix it. I've added dbFailOnError and I'm getting this error: Data type mismatch in criteria expression. This is what I get in the Immediate Window. INSERT INTO tblMedicalTreatments...

I have a listbox from where I select records, I enter the data and then update the table with the data entered. It runs through without any errors, getting the message "All Medical Details Inserted" but none of the data have been written to the table. Anyone who can see what I do wrong? Is...

Thank you for your reply. It is working 😊

I want to set the focus on the Email field if already exist. Not getting an error but it goes to the next field instead. Private Sub Email_AfterUpdate() If DCount("*", "tblContacts", "[Email] = '" & Me.Email & "'") > 0 Then MsgBox "This Email already exists:-" & vbCrLf, vbOKOnly +...

Not really sure what you mean by that. The data I'm looking for is in the same subform as the combo boxes.

That's what I thought as well. I've gone through it a million times, checking for spelling errors and I've even redid all the forms with no luck

Thank you for accepting me. I'm not very experienced with Access. What I know, I taught myself, so please excuse my lack of knowledge. I have a main form with a nested subform. In the 2nd subform, I have a cascading combo box. This is my Row Source in the 2nd combo box.

Sorry, I didn't mean to post it here. I'll repost!

Thank you for accepting me. I'm not very experienced with Access. What I know, I taught myself, so please excuse my lack of knowledge. I have a main form with a nested subform. In the 2nd subform, I have a cascading combo box. This is my Row Source in the 2nd combo box. SELECT...