Search results

Hi I have a Data Access Page with a pivottable that I export to excel once a month. I want to alter the "export to excel" button in the DAP file to activate a macro in excel to run as soon as the pivot table finished exporting to excel. The excel macro will format the Pivottable and add some...

I am sending a mail 24 time from Access but my outlook ask me everytime if I will alow a external application (Access) to use my outlook. I cant change my security settings as it is set up by my company Will it work if I disable the displayalerts in outlook and can I do it in VBA from Access...

I have a DAP set up with a Pivottable. The user of the DAP can click on the export to excel button to export the detail to excel. My question is as follows: When the detail/Pivot is exported to excel it must be a read-only file in excel to force the user to save it as a different excel file...

A quick question I have 24 queries and all of them starts with qrySel and then a person's name. Currently I have 24 "Openquery" commands in VBA to open the queries refresh them and close them. Is there a way that I can do this with one simple code and not 24 docmds? Thanks

Hi all I have the following query in Access. This is the sql view of the query " SELECT Right([TRXDATE],7) AS [Month], dbo_GL00100.ACTNUMBR_3, dbo_GL00100.ACTNUMBR_4, dbo_GL00100.ACTDESCR, dbo_GL00102.ACCATDSC, dbo_GL20000M.DSCRIPTN, dbo_GL20000M.USWHPSTD, dbo_GL20000M.TRXDATE...