Results 1 to 5 of 5
  1. #1
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171

    Inserting a button

    I am learning/running Access 2010. I have been following some videos on YouTube that have helped me learn the program along with some great input from this forum. Now I am a the point where I would like to add some buttons to my form.



    I open the form in design view as instructed. In design, I click on the rectangle with the XXXX inside which I am told is the button I need to put in my form. I take it to my form, click and the button appears. However, on YouTube, a "Command Button Wizard" box opens when this is done, but on my form I just get the box with a command number in it. Why am I not getting the Wizard?

    BTW, I am trying to create a button that will open a form that users can have to find information in my existing database. I am guessing that might not be as simple as I think. If anyone can direct me to "creating interactive forms for users in Access for dummies" that would be great. Thank you.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    There is an icon on the ribbon that looks like a magic wand that controls wizards. Make sure it's selected.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    the query for your new form could reference a listbox on the form.

    for example listbox could be named anything but lets call it "LSTclient" and it shows all the clients. (importantly this would have to be in the forms header).

    in your query where you are showing the client name. the criteria for this would be =forms!FormName!LSTclient. FormName is the name of your form. Also have the query refresh on the update event of the listbox.

    If I've helped. Great. If not, ask away.

  4. #4
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171
    Quote Originally Posted by pbaldy View Post
    There is an icon on the ribbon that looks like a magic wand that controls wizards. Make sure it's selected.
    Would this be in Form Design Tools-Design? Don't see it. BTW I have Access 2010 if that makes a difference.

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It's kind of hidden in 2010. On the design tab in the controls section, there's a "More" dropdown at the right side of the section to select a control. It's in there, says "Use Control Wizards".
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. VBA Inserting two new records
    By lzook88 in forum Programming
    Replies: 2
    Last Post: 10-11-2015, 10:52 AM
  2. Replies: 3
    Last Post: 02-11-2015, 05:41 PM
  3. Replies: 6
    Last Post: 12-27-2010, 10:26 PM
  4. inserting .wav sound?
    By dada in forum Programming
    Replies: 2
    Last Post: 08-20-2010, 11:25 PM
  5. Inserting/Updating
    By detlion1643 in forum Access
    Replies: 1
    Last Post: 02-26-2010, 07:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums