467,905 Members | 1,714 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,905 developers. It's quick & easy.

Menu callback function in Form's code module

Access 2k FE/BE

My application allows users to enter employee hours against rotas
(i.e. who is rostered on, and when).

They further want a function to output a report showing the number of
hours that each employee is rostered, and to be able to do this for
any week. To this end there is a control on the "Rota" form which
shows the "Week Commencing", with "Next >" and "< Previous" buttons.

They want to kick this report off using a menu item. So I created a
custom menu with an option "Calculate Hours", and put the callback
function in the code behind the "Rota" form (the "Rota" form must be
loaded to get the "Week Commencing" value.

However, if I put the code there, Access puts up an error:

"can't run the macro or callback function"

If I move the function to a module, it works.

This is not a big issue, but am I right therefore to conclude that
menu callback functions can ONLY exist in modules?

TIA

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk
Nov 13 '05 #1
  • viewed: 1628
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Egbert Bouwman | last post: by
3 posts views Thread by ThinkRS232 | last post: by
4 posts views Thread by jesse.hartwick | last post: by
2 posts views Thread by David | last post: by
6 posts views Thread by =?Utf-8?B?Sm9lbWFuYw==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.