Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Remove 'Macro Builder' Option

Discussion in 'Information Technology' started by Adrian, Jul 28, 2006.

  1. Adrian

    Adrian
    Expand Collapse
    Guest

    Access 2003

    When choosing 'Build Event' form a form how can I have it automatically open
    the VBA code builder, rather than always give me a choice of this or the
    'Macro Builder'. I know there is a way but cannot find this option anywhere.

    Thanks for any help.

    Adrian
     
  2. Loading...


  3. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Adrian,

    If you enter [Event Procedure] in the event property on the Property
    sheet (you can double-click to shortcut this), then clicking the
    ellipsis (...) button at the right of the property box will then take
    you straight to the VBE window.

    --
    Steve Schapel, Microsoft Access MVP


    Adrian wrote:
    > Access 2003
    >
    > When choosing 'Build Event' form a form how can I have it automatically open
    > the VBA code builder, rather than always give me a choice of this or the
    > 'Macro Builder'. I know there is a way but cannot find this option anywhere.
    >
    > Thanks for any help.
    >
    > Adrian
    >
    >
     
  4. Adrian

    Adrian
    Expand Collapse
    Guest

    Steve,

    Thanks.

    I am sure there is a way of clicking the ellipsis (...) button to take you
    straight to the VBE window without having to enter [Event Procedure] in the
    event property.

    We have recently upgraded from Access 2000 and I was able to do this.

    Adrian

    "Steve Schapel" <schapel@mvps.org.ns> wrote in message
    news:eM7dMRadGHA.3348@TK2MSFTNGP03.phx.gbl...
    > Adrian,
    >
    > If you enter [Event Procedure] in the event property on the Property sheet
    > (you can double-click to shortcut this), then clicking the ellipsis (...)
    > button at the right of the property box will then take you straight to the
    > VBE window.
    >
    > --
    > Steve Schapel, Microsoft Access MVP
    >
    >
    > Adrian wrote:
    >> Access 2003
    >>
    >> When choosing 'Build Event' form a form how can I have it automatically
    >> open the VBA code builder, rather than always give me a choice of this or
    >> the 'Macro Builder'. I know there is a way but cannot find this option
    >> anywhere.
    >>
    >> Thanks for any help.
    >>
    >> Adrian
     
  5. Jeff Conrad

    Jeff Conrad
    Expand Collapse
    Guest

    I believe you need to do to this:

    Go to Tools | Options | Forms/Reports

    Look for the tick box called:

    Always use Event Procedures

    That should do it.
    --
    Jeff Conrad
    Access Junkie - MVP
    http://home.bendbroadband.com/conradsystems/accessjunkie.html
    http://www.access.qbuilt.com/html/articles.html

    "Adrian" wrote in message:
    news:eJGgOaadGHA.3556@TK2MSFTNGP02.phx.gbl...

    > Steve,
    >
    > Thanks.
    >
    > I am sure there is a way of clicking the ellipsis (...) button to take you straight to the VBE
    > window without having to enter [Event Procedure] in the event property.
    >
    > We have recently upgraded from Access 2000 and I was able to do this.
    >
    > Adrian
    >
    > "Steve Schapel" <schapel@mvps.org.ns> wrote in message
    > news:eM7dMRadGHA.3348@TK2MSFTNGP03.phx.gbl...
    >> Adrian,
    >>
    >> If you enter [Event Procedure] in the event property on the Property sheet (you can double-click
    >> to shortcut this), then clicking the ellipsis (...) button at the right of the property box will
    >> then take you straight to the VBE window.
    >>
    >> --
    >> Steve Schapel, Microsoft Access MVP
    >>
    >>
    >> Adrian wrote:
    >>> Access 2003
    >>>
    >>> When choosing 'Build Event' form a form how can I have it automatically open the VBA code
    >>> builder, rather than always give me a choice of this or the 'Macro Builder'. I know there is a
    >>> way but cannot find this option anywhere.
    >>>
    >>> Thanks for any help.
     
  6. Adrian

    Adrian
    Expand Collapse
    Guest

    Jef,

    Thanks. That is what I was looking for. I had looked several times through
    the options but somehow missed it.

    Adrian

    "Jeff Conrad" <jeffc@ernstbrothers.com> wrote in message
    news:uWMcpOddGHA.2188@TK2MSFTNGP04.phx.gbl...
    >I believe you need to do to this:
    >
    > Go to Tools | Options | Forms/Reports
    >
    > Look for the tick box called:
    >
    > Always use Event Procedures
    >
    > That should do it.
    > --
    > Jeff Conrad
    > Access Junkie - MVP
    > http://home.bendbroadband.com/conradsystems/accessjunkie.html
    > http://www.access.qbuilt.com/html/articles.html
    >
    > "Adrian" wrote in message:
    > news:eJGgOaadGHA.3556@TK2MSFTNGP02.phx.gbl...
    >
    >> Steve,
    >>
    >> Thanks.
    >>
    >> I am sure there is a way of clicking the ellipsis (...) button to take
    >> you straight to the VBE window without having to enter [Event Procedure]
    >> in the event property.
    >>
    >> We have recently upgraded from Access 2000 and I was able to do this.
    >>
    >> Adrian
    >>
    >> "Steve Schapel" <schapel@mvps.org.ns> wrote in message
    >> news:eM7dMRadGHA.3348@TK2MSFTNGP03.phx.gbl...
    >>> Adrian,
    >>>
    >>> If you enter [Event Procedure] in the event property on the Property
    >>> sheet (you can double-click to shortcut this), then clicking the
    >>> ellipsis (...) button at the right of the property box will then take
    >>> you straight to the VBE window.
    >>>
    >>> --
    >>> Steve Schapel, Microsoft Access MVP
    >>>
    >>>
    >>> Adrian wrote:
    >>>> Access 2003
    >>>>
    >>>> When choosing 'Build Event' form a form how can I have it automatically
    >>>> open the VBA code builder, rather than always give me a choice of this
    >>>> or the 'Macro Builder'. I know there is a way but cannot find this
    >>>> option anywhere.
    >>>>
    >>>> Thanks for any help.

    >
    >
     
  7. Jeff Conrad

    Jeff Conrad
    Expand Collapse
    Guest

    You're welcome, glad to help.
    Good luck with your project.

    --
    Jeff Conrad
    Access Junkie - MVP
    http://home.bendbroadband.com/conradsystems/accessjunkie.html
    http://www.access.qbuilt.com/html/articles.html

    "Adrian" wrote in message:
    news:OZWHWfddGHA.4912@TK2MSFTNGP05.phx.gbl...

    > Jeff,
    >
    > Thanks. That is what I was looking for. I had looked several times through the options but somehow
    > missed it.
    >
    > Adrian
    >
    > "Jeff Conrad" <jeffc@ernstbrothers.com> wrote in message
    > news:uWMcpOddGHA.2188@TK2MSFTNGP04.phx.gbl...
    >>I believe you need to do to this:
    >>
    >> Go to Tools | Options | Forms/Reports
    >>
    >> Look for the tick box called:
    >>
    >> Always use Event Procedures
    >>
    >> That should do it.
    >> --
    >> Jeff Conrad
    >> Access Junkie - MVP
    >> http://home.bendbroadband.com/conradsystems/accessjunkie.html
    >> http://www.access.qbuilt.com/html/articles.html
    >>
    >> "Adrian" wrote in message:
    >> news:eJGgOaadGHA.3556@TK2MSFTNGP02.phx.gbl...
    >>
    >>> Steve,
    >>>
    >>> Thanks.
    >>>
    >>> I am sure there is a way of clicking the ellipsis (...) button to take you straight to the VBE
    >>> window without having to enter [Event Procedure] in the event property.
    >>>
    >>> We have recently upgraded from Access 2000 and I was able to do this.
    >>>
    >>> Adrian
    >>>
    >>> "Steve Schapel" <schapel@mvps.org.ns> wrote in message
    >>> news:eM7dMRadGHA.3348@TK2MSFTNGP03.phx.gbl...
    >>>> Adrian,
    >>>>
    >>>> If you enter [Event Procedure] in the event property on the Property sheet (you can
    >>>> double-click to shortcut this), then clicking the ellipsis (...) button at the right of the
    >>>> property box will then take you straight to the VBE window.
    >>>>
    >>>> --
    >>>> Steve Schapel, Microsoft Access MVP
    >>>>
    >>>>
    >>>> Adrian wrote:
    >>>>> Access 2003
    >>>>>
    >>>>> When choosing 'Build Event' form a form how can I have it automatically open the VBA code
    >>>>> builder, rather than always give me a choice of this or the 'Macro Builder'. I know there is a
    >>>>> way but cannot find this option anywhere.
    >>>>>
    >>>>> Thanks for any help.
     

Share This Page