form wizard

[Dick7Access]

Access 2010 I have been searching the net for days and cannot find my answer. How do you turn on the wizard? I want to add some combo boxes and list box with a wizard. Any help will be appreciated.

 

[missinglinq]

Don't run 2010, but in version 2003 and earlier, in Form Design View, there's a Wizards Icon that looks like a Wizard's Wand with stars falling from the tip. Clicking on it turns the Wizards on and off, and users do accidentally click on it, turning the Wizards off, which can be agravating.

Linq ;0)>

 

[Dick7Access]

Thanks for trying to help Ling, but I used 2003 for years and very familial with the wizard wand and all that but this new computer has 2010 and there is where I have to work with.

 

[vbaInet]

By performing one quick search on Google the second link provided this:

http://office.microsoft.com/en-us/a...orm-by-using-the-form-wizard-HA010341568.aspx

 

[Dick7Access]

Thanks for the help VBAnet. I guess I need to learn to search better. I goggled it every way I could think of and never pulled up that tutorial. However when I did more forms, I did not have a selection “form wizard”. Sometimes I think I am too old for this stuff.

 

[vbaInet]

The search term was "form wizard in access 2010"

Are other wizards like the Query and Report wizard available?

 

[Dick7Access]

Hi again VBAnet,
I think I have to stop thinking 2003 if I am ever going to learn 2010. However, Microsoft doesn’t help things much either. When I followed the instructions below there was no form wizard on the list of “more forms”. After you asked me if there was a report wizard and query wizard I noticed that there is a form wizard listed right above more forms, so the tutorial below is a bit erroneous. The reason I did not notice them before is that I was not in that view. I already had a form and I was in design view trying to add a list box. I could past a list box ok but it was unbound and it did not have a wizard like 2003 that gave me an option to select that table to populate the list box. The app that I was making for my wife to track her cooking urls I was able to make on my old computer with the list box wizard in 2003 with no problem. The old computer died on me twice and I had to start over that is why I have a new puter. One I made the app in 2003 and put it on the new puter and saved it in the 2010 format it works fine, but I need to lerarn 2010.
Access provides several quick-create form tools on the Create tab, each of which lets you create a form with a single click. However, if you want to be more selective about what fields appear on the form, you can use the Form Wizard instead. The wizard also lets you define how the data is grouped and sorted, and you can use fields from more than one table or query (provided that you specified the relationships between the tables and queries beforehand).
Start the Form Wizard
1. On the Create tab, in the Forms group, click More Forms, and then click Form Wizard.
2. Follow the directions on the pages of the Form Wizard.
Note If you want to include fields from multiple tables and queries on the form, do not click Next or Finish after you select the fields from the first table or query on the first page of the Form Wizard. Instead, repeat the steps to select a table or query, and then click any additional fields that you want to include on the form. Then click Next or Finish to continue.
3. On the last page of the wizard, click Finish.

 

[Dick7Access]

ps to all,
I still can't get a list box wizard in 2010. Any help would be appreciated.

 

[vbaInet]

So when you drop a listbox onto the form what happens? You sometimes need to wait a few seconds for the wizard to start up.

 

[Dick7Access]

Nothing happens. Just sits there. I suppose there is a way to populate it with VBA I am not into that yet. I would think Big Bill G. would have left a wizard in 2010.

 

[Dick7Access]

Ok gang I found it. In design view, on the ribbon there is a small scroll bar to the right of the selection of items such as button, labels, LIST BOX etc. By clicking the down arrow it opens a drop down menu with 1. Set control defaults, 2. Use control wizard, 3. Active X controls. Maybe I have contributed instead of always taking. Just goes to show, however, the poor documentation from Microsoft. Even the book I bought did not cover this item.

 

[Vancer]

Thank you, Dick7.
Your response was succinct and saved me a lot of time.
Vancer