Search results for query: *

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.

I would like to run it within Access not in the Vb routine.

I am looking for a method to trigger a query each time the table gets updated. For your information the table is getting updated through a VB data import routine. If you can provide any information on how to make a auto firing query that would be great. Thanks in advance, IntrepidTechie

Hello Mordja, I am building this MS Access database based application for a local school which gets its main data everyday from an Oracle DB. The way the Access database gets updated is through to Vb routine. Simple data transfer code moves data from Oracle to Access. There are some calculation...

Is it possible that a query can be set to run each time a table gets updated with new data automatically. If yes, then what is the method to do this process

Roy/Mark...you guys have been just awesome. One last question..so if I go according to Mark's syntax my code would be ============================================ " SELECT CPT.CUSTOMER_NAME, format(CPT.ACCOUNT_NBR,'#'), CPT.CUSTOMER_NBR, CPT.CUR_BAL_AMT, CPT.DAY_DELQ_COUNT...