I am trying to automate a report I do daily. I am using MS Access to do this. I was able to get a link to the database REMEDY using the ODBC connectivity. I have a query file (.dgy) that I use to generate this report. I then take that report and created a master spreadsheet that is loaded with formulas. What I want to do is create a form in Access to have this data generated automatically into the form or subform if I need to create one. I have created command button in the form but I am not sure of the script to write for in using VBA. Any suggestions??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automating a Form in Access
- Thread starter jalenben1
- Start date
Similar threads
- Locked
- Question
