Combo box wizard not wking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using access and am on my form in design view, I want to add a combo box
to my form but as I add it the combo box wizard does not come up....why?
After adding the combo box to the form it is say unbound inside???? The
combo box wizard works when I try to add it to my table, however that is not
where I want it. I need it in my form for data entry. In trying to figure
it out by selecting variouse things from the tool bar I once did get a
message saying something about the look up wizard not working due to a syntax
error or it may be missing from some sort of list. I am afraid I did not
read it carefully. Can anyone shed some light on why the wizard is not
working or if there is a way I can fill the box without going through the
wizard. If I right click the the mouse a menu comes up that gives you the
option to "build event"??? the "build" option that looks like the wizard
button but has a ...underit on this menu is unavailable although it is on on
the main tool bar. If I press build it then gives me the option of choosing
"expression Builder", Macro Builder" or Code Builder" , is there something I
can do with that??? Is there something I should be adding or settting in the
"Properties" window. Please Help...TY Veronica.
 
I am using access and am on my form in design view, I want to add a combo box
to my form but as I add it the combo box wizard does not come up....why?
After adding the combo box to the form it is say unbound inside???? The
combo box wizard works when I try to add it to my table, however that is not
where I want it. I need it in my form for data entry. In trying to figure
it out by selecting variouse things from the tool bar I once did get a
message saying something about the look up wizard not working due to a syntax
error or it may be missing from some sort of list. I am afraid I did not
read it carefully. Can anyone shed some light on why the wizard is not
working or if there is a way I can fill the box without going through the
wizard. If I right click the the mouse a menu comes up that gives you the
option to "build event"??? the "build" option that looks like the wizard
button but has a ...underit on this menu is unavailable although it is on on
the main tool bar. If I press build it then gives me the option of choosing
"expression Builder", Macro Builder" or Code Builder" , is there something I
can do with that??? Is there something I should be adding or settting in the
"Properties" window. Please Help...TY Veronica.
Click to expand...

Some one turned the wizard off.
Open the tool box.
Click on the wizard button (the wand with the stars).
The wizard should work now.

You really don't need the wizard to create a combo box.
After adding the combo box to your form (without the wizard), set the
Row Source property to a query, table, or SQL expression.
Then set the combo column count to whatever is required for your
purposes, and the column widths as needed.
For example, if you have a 3 column combo box, with the first column
the bound column, i.e. [ClientID], [LastName], [FirstName], and you
wish to display only the second and third columns, set the bound
column to 1, the Column count to 3, and the column widths to 0";1";1"
 
Thank you Fred,

OK...I think we are getting close but not quite there yet. Perhaps if I
give you a better example of what I need in the combo box you can better
direct me. In one of the combo boxes I simply need the drop down to give me
the option of salutation (Mr. or Ms.) In some of the others I may need the
option to choose from 4-5 different possibilities but the concept is the
same. I only need one column for each combo box????

When I tryed to follow your instructions...opened properties: Control source
was blank (typed in salutation because that is the title of the column on the
table) it filled in on the form what was already on the table.

Row souce type was set at Table/Query, bound column = 1
this gave me a drop down box with information from the table.

I need to choose a value while data entering on the form which will
auto-magically fill in my database table. I hope the example above is better
explained.

And the wzard is turned on. My understanding was that as I drop the combo
box on the form the wizard automatically comes on. When I drop it nothing
happens???? Your time and additional help is greatly appreciated.

fredg said:
I am using access and am on my form in design view, I want to add a combo box
to my form but as I add it the combo box wizard does not come up....why?
After adding the combo box to the form it is say unbound inside???? The
combo box wizard works when I try to add it to my table, however that is not
where I want it. I need it in my form for data entry. In trying to figure
it out by selecting variouse things from the tool bar I once did get a
message saying something about the look up wizard not working due to a syntax
error or it may be missing from some sort of list. I am afraid I did not
read it carefully. Can anyone shed some light on why the wizard is not
working or if there is a way I can fill the box without going through the
wizard. If I right click the the mouse a menu comes up that gives you the
option to "build event"??? the "build" option that looks like the wizard
button but has a ...underit on this menu is unavailable although it is on on
the main tool bar. If I press build it then gives me the option of choosing
"expression Builder", Macro Builder" or Code Builder" , is there something I
can do with that??? Is there something I should be adding or settting in the
"Properties" window. Please Help...TY Veronica.
Click to expand...

