Results 1 to 5 of 5

Thread: Multiple instances of a form

  1. #1

    Thread Starter
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478

    Multiple instances of a form

    Does someone know if i can open an instance of an allready opened form in Access.

    The problem is you have to open a form wiht the openform statement applying the formname.

    If it is possible can someone point me in the right direction of handling this.


    Advanced thanks.
    Code:
    If Question = Incomplete Then
       AnswerNextOne
    Else
       ReplyIfKnown
    End If
    cu Swatty

  2. #2
    Fanatic Member
    Join Date
    Aug 2001
    Location
    Connecticut
    Posts
    855
    Dim frm as Form
    Set frm = New FormName
    frm.setfocus
    VB 6.0, Access, Sql server, Asp

  3. #3

    Thread Starter
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    No luck.

    With the setfocus statement it sets the focus to that form which is under another one with dialog view (modal) .

    What i would like is to create an instance of that form and show it modaly (acDialog).

    If someone could help me.
    Code:
    If Question = Incomplete Then
       AnswerNextOne
    Else
       ReplyIfKnown
    End If
    cu Swatty

  4. #4

    Thread Starter
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    *bmp*
    Code:
    If Question = Incomplete Then
       AnswerNextOne
    Else
       ReplyIfKnown
    End If
    cu Swatty

  5. #5
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    Yeah you can. But its better to make an instance first.

    I found it difficult to accomplish (although possible) and my grand Ideas went out the window when it killed Access (ran out of memory...)

    Near enough as ralph posted, just need a public collection to hold the form open.

    I can have a look an see if I have the code available..


    Vince

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

Posting Permissions

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



Click Here to Expand Forum to Full Width