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

I did misspell the word. Corrected it and it worked fine. The only problem is that the query is exported as a DAP with a PivotTable. When I try to refresh the pivottable on the DAP it tells me that the criteria is missing although it still shows in my textbox Thanks for all the help

Thanks for the help I put in the following criteria <="Froms!frmMEAnalytics![txtdate]" when I run the query it gives me a Data Type mismatch error How can i resolve this. My field in the table is a "date/time" data type with a format of "Short Date" My texbox [txtdate]'s format is also...

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...