Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA for Access (Access 2000)

    Hi! This is my first post to this site, so sorry if I'm not specific enough. I'm writing a database in Access 2000, and I need to write code to open and display a form. I tried

    Open (frmxyz)
    Show (frmxyz)

    but the complier gives me error messages. This is the first time I've used VBA, so I'm not real sure what to do, and none of the books or help files I look at seem to be helpful. TIA

    Ruthie B <img src=/S/tongue.gif border=0 alt=tongue width=15 height=15>
    (SammyB's daughter <img src=/S/smile.gif border=0 alt=smile width=15 height=15> )
    Bethel College

  2. #2
    Lounger
    Join Date
    Nov 2001
    Location
    Buckinghamshire, UK
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA for Access (Access 2000)

    When in code you have to use the do command function:

    On the EVENTS TAB insert this code:
    docmd.OpenForm "NAME OF THE FORM",acNormal

  3. #3
    Star Lounger
    Join Date
    Nov 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA for Access (Access 2000)

    Thanks! I'll give it a try.

    Ruthie B <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Bethel College

Posting Permissions

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