Results 1 to 4 of 4

Thread: How to run Query Automatically on MS Access

  1. #1
    Join Date
    Aug 2008
    Posts
    129

    How to run Query Automatically on MS Access

    I studies the online projects currently i need to have a database that joins several different databases together using Access. One of the columns in the main table that is updated nightly is called FileName and another is Date. I have a table with a field that accepts ID numbers. I wanted to segregate the individual customer by adding some string to the Customer ID which should be properly edited by the barcode reader, I think this all will come under the Access filter so and to remove those unwanted characters the the data should be entered.

  2. #2
    Join Date
    Oct 2008
    Posts
    127

    Re: How to run Query Automatically on MS Access

    If you have a single xxx.mdb file that is your back-end copy of all the relevant ODBC tables, This is something you would use to periodically update some records, refresh some data, or have any sort of timed database event. then every night run a routine to empty the tables and repopulate them, you will find the xxx.mdb. This is definitely closer as the error is gone now, but the behavior I am seeing is that the update query creates a new table with one column and populates it with the values already set in "IMD_Owner".

  3. #3
    Join Date
    Oct 2008
    Posts
    132

    Re: How to run Query Automatically on MS Access

    Windows utility can open an application at a specific time which can in turn run code. Use a template access mdb file (template.mdb) containing all the target tables, but all empty, and copy this to xxx.mdb. Use the FileCopy VBA statement, make a query of your table with the data and in the ID column in design view, enter this for the field (rather than ID).

  4. #4
    Join Date
    Feb 2006
    Posts
    185

    Re: How to run Query Automatically on MS Access

    If you happen to work in an office where co-workers are kind enough to shut your PC down at night, you could have issues with the code not running. I did that so that when I make a query with these fields--[name],[items],[date],[item check out id],[item return id],[notes]--the name will automatically display everytime someone swipes their ID in the [item check out id] fields because of that relationship. I tried that mid() function, it only worked if I put the numbers in the [item check out id] field in table (2), and then made the query with that mid(). I am now getting a message "Cannot join on Memo, OLE, or Hyperlink Object..." The data in the table Master is dumped to every night via a link to it from another dB.

Similar Threads

  1. Create batch file to run access query
    By DeMario in forum Software Development
    Replies: 5
    Last Post: 31-12-2009, 04:44 AM
  2. How to Automatically access the fields of an Access 2007 forms
    By Corona in forum Software Development
    Replies: 3
    Last Post: 25-06-2009, 12:54 PM
  3. Limit Rows Returned In Access Query
    By NetWorm in forum Software Development
    Replies: 4
    Last Post: 25-02-2009, 10:32 PM
  4. Help in Access query
    By $tatic in forum Software Development
    Replies: 4
    Last Post: 20-12-2008, 05:38 PM
  5. Excel function calculations used in MS Access query
    By akbar in forum MS Office Support
    Replies: 1
    Last Post: 23-05-2008, 08:52 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,650,029.72545 seconds with 17 queries