Recent content by theDBguy

One way to export data into Excel without a stored query is to use the CopyFromRecordset method.

If I understand that correctly, a normalized structure might be something like this: tblPartTypes TypeID, pk TypeDesc tblParts PartID, pk TypeID, fk tblEquipment EquipID, pk Desc etc. tblEquipParts EquipPartID, pk EquipID, fk PartID, fk

If you're new to relational database design, you might look into Normalization Theory and Principles. I wouldn't create separate tables for each part. Doing that might help solve your issue.

Sorry, missed it.

Hi. Welcome to AWF!

Saw it. I was typing when you were posting...

If you just want to give it a try, you can try the following steps: From the Navigation Pane, select the table you want for your form From the Create tab on the Ribbon, select More Forms > Split Form

Just curious, have you tried using a split form?

Just checking, don't you need to include the field list to append?

Hi. Welcome to AWF! PS. I have moved your thread out of the introduction forum to avoid confusion. Please feel free to post an intro there if you are inclined to. Cheers!

Are you saying you want to mark "paid" multiple invoices at the same time?

Hi. Welcome to AWF!

Are you able to post a sample db with test data? Are we talking about the built-in navigation buttons or something you created? To see how many records are in the subform, you can check its RecordCount property. Sent from phone...

Hi. Welcome to AWF!

@The_Doc_Man Congratulations and well deserved!!!