Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find Dialog Box settings (2002)

    At the local PBS TV station, they are using Office 2002. When we use Find, either via the Menu or the Toolbar, the Find Dialog Box opens properly. There are several options on the Dialog Box. We are having problems with the "Search fields as formatted" option. We de-select the option, remove the check mark, so all occurrences will be found. When we select Find again, the "Search fields as formatted" option is selected again and we have to de-select the option again. I can not find a way to permanently de-select this option. Would someone give me some assistance on this matter.

    Thank You in advance.
    Jim

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

    Re: Find Dialog Box settings (2002)

    Unfortunately, there is no way to change the default setting for "Search fields as formatted". For a workaround, see MSKB article ACC2000: How to Set Defaults for the Find and Replace Dialog Box (valid for Access 2002 too)

  3. #3
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find Dialog Box settings (2002)

    Hans,
    Thank You for the speedy reply. But, I must say "This Stinks" as one did not have to do the work-around in Access 2000. If the option was de-selected, it would stay that way. Since I'm using code with the "On Click" property for the field to have Find open , it should be easy? to add the SendKeys action.

    Thank You agian
    Jim

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

    Re: Find Dialog Box settings (2002)

    In my Access 2002, the setting "sticks" during a session, as long as Access stays open. If I quit and restart Access, the settings will be back to the default.

    If you are using code already, just insert
    SendKeys "%o"
    immediately above the instruction that opens the Find dialog (presumably RunCommand acCmdFind)

  5. #5
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find Dialog Box settings (2002)

    Good Afternoon,
    You said that "the setting "sticks" during a session" for you, I was unable to get it to stick for the session or if I closed Access. If I closed the Dialog Box because it was in the way, it returns to the defaults the next time it was opened. I've printed the MS KB you pointed to and played with it here at home. Below is the code I've been using and the SendKeys - RunCommand lines which are currently commented out. The SendKeys - RunCommand code did work properly here at home, but will not be at the PBS station until next week to try it out in Access 2002.

    DoCmd.GoToRecord acForm, "All Volunteers", acFirst, 1
    DoCmd.GoToControl "Last Name"
    DoCmd.RunCommand acCmdFind

    'SendKeys "%hs""%n", False
    'RunCommand acCmdFind

    Is there a KB that lists all the Keystrokes for the different Dialog Boxes or do you just have to look at the Box for the code? Along with this, where can I find a list of the acCmd's with discription and possible help with their construction?

    Thank You again for your assistance.
    Jim

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

    Re: Find Dialog Box settings (2002)

    The MSKB article I posted a link to higher up in this thread lists the accelerator keys for the Find dialog, but I don't think there is an article listing the accelerator keys for all dialog boxes.

    Terry Wickenden has a site dedicated to RunCommand; you'll find lots of useful info there - click the links in the left pane of the web page.

    <img src=/w3timages/blueline.gif width=33% height=2>

    About the code you posted:
    - There are two RunCommand acCmdFind lines.
    - It is not necessary to prefix RunCommand with DoCmd.
    - Don't put quotes within the SendKeys string: use <font face="Georgia">SendKeys "%hs%n", False</font face=georgia>

  7. #7
    Star Lounger
    Join Date
    Aug 2001
    Location
    Cleveland, Ohio, Ohio, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find Dialog Box settings (2002)

    Thank You for Terry's link as it will help greatly. Will remove the mentioned DoCMD's. I wondered about the quotes, but MS does strange things at times as to when and how to use quotes, !, periods, etc that I still have not been able to 'wrap my head around". <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    Thanks again and have a good day.
    Jim

Posting Permissions

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