HELP: update access from excel userform

[sam]

Hi all,

Is is possible to update access table from an excel userfrom even if the
user inputing the data in userform doesnt have access installed on their
machine?

For eg, the user(no access installed) launches the form from companys local
intranet and populates it and submits (clicks "Submit" button) and the data
goes into access.

Not all employees have access installed on their machines

Thanks in advance

 

[Jeffro1120]

Hi Sam,

One suggestion i would have is if you can you could install the 2007
access runtime engine on the other users PC's. It is FREE and available
through microsoft. One thing to remember is it does not have a navigation
pane so you must have a startup form with buttons to lead to other forms.
once you make your database you have to rename the extension from .accdb to
..accdr. you will also be able to rename your database back to .accdb to get
it back to normal.

 

[Mr. B]

sam,

Yes, it is possible to update an access table from the data entered into an
Excel user form. You will need to use VBA code to open a connection to that
database, then add a new record and populate the fileds with the data from
your Excel userform.

There several examples of programatically opening recordsets and creating
new reocords using VBA code. Just do a google search. As you then try to
work it out, as you have questions post back with your querstions.


-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm