By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,894 Members | 1,942 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,894 IT Pros & Developers. It's quick & easy.

Shortcut menu change problems in A2K

P: n/a
I have some code that adds entries to the "Module Compiled" popup
menu. Works fine in A97. You can open a module, right click, and the
new entries are there for you to click. I converted it to A2000, and
reapplied the new entries. But now when you open a module and right
click (in A2K), the new entries are nowhere to be seen.
If (while in the database window) you click on View, Toolbars,
Customize, Toolbars tab, tick the Shortcut Menus box, then select the
Module menu, ModuleCompiled - you can see the new entries are there.
So they appear to have been added to the "Module Compiled" menu OK.
But if you open a module, click on View, Toolbars, Customize you seem
to get a different toolbar from A97. It has only got Debug, Edit,
Menu Bar, Shortcut Menus, Standard, UseForm. And if you then check on
Shortcut Menus you only get entries for Forms, Code Windows, and Misc.
This toolbar doesn't sem to have an equivalent in A97, but it's
obviously the one in force when you design a module.
I'm new to A2K and obviously missing something fundamental here ... ?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

A2K and higher versions split the development environment into 2
environments: Access objects and VBA. Earlier versions had both of
those in one development environment. You'll have to put your
customized pop-up menu in the VBA environment.

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP5WLOIechKqOuFEgEQKBBwCg6alEJr/RFWyMg46Bf3UOhEQssscAoN+5
U0wn7Kkw3fIQqbytFEkEBIMO
=rorj
-----END PGP SIGNATURE-----

Terry Bell wrote:
I have some code that adds entries to the "Module Compiled" popup
menu. Works fine in A97. You can open a module, right click, and the
new entries are there for you to click. I converted it to A2000, and
reapplied the new entries. But now when you open a module and right
click (in A2K), the new entries are nowhere to be seen.
If (while in the database window) you click on View, Toolbars,
Customize, Toolbars tab, tick the Shortcut Menus box, then select the
Module menu, ModuleCompiled - you can see the new entries are there.
So they appear to have been added to the "Module Compiled" menu OK.
But if you open a module, click on View, Toolbars, Customize you seem
to get a different toolbar from A97. It has only got Debug, Edit,
Menu Bar, Shortcut Menus, Standard, UseForm. And if you then check on
Shortcut Menus you only get entries for Forms, Code Windows, and Misc.
This toolbar doesn't sem to have an equivalent in A97, but it's
obviously the one in force when you design a module.
I'm new to A2K and obviously missing something fundamental here ... ?


Nov 12 '05 #2

P: n/a
OK I understand that now. But it still looks like the VBA environment
in A2K is missing the "Custom" command - which means you cannot
execute a vba function from the module window like you could in A97.
To put it more clearly, in the A97 customise dialog box (and in the
A2K access Objects environment) you could select "File" under
categories and the very top Command available would be "Custom".
You could drag this into a toolbar and under properties set the name
of a vba function.
You can't do this in the A2K vba environment. The Custom command is
missing.
And why have they left the Module entries under the Access Objects
shortcut menu anyway? As you have pointed out, you can no longer
invoke module shortcut menus from the Access Objects environment, so
they go nowhere, don't they?
Anyway it's a real letdown if I can't use a custom, home grown command
while viewing inside a module - I had several labour saving tools in
A97 that were saving heaps of development time in A97 ...

MGFoster <me@privacy.com> wrote in message news:<VW**************@newsread4.news.pas.earthlin k.net>...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

A2K and higher versions split the development environment into 2
environments: Access objects and VBA. Earlier versions had both of
those in one development environment. You'll have to put your
customized pop-up menu in the VBA environment.

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP5WLOIechKqOuFEgEQKBBwCg6alEJr/RFWyMg46Bf3UOhEQssscAoN+5
U0wn7Kkw3fIQqbytFEkEBIMO
=rorj
-----END PGP SIGNATURE-----

Terry Bell wrote:
I have some code that adds entries to the "Module Compiled" popup
menu. Works fine in A97. You can open a module, right click, and the
new entries are there for you to click. I converted it to A2000, and
reapplied the new entries. But now when you open a module and right
click (in A2K), the new entries are nowhere to be seen.
If (while in the database window) you click on View, Toolbars,
Customize, Toolbars tab, tick the Shortcut Menus box, then select the
Module menu, ModuleCompiled - you can see the new entries are there.
So they appear to have been added to the "Module Compiled" menu OK.
But if you open a module, click on View, Toolbars, Customize you seem
to get a different toolbar from A97. It has only got Debug, Edit,
Menu Bar, Shortcut Menus, Standard, UseForm. And if you then check on
Shortcut Menus you only get entries for Forms, Code Windows, and Misc.
This toolbar doesn't sem to have an equivalent in A97, but it's
obviously the one in force when you design a module.
I'm new to A2K and obviously missing something fundamental here ... ?

Nov 12 '05 #3

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I've never created special tools for handling VBA modules, so . . . .

I have Access XP & I can customize my VBA toolbars by right-clicking
the VBA toolbar. When the Customize dialog box opens there is a
CommandButton for New toolbars. I'd guess that's where one would
create VBA pop-up menus.

HTH,

- --
MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP5b4xYechKqOuFEgEQKhvwCcDopKJWTeSLaO0QDJtMsufy t+jyQAoK6B
qvNFcjc3SnYinwYTt/GMBTFl
=zeHF
-----END PGP SIGNATURE-----

Terry Bell wrote:
OK I understand that now. But it still looks like the VBA environment
in A2K is missing the "Custom" command - which means you cannot
execute a vba function from the module window like you could in A97.
To put it more clearly, in the A97 customise dialog box (and in the
A2K access Objects environment) you could select "File" under
categories and the very top Command available would be "Custom".
You could drag this into a toolbar and under properties set the name
of a vba function.
You can't do this in the A2K vba environment. The Custom command is
missing.
And why have they left the Module entries under the Access Objects
shortcut menu anyway? As you have pointed out, you can no longer
invoke module shortcut menus from the Access Objects environment, so
they go nowhere, don't they?
Anyway it's a real letdown if I can't use a custom, home grown command
while viewing inside a module - I had several labour saving tools in
A97 that were saving heaps of development time in A97 ...

MGFoster <me@privacy.com> wrote in message news:<VW**************@newsread4.news.pas.earthlin k.net>...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

A2K and higher versions split the development environment into 2
environments: Access objects and VBA. Earlier versions had both of
those in one development environment. You'll have to put your
customized pop-up menu in the VBA environment.

MGFoster:::mgf
Oakland, CA (USA)


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.