Search results for query: *

I have an excel sheet that is being generated daily by MS Access. I have searched about a dozen forums and no one seems to know how to bypass the 'overwrite' prompts access gives you. Since the worst case scenario has reered its ugly head, I have decided that it might be effective to simply...

Anyone know how to automatically excecute a macro in excel? I am emailing this file out to a drop box. Anyone in the department can then open the file. I would like it to then activate a formatting macro that I wrote. Thanks!

I'm running a macro that saves a report as an excel spreadsheet. This macro is called by the task manager daily. (it's automated because I can't physically be there to run it myself) Whenever the macro gets to the command that translates the report to an .xls a dialog pops up asking me if I...

Looking for a little syntax help. I'm writing an excel module that will scan each cell for a date. If the date is not equal to today's date then I would like to highlight the entire row grey. So far I was thinking something along the lines of the follwing: Because this is my first time doing...

Hello, I am using MS Access to generate daily error reports and exporting them to excel spreadsheets and sending them out via email. The exporting part is easy however I would like to shade out all of the records prior to today. Basically if the date is not today, I need the entire row to be...

I’m using a macro that calls a set of approximately append queries 15 in a sequence. Does anyone know of a way to: 1) Stop the process immediately if there is an error with one of the appends, and 2) Send out an email to a specific person if and when such an error occurs Any help with this...

I’m using an append query to generate an error report table based on various other queries. Is there a way to incorporate in the Error Report Table text strings AND the data from the various queries? For example … in the Error Report Table, I would like to have something like: There are _____...

I'm using a module to automate a process in Access. Any Ideas on how to use a get past the “Connect to X database” prompt? I tried to use the sendkeys command: Sendkey (tab) Sendkey(my username) Sendkey (tab) Sendkey (tab) Sendkey(my password) Sendkey (tab) Sendkey(enter) Etc. To get past it...

I’m having a little trouble. I have set up a macro that automates the execution of Append Queries. When the amount of rows to append is small (<100,000) there is no problem appending. Once I start getting into the area of hundreds of thousands of rows the query appears to run fine until the...

I have created subroutines in various modules to take action on various tables, macros, and other modules. I would like to use the same subs to take action on tables, macros, & mods from another database. What’s the best way to reference this? A little syntax demo would help wonders. Thanks

I'm trying to use VBA to compact a database on a sheduled timer. When I run the following code I get the error message: You attempted to open a database that is already opened excluisvely by user 'Admin' on machine 'XXXXX'. Try again when the databse is available. This happens with every...

In VBA: How would I go about compacting the entire database after &quot;DELETE * FROM Update_Table1&quot;-ing thousands of records? Is there a simple command? Thanks TD

Hi, I'm trying to run a module that I've created using the windows scheduler. This is what I have: RUN: &quot;C:\Program Files\Microsoft Office\Office\msaccess.exe&quot; &quot;C:\Program Files\Microsoft Office\Office\Samples\ Northwind.mdb&quot; /x:AUTO_EXEC START IN: &quot;C:\Program...

I would like to create a table using a make table query and preserve/copy the index of the original table (the one the query uses to form the new table). Is this possible or am I asking Access 97 for too much? Thanks TD

I need to automate a process for updating hundreds of tables. For each table I will need to: 1) Truncate (delete) the information that is currently in the table but leave the headings intact. 2) Run append queries to add the new data. Each table will essentially look the way it did the day...