how?

[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

 

[Ken Snell [MVP]]

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

 

[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

 

[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

 

[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).

 

[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?

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

 

[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>

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

 

[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.

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>

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

 

[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>

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.

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>

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