Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Reading, Berkshire, England
    Posts
    199
    Thanks
    9
    Thanked 0 Times in 0 Posts

    update query (XP)

    I have created an update query which inserts an value into a field of a Table(an end date of a course). I would like the update query to run automatically when the Table is opened, is this possible? I am sure that a VBA coding could be written to achieve this task, but my efforts have had no success to date.
    A screen shot of the update query is attached.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: update query (XP)

    Tables in Access don't have events or triggers.

    If the SignOf Date (shouldn't if be SignOffDate?) field is going to be modified each time, you don't need it as a field in the table. You can calculate it in a query based on the table, and use the query as record source for forms and reports. The date will then always be up-to-date.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •