Hello,
I am somewhat familiar with Excel VBA, but have no knowledge of Access VBA.
I am trying to automatically enter data into a couple of forms in an access file with a .mde extension. I would like to use macros to automatically open the Access.mde file, enter data to various fields on the form ( tab key is used to move to various fields), open another form in the file, enter more data from my excel file and then close the Access.mde file.
Can this be done. I can't enter data directly to the associated .mdb file that holds the tables since there are some variables added to the table that vary depending on the data entered in the .mde file.
Any help appreciated,
Cliff
I am somewhat familiar with Excel VBA, but have no knowledge of Access VBA.
I am trying to automatically enter data into a couple of forms in an access file with a .mde extension. I would like to use macros to automatically open the Access.mde file, enter data to various fields on the form ( tab key is used to move to various fields), open another form in the file, enter more data from my excel file and then close the Access.mde file.
Can this be done. I can't enter data directly to the associated .mdb file that holds the tables since there are some variables added to the table that vary depending on the data entered in the .mde file.
Any help appreciated,
Cliff