Search results for query: *

Hi, I would like to first say that this site is great and the people here are amazing. Anyway I am wondering if it is possible to integrate Impromptu with MS Access, have VBA open and run imr reports and return back the results as an MS Access table. Even something similar like this will be...

Here is an access vba code it works on access but generates an error upon closing the excel file. -------------------------------- Dim oApp As Object Set oApp = CreateObject("Excel.Application") oApp.workbooks.Open ("C:My documents\report_template.xls") oApp.Visible = True...

I may have change one of the syntax accidentally that is why this code isnt working anymore. Can anyone tell me why the paste: xlValues part is not working anymore? It parses fine on Excel but the result is that nothing happens except for getting rid of the ODBC links. Formulas still appear...

My microsoft access doesnt have license to use the microsoft common dialog control and hence I am forced to code it manually. Using the code down below, I somehow forgot how and where should I declare these objects. http://www.tek-tips.com/faqs.cfm?fid=2484 this code line needs to be...

Using the code down below, I somehow forgot how and where should I declare these objects. http://www.tek-tips.com/faqs.cfm?fid=2484 this code line needs to be declared Dim cmdlgOpenFile As New clsCommonDialog dim clsCommonDialog as ? I just couldnt remember this at the moment and need help.

Is it possible for MS Access to be able to link to Cognos Powerplay cubes through an ODBC connection? I would like to be able to slice and dice and link various cubes together in Access. Inform me if this is possible.

Where can I get a cognos powerplay excel add in? I know it exist somewhere online. Please inform me to where I can get this add in to add into excel. Thanks