Excel UserForm to browse, update, add and delete records in Access

Hi all,

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

crossposted: http://www.mrexcel.com/forum/excel-questions/972949-excel-userform-browse-update-add-delete-records-access.html
crossposted: http://www.excelforum.com/exce…te-records-in-access.html

Re: Excel UserForm to browse, update, add and delete records in Access

Apologies - I have updated the original post to include links to crossposts.

Re: Excel UserForm to browse, update, add and delete records in Access

Quote from AlanSidman;780191

Instead of updating the table in Access, have your table in Excel. as if it were a table in Access.

The requirement to have a user form in Excel which lets users directly browse/update/insert into/delete from the table is a hard requirement unfortunately - I have to do it that way for a variety of reasons.