| Developing applications in Microsoft
| |
| | will notice in the Commands list box it
|
| Access is a really pratical and efficient
| |
| | now shows you all the individual
|
| practice and when done correctly can be a
| |
| | functions for this category. For this
|
| very powerful application. Most people
| |
| | exercise let us drag the Cut command onto
|
| use Microsoft Access nowadays simply
| |
| | our Toolbar. First click on the Cut
|
| because of the ease to get the
| |
| | command, hold you left mouse button down
|
| application built and operational is a
| |
| | and keep it held down whilst you drag the
|
| lot faster than using traditional methods
| |
| | icon onto your custom toolbar. Once you
|
| like Visual Basic or C. This is even
| |
| | see a black line come up on your toolbar
|
| more true in that you can distribute
| |
| | release your left mouse button.You should
|
| Microsoft Access Applications without
| |
| | now see the Cut symbol, which is a pair
|
| having a full version of Microsoft Access
| |
| | of scissors on your custom toolbar. To
|
| on the desktop.You can in fact use a
| |
| | add any other commands simply follow the
|
| version called Microsoft Access Run-Time
| |
| | exact same steps.Rule #3 - Try To Group
|
| which allows the person to use the
| |
| | Similar Commands On Your Custom
|
| functionality of the application you have
| |
| | ToolbarWhen you start creating your
|
| built without the user being able to
| |
| | custom toolbars, try to keep the commands
|
| physically modify the elements that make
| |
| | on the toolbars related. For example, we
|
| up the database like the Forms, Reports
| |
| | added the Cut command to our toolbar in
|
| etc. However to make your applications
| |
| | the previous paragraph. It would be an
|
| really useful and user friendly when
| |
| | unwise move to then put the Copy command
|
| using the Run-Time version you really do
| |
| | on a different toolbar and the Paste
|
| need to build your own customised
| |
| | command on a third toolbar. It would be
|
| toolbars and that will be the focus of
| |
| | more logical to keep the Cut, Copy and
|
| this article.Rule #1 - Never customise
| |
| | Paste commands on the one toolbar.Rule #4
|
| the Standard Toolbars or MenusCustomising
| |
| | - When Adding Macros To Your Toolbar, Do
|
| of your Toolbars must be done whilst you
| |
| | Not Use the Default Pictures for Icons,
|
| are working in the full version of
| |
| | Use TextTo add a macro to your toolbar,
|
| Microsoft Access and the first step in
| |
| | you simply choose the All Macro category
|
| doing this is to open the Customize
| |
| | and then in the Commands list box it will
|
| dialog box. To do this we first goto the
| |
| | show you your macros. You can then simply
|
| Tools menu and choose Customize from the
| |
| | drag the macro onto your toolbar. Now
|
| drop down menu. The dialog box will now
| |
| | when you do that by default the macro
|
| appear. By having the Customize dialog
| |
| | will be shown as a combination of Text
|
| box open, you now have the ability to
| |
| | and the little Macro symbol. What I
|
| modify any toolbar which includes all the
| |
| | recommend to all my students is to remove
|
| standard ones such as the Database
| |
| | the Macro symbol and stick to text. The
|
| toolbar, Formatting toolbar, Forms
| |
| | reason is that users will become confused
|
| toolbar etc. However my advice to all of
| |
| | if you use symbols they associate with
|
| my students has always been to leave the
| |
| | another function.For example, if you said
|
| standard toolbar set alone, always create
| |
| | to a user, what is the symbol for Cut
|
| your own toolbars which is what we will
| |
| | they would immediately tell you the
|
| focus on. If you customise the standard
| |
| | Scissors. If you used the Scissors to do
|
| Microsoft Access toolbars what will
| |
| | anything else but to Cut, you would have
|
| happen is that in the future you will not
| |
| | a very confused user so I recommend
|
| necessarily be able to use the toolbars
| |
| | sticking with text only. To set your
|
| as you may have removed some of the
| |
| | toolbar icon to show as text only, simply
|
| buttons on the toolbars and this just
| |
| | right mouse click over the toolbar icon
|
| means more work for you.Rule #2 - Give
| |
| | and choose Text Only(Always) from the
|
| Your Toolbars a Name That Will Means
| |
| | shortcut menu and this will ensure that
|
| Something to the UsersIf we are not going
| |
| | the user will only ever see the text
|
| to modify a standard toolbar or menu,
| |
| | name.Rule #5 -Always Use Names That Make
|
| then we have to create one from scratch
| |
| | Sense and are User IntuitiveWhen you are
|
| and to do that you must first change to
| |
| | naming your macros always ensure that you
|
| the Toolbars tab. On the right hand side
| |
| | use names that make sense and actually
|
| of the list of toolbars you will notice
| |
| | mean something to the user. For example
|
| the New button. You simply click on the
| |
| | if your Macro Opens a Report, then use
|
| New button to create a blank toolbar but
| |
| | the Report Name as the text on the
|
| first you will be asked to give the
| |
| | toolbar do not simply type Open Report,
|
| Toolbar a name. This is the name you will
| |
| | as the user will never know what report
|
| see in the Title bar of the toolbar when
| |
| | you are referring to.The one issue I
|
| it is in Floating Mode. Try to keep the
| |
| | impress upon all of my students is this;
|
| names as logical as possible so that your
| |
| | when you are developing User Interfaces,
|
| users will understand what the toolbar is
| |
| | remember all the complaints you had about
|
| supposed to do.Now that you have given
| |
| | the software you were given and ensure
|
| the toolbar a name you simply press the
| |
| | you do not make the same mistakes with
|
| OK button and you will see the toolbar
| |
| | your user. Remember, users do
|
| appear. What you will notice is that the
| |
| | complain!Finally, once you have added all
|
| toolbar by default does not contain any
| |
| | the buttons to your toolbar and
|
| buttons at all. The next step is to put
| |
| | customised it as you require, simply
|
| the command functions onto the toolbar
| |
| | press the OK button on the Customize
|
| and we do this by choosing the Commands
| |
| | dialog box and your toolbar will now be
|
| tab. This tab contains all the functions
| |
| | ready for use.To finish off, always
|
| and commands for every menu item, toolbar
| |
| | remember the following five rules when
|
| item and macros in the database. That is
| |
| | developing a toolbar for use by your
|
| right, when you create a macro, the macro
| |
| | customers -Rule #1 - Never customise the
|
| is available to be used on a toolbar or
| |
| | Standard Toolbars or MenusRule #2 - Give
|
| menu.The Commands tab is broken into two
| |
| | Your Toolbars a Name That Means Something
|
| list boxes the Categories list box and
| |
| | to the UsersRule #3 - Try To Group
|
| the Commands list box. The categories
| |
| | Similar Commands On Your Custom
|
| list box, has individual categories that
| |
| | ToolbarRule #4 - When Adding Macros To
|
| represent elements in your database like
| |
| | Your Toolbar, Do Not Use the Default
|
| the File menu, Edit menu etc as well as
| |
| | Pictures for Icons, Use TextRule #5
|
| other commands for Forms, Tables, Querys,
| |
| | -Always Use Names That Make Sense and are
|
| Macros and Reports. The Macro's category
| |
| | User IntuitiveChris Le Roy has developed
|
| allows you to access your own customised
| |
| | a number of Microsoft Office Tutorials
|
| macros.To add a command from a category
| |
| | including a Microsoft Access Training
|
| you must first select a category, lets
| |
| | Advanced Program, Microsoft Excel
|
| say for instance the Edit category. You
| |
| | Tutorial and a Microsoft Word Tutorial.
|
