Excel Userform to input Access Records

**freud1** · 08-04-2009, 10:35 AM

Hi Guys,

I am trying to create a userform in Excel, once the form is filled out, i want a button which will send the data through to an access database as a new record.

I have seen this done before through VBA coding but I don't know how to get this working.

The userform contains the following fields starting at cell D3 and continuing down to cell D17

CustomerName
Address1
Address2
Address3
Address4
Address5
Postcode
ContactName
ContactNumberLandline
ContactNumberMobile
ContactEmail
SiteContactName
SiteContactLandline
SiteContactMobile
SiteContactEmail

These fields all link to a Database located at: C:\Documents and Settings\User\Desktop\TESTDB.adp

they are to be inserted into the table : Customer_Details

I also have a cell on the userform for TextNote which is to be inserted into another Table but uses the Key Field Number from the Customer_Details table.

I know that you probabilly need more information in order to help but If any of you can help or perhaps if you have a template code that can help me to achieve this i will be forever greatful.

many thanks

**Macdave_19** · 08-04-2009, 11:28 AM

This may help:

Please Login or Register  to view this content.

make sure you have the ref: DAO Object Library 3.6 enabled

**freud1** · 08-04-2009, 11:50 AM

thanks for your help macdave i get an error saying:

runtime error "3343"

Unrecognised Database format C:\Documents and Settings\User\Desktop\TESTDB.adp

is this causing an issue because the database is in *.adp format?

**Macdave_19** · 08-05-2009, 04:09 AM

it might be? not to familiar with the file type? is it a split access database with a back and front end?

also have you made sure that the reference DAO 3.6 Object Library is enabled?

**freud1** · 08-05-2009, 04:23 AM

Hi,

yes the DAO 3.6 Object Library is enabled, I am not very familiar with Database setups, but i would assume it is a split system, the database itself is very locked down, it has no toolbar options when it is opened and users interact through userforms only.

**Macdave_19** · 08-05-2009, 11:10 AM

Maybe it's worth speaking to the relevant parties who created it then.

from what i can see it must be the .adp file extension that it's not regonising?