Embedded Macros

[KenB]

I'm using exclusively macros (no VBA) embedded in a series of forms, usually
with the 'On Click' event. When starting to create the macro on the Design
page, the usual choice is EVENT PROCEDURE or MACRO BUILDER. But now I get
EVENT PROCEDURE or NEXT MACRO - which seems to lead nowhere. Have I reached
some limit or done something wrong?

 

[bhicks11 via AccessMonster.com]

That's a new one on me - never seen it. What version of Access are you using
and how many million macros are you using? If you want to start learning VBA
I would suggest saving your Macros as Modules - that converts your Macro to
VBA. Maybe clean up the naming, go to your onclick, select EVENT PROCEDURE
and copy the text there, test and debug. Oh yeah, to find the code, look in
your module tab and you will see what you converted from the Macro. It's a
good way to get started with VBA.

Bonnie

http://www.dataplus-svc.com

 

[KenB]

Thanks, Bonnie -

Your advice was very kind, but I'm afraid I'm too old to start with yet
another 'language'. (After all, I started before there was even Fortran!).
I find it hard to believe that I have reached any sort of restriction on the
number of macros - unless all my earlier efforts are still lurking in the
background. Does anyone know if there is a file or area that should be
cleared? The Access 2007 is part of Office 12, but it doesn't seem to offer
a version number.

 

[bhicks11 via AccessMonster.com]

Your never too old to learn darling. I'm 54 and still learning and hope to
for many years.

I know of (nor can I find anything on) a limit on how many macros you can
have. Something else is going on.

Best wishes,

Bonnie

http://www.dataplus-svc.com

 

[KenB]

Hi Bonnie

You're kind again. But I have to point out that 78 > 54 ---- KenB

 

[Steve Schapel]

Bonnie,

… What version of Access are you using

Access 2007 is the only version that supports embedded macros.

 

[bhicks11 via AccessMonster.com]

Hi Ken,

I am working in 2003 and I see that 2007 has embedded macros and macro groups.
I believe your issue has something to do with that. Maybe somebody more
familiar with 2007 can help you. Sorry I wasn't more help. And by the way -
your doing fine - do keep learning!

Bonnie

http://www.dataplus-svc.com

Hi Bonnie

You're kind again. But I have to point out that 78 > 54 ---- KenB

Your never too old to learn darling. I'm 54 and still learning and hope to
for many years.

[quoted text clipped - 23 lines]

 

[KenB]

Hi Bonnie -

I'm afraid that theory won't work. The computer I'm using has never had
Access 2003 or any earlier versions. Just the current Access 2007 ----
KenB

Hi Ken,

I am working in 2003 and I see that 2007 has embedded macros and macro groups.
I believe your issue has something to do with that. Maybe somebody more
familiar with 2007 can help you. Sorry I wasn't more help. And by the way -
your doing fine - do keep learning!

Bonnie

http://www.dataplus-svc.com

Hi Bonnie

You're kind again. But I have to point out that 78 > 54 ---- KenB

Your never too old to learn darling. I'm 54 and still learning and hope to
for many years.

[quoted text clipped - 23 lines]

EVENT PROCEDURE or NEXT MACRO - which seems to lead nowhere. Have I reached
some limit or done something wrong?