Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Setting Option Edit/Find (Access XP)

    I have the setting under Options - Edit/Find - Confirm - Record Change, Document Deletion, Action Query toggled. The problem is when I run a program like CCleaner it deletes some file and that resets these items. Are their code to write into a macro.

    TIA

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

    Re: Setting Option Edit/Find (Access XP)

    I'd exclude MS Office from the items CCleaner cleans.

    You can run the following procedure to restore the settings:

    Sub RestoreSettings()
    Application.SetOption "Confirm Record Changes", True
    Application.SetOption "Confirm Document Deletions", True
    Application.SetOption "Confirm Action Queries", True
    End Sub

    Replace True with False if you don't want to be prompted (not recommended)

Posting Permissions

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