If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HELP: update access from excel userform
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 |
#2
|
|||
|
|||
HELP: update access from excel userform
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. "sam" wrote: 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 |
#3
|
|||
|
|||
HELP: update access from excel userform
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 "sam" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|