Search results

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!!!

Hi. Welcome to AWF!

Are you using an @outlook.com address? If so, check out this page. https://support.microsoft.com/en-us/office/pop-imap-and-smtp-settings-for-outlook-com-d088b986-291d-42b8-9564-9c414e2aa040

You should be able to get the server settings from your Exchange Server admin or your IT department.

I think you can also do this with a query against the MSysObjects table, if you care to avoid using code. Sent from phone...

If that was in response to my suggestion of using stored procedures, those are two different things. In case you weren't aware, stored queries are created in Access, while stored procedures are created in SQL Server.

Not sure why you need a recordset for this, couldn't you just use a single action query? Or, maybe you could move the logic to a stored procedure instead?

Hi. Welcome to AWF!