Hi All,

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?

Thank You!