Recent content by intrepidtechie

Hello aaahvaya, Also wanted to mention to you http://4guysfromrolla.com This site would give you lots of information and code snippets. Goodluck

The best simple solution I can suggest is make a copy of the DB on your ISP on your local drive and do all your import work right there on the local machine. Then use any sync software and sync the Db on the local drive with the Db on the ISP. Sync softwares are easy to find. Just check...

Helo aaahvaya, I would recommed that you visit http://www.aspin.com This is going to your friend for all your asp tutorial and code needs. You dont have to use the code give on aspin.com but you can sure get an idea to make something on your own. Goodluck...;)

I know this sounds really simple but I am a access novice I have a query that is supposed to remove 000s from a column and this is the way it is. UPDATE Table_000 SET account_number = Format(account_number, "#") I want to add one more column name to this query to perform the same function...

Hello MoLaker, I did exactly as you mentioned. Add the code to the VB routine and created a table and wrote the macro. When I ran the Vb routine it went well (I think). Then I opened the db to check if it ran the query. But when I opened the db it gave me a alert "Microsoft Access can't find...

The Scenario: A VB process runs and updates the MS Access DB with new data everyday. I have created a query to make some changes to the data once its imported. Currently I have to run it manually. Would like to automate the process. Some one suggested this method given below Store a value in a...

Hello MoLaker, I think what you are trying to explain is to keep a boolean value to check if the VB process ran or not. If the Vb runs and updated the DB the set the flag to True and run the query and then reset it back to False after the query has done its work. I got the logic but an example...

Hello All, I am using Oracle 11.03 based application and when I view some reports I get "FRM:99999: A network error occurred, the client will not be able to continue." error. I resinstalled Jinitiator and JDK files. When I open the link for reports first the screen starts flickering. Then when...

Thanks PHV, I think this should do the magic for me.

Hello PHV, Could you suggest a code snippet that can do the Vb routine to launch a query after DB updates

I am sorry guys this didnt work. Maybe I did it wrong. Can you suggest a simple macro to run a query automatically eachtime the database gets updated. More information. The database gets updated by a VB routine that imports new data everyday morning (like a batch process). The query is written...

how do I write a macro to call a query and then do the "add the /x macroname switch to the scheduled task command line

I have a update query that I want to setup to run with a Scheduled Task. Any ideas anyone.!!!

Could anyone provide an example to use a "OnTimer Event" to run a query.

Hello MoLaker, I have never done this "flag" thing. Could you provide an example maybe.