ACCESS FEED: Re: [MS_AccessPros] Re: MS Access 2003 toolbar parameter

Senin, 27 Juli 2015

Re: [MS_AccessPros] Re: MS Access 2003 toolbar parameter

Hi Sarah,

glad you saw the video -- thanks

> "It would be fine if the application would be on the local computer and the back end in the cloud."

that would be called a hybrid application ~ You can link to the tables in the cloud from the desktop :)

> "If I put a variable in the 'parameter' field, how do I retrieve it / refer to it in my macro?."

data macros can return results that can be assigned to variables in the calling program

warm regards,
crystal

~ have an awesome day ~

On 7/27/2015 10:14 AM, sarahk@schemesoftware.com [MS_Access_Professionals] wrote:

Maybe I did not explain myself:

I have a switchboard connected to a table where all the options of the program can be selected.

I would also like to have pull down menus in addition to the switchboard.

So I goto Tools > Customize and added a Tool Bar and added the options to my toolbar.

In the properties of the toolbar I have the following control properties:

Caption

Shortcut Text

Screen Tip

On Action

Style

Help File

Help ContextID

Parameter

Tag

1) You say that you dont use Macros, rather VBA, but as far as I can tell 'On Action' only accepts a macro. Am I wrong?.

2) What is the Parameter for if not to pass a parameter to the Macro?. I can work around passing a parameter but I could save a lot of coding if I could pass a parameter.

As always all help is greatly appreciated.

Thanks

Sarah

BTW: I am happy to hear that you consider Access 2003 the best version. I love programming in it. You can basically do anything with it (especially with the help of the people in this group!!! The best and most selfless!!!). I also like the fact that the back end does not have to be an Access DB so that it is flexible.

The only thing I worry about is that it is obsolete: I dont know if MS is going to support this in the long run and also everybody is moving to the 'cloud'. The only option I found for the cloud is 'accesshosting.com'. I have not tried it and dont know if it works. I saw Crystal's demo moving tables to 'Sharepoint', but that wont work for me. I need my users to be able to access the tables in the cloud via an application. It would be fine if the application would be on the local computer and the back end in the cloud.

---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :

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@...> 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