Search results for query: *

Thanks for the reply. I've been seeing some strange things with the Add-ins in addition to the case stated above (analysis toolpak not being selected) There are instances of the analysis toolpak being selected in the addins dialog box, but the EOMonth function still returns the NAME? error...

I am exporting several queries to an existng Excel workbook, Excel, in turn, uses the data in several formulas. The issue I have: After I export the queries to Excel, I have Access Open the destination workbook: Set xlApp = GetObject(, "excel.application") xlApp.Visible = True...

I created the following work around: First - I copied the Make Table Query from the Password Protected Database to the New Database. Second - I added the following SQL line to the copied Make Table Query : IN c:\temp\passwordprotecteddatabase.mdb Third - I added a button to the New Database...

Thanks for the help, but: Pez, I don't know the proper syntax in order to enter the password in the SQL statement of Access. DJN, I already know the password for the database. i need to be able retrieve the results of a make table query from the protected database. I appreciate your help...

I would like to run a maketable query on a separate database by clicking a button on the current database. Is this possible, and if so, how? Three points to make: 1) the separate database in which I want to run the maketable query is password protected. 2) I know the password 3)Access97

Is it possible to modify an SQL statement that will allow a make table query in the current database to retrieve data from a password protected database and then export the results to the current database? I've tried running the make table query and Access tells me that the password is...