Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Coding warnings (all)

    I have created a small DB application in Access and the user wants to be able to review/edit at the table level (not through the application) in order to do QA of data entry clerks. I have told them that this is possible but to beware that if certain fields within the tables are changed (keys and foreign keys) it could break required links and that could cause severe unintended consequences (data anomalies).

    I was then asked if it possible to code a warning so that if a user were to attempt to change the value of one these fields there would be a pop up warning.

    My question simply

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

    Re: Coding warnings (all)

    Access does not have triggers at the table level, so it is impossible to pop up a warning when a user edits a value directly in a table. Why not provide a read-only form (for example a continuous form, or even a datasheet form) for the quality checks?

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> PS It would be nice if you provided some feedback to the replies you receive, otherwise other Loungers reading your threads don't know if the replies were helpful. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Coding warnings (all)

    Thanks Hans. A continuous form might be the trick for identifying necessary changes then making those changes through the application. Very helpful.


    [and thanks for the whisper... tips are always helpful and I am remiss in not consistently making a reply]

Posting Permissions

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