Some one turned the wizard off.
Open the tool box.
Click on the wizard button (the wand with the stars).
The wizard should work now.

You really don't need the wizard to create a combo box.
After adding the combo box to your form (without the wizard), set the
Row Source property to a query, table, or SQL expression.
Then set the combo column count to whatever is required for your
purposes, and the column widths as needed.
For example, if you have a 3 column combo box, with the first column
the bound column, i.e. [ClientID], [LastName], [FirstName], and you
wish to display only the second and third columns, set the bound
column to 1, the Column count to 3, and the column widths to 0";1";1"
Click to expand...
 
Thank you Fred,

OK...I think we are getting close but not quite there yet. Perhaps if I
give you a better example of what I need in the combo box you can better
direct me. In one of the combo boxes I simply need the drop down to give me
the option of salutation (Mr. or Ms.) In some of the others I may need the
option to choose from 4-5 different possibilities but the concept is the
same. I only need one column for each combo box????

When I tryed to follow your instructions...opened properties: Control source
was blank (typed in salutation because that is the title of the column on the
table) it filled in on the form what was already on the table.

Row souce type was set at Table/Query, bound column = 1
this gave me a drop down box with information from the table.

I need to choose a value while data entering on the form which will
auto-magically fill in my database table. I hope the example above is better
explained.

And the wzard is turned on. My understanding was that as I drop the combo
box on the form the wizard automatically comes on. When I drop it nothing
happens???? Your time and additional help is greatly appreciated.

fredg said:
I am using access and am on my form in design view, I want to add a combo box
to my form but as I add it the combo box wizard does not come up....why?
After adding the combo box to the form it is say unbound inside???? The
combo box wizard works when I try to add it to my table, however that is not
where I want it. I need it in my form for data entry. In trying to figure
it out by selecting variouse things from the tool bar I once did get a
message saying something about the look up wizard not working due to a syntax
error or it may be missing from some sort of list. I am afraid I did not
read it carefully. Can anyone shed some light on why the wizard is not
working or if there is a way I can fill the box without going through the
wizard. If I right click the the mouse a menu comes up that gives you the
option to "build event"??? the "build" option that looks like the wizard
button but has a ...underit on this menu is unavailable although it is on on
the main tool bar. If I press build it then gives me the option of choosing
"expression Builder", Macro Builder" or Code Builder" , is there something I
can do with that??? Is there something I should be adding or settting in the
"Properties" window. Please Help...TY Veronica.
Click to expand...

Some one turned the wizard off.
Open the tool box.
Click on the wizard button (the wand with the stars).
The wizard should work now.

You really don't need the wizard to create a combo box.
After adding the combo box to your form (without the wizard), set the
Row Source property to a query, table, or SQL expression.
Then set the combo column count to whatever is required for your
purposes, and the column widths as needed.
For example, if you have a 3 column combo box, with the first column
the bound column, i.e. [ClientID], [LastName], [FirstName], and you
wish to display only the second and third columns, set the bound
column to 1, the Column count to 3, and the column widths to 0";1";1"
Click to expand...
Click to expand...

A combo box has 3 different ways to get/show information; through a
Value List, a Field List, or a Table/Query.

You first have to decide what the information is going to be.
If you want a combo box to show just "Mr." or Ms." then you should set
the combo box's Row Source Type property to Value List.
Then, in the Rowsource property type
"Mr.","Ms."
Set the Bound column to 1.
Set the Column Count to 1.
Set the column widths to 0.75" (or whatever width you want).
Set the control source to [Salutation], or whatever field in the table
the form is bound to.

For the other combo boxes, if the values are limited to a fixed set,
such as above, you would do it the same way, just entering the
different values in the Row Source.

My original reply gave instructions on setting the row source to a
Table/Query which, in your example above, is not needed.

