how?

A

antonov

hello everybody:
I have a table (Consignee) with contacts, their addresses, tel and fax
numbers and email addresses. Another table with the Consignee's contacts
(Consignee_contacts).
I have a form (Operations) in which I can input some data. Now the problem:
Is it possible to make the address and all the other data appear in my text
boxes if the name of the consignee is already in the table?
If the name is not in the table is it possible to save it after input?
thanks
 
A

antonov

yes, it should do what I am looking for but I cannot make it work. I've
added the field in the query but when I indicate the column in the control
source all I get is a blank textbox
 
A

antonov

Ok, problem solved... but...
is it possible to have the combobox show only column 2 of the table.... and
I need column 3 and 4 to be in the same textbox... I've tried with
"=cboConsignee.Column(2) & cboConsignee.Column(3)"
but it doesn't work
 
K

Ken Snell [MVP]

Use the ColumnWidths property of the combo box to set the "visibility" of
the columns. If you set a column's width to 0, it will not show in the
dropdown list.

The combo box will display the first visible column in its "textbox" after
you make a selection. If you want the combo box to show the column(2) (the
third column) in its "textbox", the first two columns must have a column
width of 0 each.

To have the third and fourth columns in a single textbox, you would use a
concatenated expression such as you've shown:
= [cboConsignee].[Column](2) & [cboConsignee].[Column](3)

The above will put the fourth column's value right after the third column's
value (no space or other delimiter between them).
 
A

antonov

Thanks Ken.. it works... but... how can I save the data? I mean... the
consignee is only a part of the form. Is there a possibility to save a form
(sending the data to a table) and recall the form content?

Ken Snell said:
Use the ColumnWidths property of the combo box to set the "visibility" of
the columns. If you set a column's width to 0, it will not show in the
dropdown list.

The combo box will display the first visible column in its "textbox" after
you make a selection. If you want the combo box to show the column(2)
(the third column) in its "textbox", the first two columns must have a
column width of 0 each.

To have the third and fourth columns in a single textbox, you would use a
concatenated expression such as you've shown:
= [cboConsignee].[Column](2) & [cboConsignee].[Column](3)

The above will put the fourth column's value right after the third
column's value (no space or other delimiter between them).

--

Ken Snell
<MS ACCESS MVP>

antonov said:
Ok, problem solved... but...
is it possible to have the combobox show only column 2 of the table....
and I need column 3 and 4 to be in the same textbox... I've tried with
"=cboConsignee.Column(2) & cboConsignee.Column(3)"
but it doesn't work
Click to expand...
Click to expand...
 
K

Ken Snell [MVP]

I'm not sure that I'm fully understanding you here, but a form that is bound
to a query or table usually can save the data to that table or to the tables
in the query if you have controls bound to the fields and you enter data
into them.

Can you be more specific about what you want to do here?

--

Ken Snell
<MS ACCESS MVP>

antonov said:
Thanks Ken.. it works... but... how can I save the data? I mean... the
consignee is only a part of the form. Is there a possibility to save a
form
(sending the data to a table) and recall the form content?

Ken Snell said:
Use the ColumnWidths property of the combo box to set the "visibility" of
the columns. If you set a column's width to 0, it will not show in the
dropdown list.

The combo box will display the first visible column in its "textbox"
after you make a selection. If you want the combo box to show the
column(2) (the third column) in its "textbox", the first two columns
must have a column width of 0 each.

To have the third and fourth columns in a single textbox, you would use a
concatenated expression such as you've shown:
= [cboConsignee].[Column](2) & [cboConsignee].[Column](3)

The above will put the fourth column's value right after the third
column's value (no space or other delimiter between them).

--

Ken Snell
<MS ACCESS MVP>

antonov said:
Ok, problem solved... but...
is it possible to have the combobox show only column 2 of the table....
and I need column 3 and 4 to be in the same textbox... I've tried with
"=cboConsignee.Column(2) & cboConsignee.Column(3)"
but it doesn't work
See this article at The ACCESS Web -- it may be similar to what you
want to do:
http://www.mvps.org/access/forms/frm0058.htm
--

Ken Snell
<MS ACCESS MVP>


hello everybody:
I have a table (Consignee) with contacts, their addresses, tel and fax
numbers and email addresses. Another table with the Consignee's
contacts
(Consignee_contacts).
I have a form (Operations) in which I can input some data. Now the
problem:
Is it possible to make the address and all the other data appear in my
text
boxes if the name of the consignee is already in the table?
If the name is not in the table is it possible to save it after input?
thanks
Click to expand...
Click to expand...
Click to expand...
 
A

antonov

