June 14th, 2012, 03:21 PM
Is it possible to use VB to extract data from an access project .adp file?
I'm not a newbie or an expert in VB, somewhere in the middle. I appreciate all the help I can get.
Here is my issue, I have an access project created by someone else, this is an ".adp" file, not ".mdb". All I have on the project is a form - screenshot attached.
Pic 1: Shows first part of the form, when I select the create custom data dump, it takes us to the form on Pic 2
Pic 2: This is where all the details are filled up - date is always from 1st of the month till yesterday's date.
What I normally do is populate these fields manually and then create a data dump - the output is an excel file.
Can I use a VB macro to populate the fields for this form and finally create the output file?
Click Here to Expand Forum to Full Width