Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: intrepidtechie
  • Content: Threads
  • Order by date
  1. intrepidtechie

    Adding mulitple fields in a query

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

    How to run a query based on boolean values - "flag"?

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

    Getting a "FRM:99999: A network error occurred" error

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

    How to use Task Scheduler to run a query

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

    How to use OnTimer Event for Queries

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

    How do you trigger a query to run automatically

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

    Queries in Access

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

    How to trim 000s in VB

    Hello Friends, This is the situation. I have a Access table that gets new data imported from another table (from the mainframe) through a VB process. Once the table gets updated one of the columns have extra precedding 00s..for example..instead of showing 384799474..it shows 00000384799474. Also...
  9. intrepidtechie

    Trim 000s from a table column

    Hello Friends, This is the situation. I have a Access table that gets new data imported from another table (from the mainframe) through a VB process. Once the table gets updated one of the columns have extra precedding 00s..for example..instead of showing 384799474..it shows 00000384799474. Also...

Part and Inventory Search

Back
Top