Search results

I have a macro to export my report daily out to an HTML file. Is there a way I can get Access to automatically overwrite this and not prompt me to ask if I want to overwrite? If not, is there a way to add something to the macro to say YES I do want to overwrite the file? THanks

I have a report in Access that I am saving as an HTML file to then distribute via email. Rather than having people have to click NEXT or LAST PAGE at the bottom of the report to move from page to page, I would like the report to just be one long page.... seems like it should be simple, but I...

I run macro's in Access that create Pivot table's for me each AM. I would like to take the automation one step futher and have the pivot tables export to Excel. Currently, I am going to the Access Pivot table and clicking the button that 'exports to Excel' (little icon of Excel with a pencil)...

Right now I am calculating the difference in time (CRT) between when a call came in and when someone closed (or responded) to that call. DateDiff("n", [ADATECREATE], [ADATERESOLVED]) I would like to take this a step further however and take business hours into consideration. So, if someone...

I have a series of Queries that I run each morning. I am trying to automate this process as much as possible... I have set up some simple macro's in Access to run the queries I need and output them in Pivot table view. I created a Macro that calls each of my macros, so that I could schedule...