I need to create an Excel VBA form that will allow users to browse, update, add and delete records in a single table in an Access database. The structure of the table is as follows:
ID (Number) | Currency (Text) | Issued (Date/Time) | Available (Yes/No) | Value (Number)
The Excel VBA form is a hard requirement - it must be a user form in Excel. I can't use an Access form for various reasons.
Bonus: I am unable to change the structure of the Access database, but I would like the form to display the ID field as 8 characters long, including leading zeros, e.g. 00002721.
I've tried to Google this already, but most of the solutions either require the data to be stored in Excel, or use a form within Access rather than Excel.
Does anyone have any suggestions, or can you point me to a resource that will give me some code I can adapt to my needs? Thanks in advance