Search results for query: *

Hi, I appreciate any help you can give. I have a form that updates every few seconds. This form executes a Macro on a Timer Event of 5000 ms. The Macro, exports delimited text to a file on the desktop. This is a small file, maybe 11 kb. It all seems to work fine for a while, then at no...

Using Access 2000, I have added new pages to an existing project to be viewed over internet. The Data is dynamic and refreshes every five minutes. This has been working fine for over a year until I added new pages. Now I'm getting two error messages: "Could Not use "; file already...

I hope this helps. If the gateway,or router is offline, my experiance has shown that the ping will result in "expired in transit." If the end device is offline, the result is "request timed out."

Thank you tlbroadbent!!! Your suggestions solved my problem. I went with the "transfer spreadsheet" command and timed event in a form to execute the macro. Again, I wish to express my thanks. scada 101

Thank you tlbroadbentfor your response, I apologize for not making myself very clear. Allow me to give you a brief topology of my setup. I have an OPTO 22 data aquisition system in the field. This program writes data to acc97. It will not write to acc2000, therefore I have tables in acc2000...

Thanks tlbroadbent, Your suggestion worked. I used the scheduler idea. However, it presented a new problem,overcoming the "overwrite" prompt has become the issue at hand. I need this file to write and overwrite every time the macro runs.This spreadsheet is a file for the customer to...

I have a macro that Outputs a table from acc2000 to an Excel spreadsheet. How can I automate the Macro to run once an hour? Thanks