ok: when I input the data thru the form I would like it to go to a table.
Now if I input the data only part of it goes into the table but the
consignee part remains out.
Ken Snell said:
I'm not sure that I'm fully understanding you here, but a form that is
bound to a query or table usually can save the data to that table or to
the tables in the query if you have controls bound to the fields and you
enter data into them.

Can you be more specific about what you want to do here?

--

Ken Snell
<MS ACCESS MVP>

antonov said:
Thanks Ken.. it works... but... how can I save the data? I mean... the
consignee is only a part of the form. Is there a possibility to save a
form
(sending the data to a table) and recall the form content?

Ken Snell said:
Use the ColumnWidths property of the combo box to set the "visibility"
of the columns. If you set a column's width to 0, it will not show in
the dropdown list.

The combo box will display the first visible column in its "textbox"
after you make a selection. If you want the combo box to show the
column(2) (the third column) in its "textbox", the first two columns
must have a column width of 0 each.

To have the third and fourth columns in a single textbox, you would use
a concatenated expression such as you've shown:
= [cboConsignee].[Column](2) & [cboConsignee].[Column](3)

The above will put the fourth column's value right after the third
column's value (no space or other delimiter between them).

--

Ken Snell
<MS ACCESS MVP>

Ok, problem solved... but...
is it possible to have the combobox show only column 2 of the table....
and I need column 3 and 4 to be in the same textbox... I've tried with
"=cboConsignee.Column(2) & cboConsignee.Column(3)"
but it doesn't work
See this article at The ACCESS Web -- it may be similar to what you
want to do:
http://www.mvps.org/access/forms/frm0058.htm
--

Ken Snell
<MS ACCESS MVP>


hello everybody:
I have a table (Consignee) with contacts, their addresses, tel and
fax
numbers and email addresses. Another table with the Consignee's
contacts
(Consignee_contacts).
I have a form (Operations) in which I can input some data. Now the
problem:
Is it possible to make the address and all the other data appear in
my text
boxes if the name of the consignee is already in the table?
If the name is not in the table is it possible to save it after
input?
thanks
Click to expand...
Click to expand...
Click to expand...
 
K

Ken Snell [MVP]

In the article whose link I'd provided earlier
(http://www.mvps.org/access/forms/frm0058.htm), there are two options for
how to make data appear in a textbox. The "Bound Textbox" option shows how
to do it when the textbox is bound to a field. In this situation, you want
the textbox that shows the consignee data to be bound to a field so that it
will store the value into the table; therefore, you'll need to use the
"Bound" option for doing this. It involves a small amount of VBA code, but
is pretty easy to set up.

--

Ken Snell
<MS ACCESS MVP>

antonov said:
ok: when I input the data thru the form I would like it to go to a table.
Now if I input the data only part of it goes into the table but the
consignee part remains out.
Ken Snell said:
I'm not sure that I'm fully understanding you here, but a form that is
bound to a query or table usually can save the data to that table or to
the tables in the query if you have controls bound to the fields and you
enter data into them.

Can you be more specific about what you want to do here?

--

Ken Snell
<MS ACCESS MVP>

antonov said:
Thanks Ken.. it works... but... how can I save the data? I mean... the
consignee is only a part of the form. Is there a possibility to save a
form
(sending the data to a table) and recall the form content?

Use the ColumnWidths property of the combo box to set the "visibility"
of the columns. If you set a column's width to 0, it will not show in
the dropdown list.

The combo box will display the first visible column in its "textbox"
after you make a selection. If you want the combo box to show the
column(2) (the third column) in its "textbox", the first two columns
must have a column width of 0 each.

To have the third and fourth columns in a single textbox, you would use
a concatenated expression such as you've shown:
= [cboConsignee].[Column](2) & [cboConsignee].[Column](3)

The above will put the fourth column's value right after the third
column's value (no space or other delimiter between them).

--

Ken Snell
<MS ACCESS MVP>

Ok, problem solved... but...
is it possible to have the combobox show only column 2 of the
table.... and I need column 3 and 4 to be in the same textbox... I've
tried with "=cboConsignee.Column(2) & cboConsignee.Column(3)"
but it doesn't work
See this article at The ACCESS Web -- it may be similar to what you
want to do:
http://www.mvps.org/access/forms/frm0058.htm
--

Ken Snell
<MS ACCESS MVP>


hello everybody:
I have a table (Consignee) with contacts, their addresses, tel and
fax
numbers and email addresses. Another table with the Consignee's
contacts
(Consignee_contacts).
I have a form (Operations) in which I can input some data. Now the
problem:
Is it possible to make the address and all the other data appear in
my text
boxes if the name of the consignee is already in the table?
If the name is not in the table is it possible to save it after
input?
thanks
Click to expand...
Click to expand...
Click to expand...
 
Top