Results 1 to 6 of 6
  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: Re: show method is not available

    Hi,

    When I use the show method I rec'd this error in vb:
    MS VB
    Method Or data member not found

    I am using Access 2000.
    This is what I have in the reference library:
    VBA
    MS Access 9.0 object library
    OLE Automation
    MS ActiveX Data Objects 2.1 library
    Ms Outloook 9.0 Object library
    MS Office 9.0 Object library

    Thanks for your help.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    without knowing the line of VBA that Access headbutted on its difficult to say - depends on what you weer trying to do.

    Did you try to debug, and if so what was the line highlighted

  3. #3
    Join Date
    May 2002
    Posts
    395

    Re: show method not working

    Thanks for your replied.

    This is my syntax: Form_name.show
    MS VB error:
    compile error: method or data member not found.

    I'm using Access 2000.

    Would you know why this error or not working?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    yes VB is complaing that the object form_name doesn't exist
    what is form_name is it a form object

  5. #5
    Join Date
    May 2002
    Posts
    395

    Re: show method not working

    yes VB is complaing that the object form_name doesn't exist
    what is form_name is it a form object

    Hi,

    The form_name is the name of an actual form. The spelling is correct, I just can't understand why this is not available.
    Perhaps you can give me an sample code to display a form called sample_start using show method. This will help me to understand it.

    Thanks!

  6. #6
    Join Date
    Nov 2004
    Posts
    10
    Well, if form_name is the actual name of the form, VBA in Access will expose the form as form_form_name (adds the "form_" prefix). However, I don't think that the show method (or hide, for that matter) is available in vba.

    I would use:
    DoCmd.OpenForm "name"
    where name is the name of the form.

    You could also use Forms("name") to get at a form that was already loaded.

Posting Permissions

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