Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hidden Objects (Access 2000)

    Can i turn off the option Show hidden objects in Access by code?
    In order to do that i go to Tools,Options and then i click off the box Hidden Object.
    Can i make a statement by code to say ShowHiddenObjects = False ?
    And if so,how to decide whether hidden objects are already turned off? May be
    that will lead to a conflict ?

  2. #2
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hidden Objects (Access 2000)

    Thank you for your suggestion.That is what i need, but the command
    Application.GetOption("Show Hidden Objects"), set in the OnClick event of a control,
    gives me a Compile error, argument not optional.What does it mean ?

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

    Re: Hidden Objects (Access 2000)

    GetOption is a function. You must do something with the return value of the function, for example assign it to a variable or display it in a message box.

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hidden Objects (Access 2000)

    Actually i have set it to False, i.e. Application.SetOption("Show HiddenIbjects") = False

    and it is then that i get the message that argument is not optional

    regards

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

    Re: Hidden Objects (Access 2000)

    Edited by HansV to correct error in code

    You can use Application.GetOption("Show Hidden Objects") to inspect the current setting, and

    Application.SetOption"Show Hidden Objects", False

    to set show hidden objects to False. Type GetOption or SetOption in the Visual Basic Editor and press F1 for more info.

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

    Re: Hidden Objects (Access 2000)

    I'm sorry, I didn't check the syntax. It has to be

    Application.SetOption "Show Hidden Objects", False

    I have corrected my original 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
  •