Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Adding a button in Access 2007

Jul 2, 2010 12:36PM PDT

Please help! I am trying to add a button to open a msgbox. I have the msgbox set up - no prob. the instructions to set up the button says, "On the Design tab, in the Controls group, ensure that Use Control Wizards is selected." I had to customize the Quick Access toolbar and added "controls". However, when I click on the "controls" button and the "controls group" drops down I cannot click on the "Use Controls Wizards" button. It is not even highlighted when I pass the cursor over it. I am not very computer literate and I am learning as I go. I really think that I could get this thingy to work but feel I am doing something wrong.

Discussion is locked

- Collapse -
Re: adding a button
Jul 2, 2010 11:00PM PDT

Adding a button to what?

And, just out of interest, how do you "setup" a msgbox? For me, it's just using a VBA-command to open it.

And where are these instructions? If somewhere on the web, please post the link.

Kees

- Collapse -
Duh!
Jul 3, 2010 6:47AM PDT

As I said, I am not very computer literate. You are speaking Greek to me. I have no idea what a VBA command is. Never heard of it.

I am trying to add a button to a database in Access 2007. Hopefully it will open a msgbox (their abbreviation). I set up the msgbox with the "create msgbox" option in Access 2007. The instructions are in "help" in Access 2007 titled "adding a button to a form". I would use the "Controls Wizard" but it is not available to click in the "Create" tab.

This is not a life or death thing. It is only to make the database more user friendly.

- Collapse -
addendum
Jul 3, 2010 6:51AM PDT

Sorry, not "Create" tab but "Design" tab. I did not have the info in front of me at the time and was trying to use my less than adequate memory.

- Collapse -
Re: button
Jul 3, 2010 6:41PM PDT

So you want to add a button to a form in Access 2007 and when the user clicks it it should open a message box that says "Hello, thank you for clicking me." or so. That's the idea?

Two things are still unclear in what you did:
- You already setup the message box with the 'create msgbox' option. That's Greek to me. Please provide a link to a some instruction on the Internet about this.
- You customised the Quick Access toolbar. That shouldn't be necessary. In Design view for a form all options to add form controls (like label, a check box in image, a command button) should be present and draggable.

So you should be able to put the button on the form by dragging that control. That's the first step. If the 'Use Control Wizards' is selected, the wizard takes over and asks you the details for that control (that button in your case). If the wizard isn't selected, it doesn't pop up and you have to configure the button you created yourself by editing its properties. There's no magic involved.

The definition of a 'command button': A button that, when clicked, executes a macro or other set of instructions linked to the button. Your configuring the button means you:
(a) set the text and font and color etc
(b) set the 'click event', that's the name of the macro or the 'other set of instructions' (that's an event procedure, writting in a programming language called VBA) that should be executed when it's clicked. A macro suffices for you, probably.

http://office.microsoft.com/en-ca/access-help/create-or-modify-a-command-button-HP005187752.aspx tells more. It includes a possible explanation of the wizard not running, how to do what you want with the wizard and how to do it without it.

Hope this helps.


Kees

- Collapse -
Never mind!
Jul 4, 2010 9:18PM PDT

Obviously, you did not read my post completely!

- Collapse -
(NT) What did I miss?
Jul 5, 2010 5:49PM PDT