Archive database that is linked to an excel table.

Originally Posted by alansidman

Need more information to make this happen. If you are adding data, then which button will do this? For each of the fields in your form, where will the data go?

For the search button, which columns will each of the fields look in to find the result. Which field will you be using to search?

A sample workbook to go with this form would be really helpful. Can you attach a sample workbook. It only needs to have a representative number of entries and not your full workbook.




Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hello Alan.

Many thanks for your message. I do apologise for not replying sooner, since not only am I working on this database, I am working on another which is super complicated but it involves svgs etc. Anyway, I will upload a png if that is ok and spoiler it.

[spoiler]archives.png[/spoiler]