Selasa, 28 Juli 2015

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

 

Sarah-


Go to:


.. and get Access 2003 Inside Out.zip - it contains all the sample databases from my book.  All the sample databases have custom menus and toolbars defined.  Also see the PDF that I just uploaded that's the chapter from my 2003 Inside Out book describing how to build custom menus and toolbars in 2003 and earlier.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jul 27, 2015, at 6:14 PM, sarahk@schemesoftware.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> 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
Microsoft Office Access MVP
My nothing-to-do-with-Access blog



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

 

__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

.

__,_._,___

Tidak ada komentar:

Posting Komentar