Search results for query: *

Thanks RoyVidar for the help, I looked at both threads and I believe that I've followed their recommended guidelines. I have checked and made sure that I released all the objects but maybe there is something I am not seeing. I normally set any worksheet and workbook object back to nothing and...

I'm doing some excel automation through an access form and I've run into this problem today. Everytime my code runs through the fIsAppRunning("Excel") code (which I find is very useful) I get the following errors on the GetObject(,"Excel.Application") line. The weird thing is this doesn't happen...

Thanks For the help guys, I just used tables to store the information and used a query to populate the fields when the user made a choice from a combobox.

I am new to Access forms and just recently started working with them. I have already created a form and it runs pretty well but I want to make it a little better. The form contains a few unbound text boxes that the user inputs values before running the commands. I want to know if there is a way...

PHV: I'm unfamiliar with that command can you elaborate? henniec: I tried working with your code and it looks to me like it isn't finished and I kept getting errors with the line containing "conWKB_NAME" after I had placed my directory and file: Const conWKB_NAME = “C:\Documents and...

Last week I started looking into automating Excel from Access so that I may be able to create spreadsheets faster. I was able to run a macro that created a new Excel sheet for me and made the layout I wanted however I am unfamiliar with pulling up queries and adding them to Excel. To get around...