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...

Hey Guys, Thanks a lot for all of your help. I'm quite sure this will work for what I'm doing but I'll try it anyway. The kind of error I'm dealing with happens when the system is running a query and it just kind of hangs. I think if this happens, the next command in the mod (or mod) will...

I would have sent this to you yesterday but the site was down. Thanks a bunch for the tip. At least now I know that I was perhaps going in the wrong direction. Any suggestions on how to do this with code? I'm pretty sure that I'm all set with translating the commands from the macro to the...

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 can't. The database MUST remain closed because I'm compacting it.

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...

Do you have a full sample? There are about 4 of 5 arguments and I don't quite see how they all peice into the subroutine.

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

Hey, It works!! Thanks! You need the colon on the switch but you certainly want to point the scheduler to a macro that calls the code from the module. Thanks also for the heads up on the freeware. 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...

That's actually pretty exactly what I'm doing now except I'm using a link table instead of copying, then using the Append Query. My boss is convinced however that indexing would eliminate the need to delete first. Since I'm deleting hundreds of thousands of rows this would save a lot of time...

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