Sarah
As far as I know there is no way to pass a parameter to a function in a custom toolbar. But you can add a line that accepts an InputBox where the user types in the parameter. another way is to add a line that takes a control's value from a form.
If you give us more information we can be more specific. I, for one, use VBA instead of macros for 99.9% of my commands So my answer would probably lean in that direction. 2003 is the best version of Access ever released and makes using VBA a snap...at least in my humble opinion.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <sarahk@schemesoftware.com> wrote :
I have a custom toolbar in ms access 2003. The 'on action ' refers to a command in a macro.The command works fine. However, I would like to pass a variable to the macro. If I put a variable in the 'parameter' field, how do I retrieve it / refer to it in my macro?.
I have googled all day , but cant figure it out.
Please help.
Thanks
Sarah
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar