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 - the solution 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.ozgrid.com/forum/showthre...184#post780184
crossposted: http://www.mrexcel.com/forum/excel-q...ds-access.html

crossposted: http://www.ozgrid.com/forum/showthread.php?t=201608

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).