HOWEVER ... If in the future you wish to permit the user to add
additional values, such as a new City in a City list, it would be best
to have a table with the cities, and use a query (create a query from
the table) as Rowsource of the combo box. This way the user (with
additional coding supplied by you) can add a new city to the list
without having to modify the database.

Have fun.
 
Gosh, I am totally speachless....it worked. I cannot thank you enough!!!!!!:)

Now, any other input on the thread right above or below??? Re: Access form
and MS Word Doc.

fredg said:
Thank you Fred,

OK...I think we are getting close but not quite there yet. Perhaps if I
give you a better example of what I need in the combo box you can better
direct me. In one of the combo boxes I simply need the drop down to give me
the option of salutation (Mr. or Ms.) In some of the others I may need the
option to choose from 4-5 different possibilities but the concept is the
same. I only need one column for each combo box????

When I tryed to follow your instructions...opened properties: Control source
was blank (typed in salutation because that is the title of the column on the
table) it filled in on the form what was already on the table.

Row souce type was set at Table/Query, bound column = 1
this gave me a drop down box with information from the table.

I need to choose a value while data entering on the form which will
auto-magically fill in my database table. I hope the example above is better
explained.

And the wzard is turned on. My understanding was that as I drop the combo
box on the form the wizard automatically comes on. When I drop it nothing
happens???? Your time and additional help is greatly appreciated.

fredg said:
On Thu, 10 Feb 2005 09:11:04 -0800, Veronica wrote:

I am using access and am on my form in design view, I want to add a combo box
to my form but as I add it the combo box wizard does not come up....why?
After adding the combo box to the form it is say unbound inside???? The
combo box wizard works when I try to add it to my table, however that is not
where I want it. I need it in my form for data entry. In trying to figure
it out by selecting variouse things from the tool bar I once did get a
message saying something about the look up wizard not working due to a syntax
error or it may be missing from some sort of list. I am afraid I did not
read it carefully. Can anyone shed some light on why the wizard is not
working or if there is a way I can fill the box without going through the
wizard. If I right click the the mouse a menu comes up that gives you the
option to "build event"??? the "build" option that looks like the wizard
button but has a ...underit on this menu is unavailable although it is on on
the main tool bar. If I press build it then gives me the option of choosing
"expression Builder", Macro Builder" or Code Builder" , is there something I
can do with that??? Is there something I should be adding or settting in the
"Properties" window. Please Help...TY Veronica.

Some one turned the wizard off.
Open the tool box.
Click on the wizard button (the wand with the stars).
The wizard should work now.

You really don't need the wizard to create a combo box.
After adding the combo box to your form (without the wizard), set the
Row Source property to a query, table, or SQL expression.
Then set the combo column count to whatever is required for your
purposes, and the column widths as needed.
For example, if you have a 3 column combo box, with the first column
the bound column, i.e. [ClientID], [LastName], [FirstName], and you
wish to display only the second and third columns, set the bound
column to 1, the Column count to 3, and the column widths to 0";1";1"
Click to expand...
Click to expand...

A combo box has 3 different ways to get/show information; through a
Value List, a Field List, or a Table/Query.

You first have to decide what the information is going to be.
If you want a combo box to show just "Mr." or Ms." then you should set
the combo box's Row Source Type property to Value List.
Then, in the Rowsource property type
"Mr.","Ms."
Set the Bound column to 1.
Set the Column Count to 1.
Set the column widths to 0.75" (or whatever width you want).
Set the control source to [Salutation], or whatever field in the table
the form is bound to.

For the other combo boxes, if the values are limited to a fixed set,
such as above, you would do it the same way, just entering the
different values in the Row Source.

My original reply gave instructions on setting the row source to a
Table/Query which, in your example above, is not needed.

HOWEVER ... If in the future you wish to permit the user to add
additional values, such as a new City in a City list, it would be best
to have a table with the cities, and use a query (create a query from
the table) as Rowsource of the combo box. This way the user (with
additional coding supplied by you) can add a new city to the list
without having to modify the database.

Have fun.
Click to expand...
 
Back
Top