Remove 'Macro Builder' Option

[Adrian]

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

 

[Steve Schapel]

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.

 

[Adrian]

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

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

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

 

[Jeff Conrad]

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

in message:

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

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

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]

Jef,

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

Adrian

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

in message:

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

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.

 

[Jeff Conrad]

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

in message:

Jeff,

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

Adrian

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

in message:

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

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.