Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Run-time error 462 and and Run-time error 429
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...- ztchnc
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Remebering Form Entries from previous runs
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...- ztchnc
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
Automating Excel through Access and Importing Queries
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...- ztchnc
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
