Microsoft Access 2007 Update fields

Does the Dept# table have the "other two" fields data for the form?

Thel wrote:
How do I tell access it is a combo box on the form? All of the information
is coming from the employee table except these three fields. If I use a
combo box can the user put in the dept# and update the other two fields?

I would suggest reading up on why using look-up fields in tables causes
problem. Eliminate them and use a table/combo box on a form.
[quoted text clipped - 31 lines]
Any help would be greatly appericated.
Thelma

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200902/1

Thel,

I think you need to specify your table layouts. There might be an issue
there as to why these fields are not updating properly.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
How do I tell access it is a combo box on the form? All of the
information
is coming from the employee table except these three fields. If I use a
combo box can the user put in the dept# and update the other two fields?

"Gina Whipp" wrote:

I would suggest reading up on why using look-up fields in tables causes
problem. Eliminate them and use a table/combo box on a form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
on the form I type in the dept number and it fills in the desc &
glcode,
when
you look at the table it has updated the dept number but not the other
two
fields.
I am using access 2007.
I am not getting any messages.

"Gina Whipp" wrote:

Thel,

I am trying to understand this...

You have three fields you wish to update to a table but presently only
one
is updating. IF that is what you are saying then we need to know how
you
you are updating the three fields. Are you just typing the
information
in
but it's not appearing in the table? Are you using a query to update
the
table and the query is not performing it's job. Or maybe the fields
as
combo boxes and the field is not accepting the selections from the
combo
box? Of,course you should get some sort of message unless you turned
those
off??? Or maybe it's the RecordSOurce of the form, when you go to
design
mode of the form does the word 'unbound' show in two of the three
fields?

It would also help to know what version of Access?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
I am using a form to update a table. I have 3 update fields in a
table.
When I do the lookup all three fields show on the form but only one
updates.
How do I get the other two fields to update?
Any help would be greatly appericated.
Thelma

The Dept table has all three fields. When entering data on the form the user
wants to type in the dept# and have the other to fields field in automaticly.
Thanks,

"ruralguy via AccessMonster.com" wrote:

Does the Dept# table have the "other two" fields data for the form?

Thel wrote:
How do I tell access it is a combo box on the form? All of the information
is coming from the employee table except these three fields. If I use a
combo box can the user put in the dept# and update the other two fields?

I would suggest reading up on why using look-up fields in tables causes
problem. Eliminate them and use a table/combo box on a form.
[quoted text clipped - 31 lines]
Any help would be greatly appericated.
Thelma

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200902/1

My Table layout for Employee is dept desc employee name (key field) address,
city, state zip, status, phone number, wage, ssn, GLcode.
The layout of the Dept# is dept# Desc, GLCODE
Thanks

"Gina Whipp" wrote:

Thel,

I think you need to specify your table layouts. There might be an issue
there as to why these fields are not updating properly.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
How do I tell access it is a combo box on the form? All of the
information
is coming from the employee table except these three fields. If I use a
combo box can the user put in the dept# and update the other two fields?

"Gina Whipp" wrote:

I would suggest reading up on why using look-up fields in tables causes
problem. Eliminate them and use a table/combo box on a form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
on the form I type in the dept number and it fills in the desc &
glcode,
when
you look at the table it has updated the dept number but not the other
two
fields.
I am using access 2007.
I am not getting any messages.

"Gina Whipp" wrote:

Thel,

I am trying to understand this...

You have three fields you wish to update to a table but presently only
one
is updating. IF that is what you are saying then we need to know how
you
you are updating the three fields. Are you just typing the
information
in
but it's not appearing in the table? Are you using a query to update
the
table and the query is not performing it's job. Or maybe the fields
as
combo boxes and the field is not accepting the selections from the
combo
box? Of,course you should get some sort of message unless you turned
those
off??? Or maybe it's the RecordSOurce of the form, when you go to
design
mode of the form does the word 'unbound' show in two of the three
fields?

It would also help to know what version of Access?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
I am using a form to update a table. I have 3 update fields in a
table.
When I do the lookup all three fields show on the form but only one
updates.
How do I get the other two fields to update?
Any help would be greatly appericated.
Thelma

You need to create a query that joins the two tables on the Dept# field and
includes all of the fields you need from either table.

Thel wrote:
The Dept table has all three fields. When entering data on the form the user
wants to type in the dept# and have the other to fields field in automaticly.
Thanks,

Does the Dept# table have the "other two" fields data for the form?

[quoted text clipped - 7 lines]
Any help would be greatly appericated.
Thelma

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200902/1

Thel,

First, yhou do not need to store GLCODE and Dept Desc in both tables unless
you are alowwing changes to those fields independent from the Department
Table. What you do need in the Emplyee table id Dept#. Then create a query
that joins the two tables together via Dept# and that will help those field
show but you REALLY don't need to or want to store duplicate information.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
My Table layout for Employee is dept desc employee name (key field)
address,
city, state zip, status, phone number, wage, ssn, GLcode.
The layout of the Dept# is dept# Desc, GLCODE
Thanks

"Gina Whipp" wrote:

Thel,

I think you need to specify your table layouts. There might be an issue
there as to why these fields are not updating properly.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
How do I tell access it is a combo box on the form? All of the
information
is coming from the employee table except these three fields. If I use
a
combo box can the user put in the dept# and update the other two
fields?

"Gina Whipp" wrote:

I would suggest reading up on why using look-up fields in tables
causes
problem. Eliminate them and use a table/combo box on a form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
on the form I type in the dept number and it fills in the desc &
glcode,
when
you look at the table it has updated the dept number but not the
other
two
fields.
I am using access 2007.
I am not getting any messages.

"Gina Whipp" wrote:

Thel,

I am trying to understand this...

You have three fields you wish to update to a table but presently
only
one
is updating. IF that is what you are saying then we need to know
how
you
you are updating the three fields. Are you just typing the
information
in
but it's not appearing in the table? Are you using a query to
update
the
table and the query is not performing it's job. Or maybe the
fields
as
combo boxes and the field is not accepting the selections from the
combo
box? Of,course you should get some sort of message unless you
turned
those
off??? Or maybe it's the RecordSOurce of the form, when you go to
design
mode of the form does the word 'unbound' show in two of the three
fields?

It would also help to know what version of Access?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
I am using a form to update a table. I have 3 update fields in a
table.
When I do the lookup all three fields show on the form but only
one
updates.
How do I get the other two fields to update?
Any help would be greatly appericated.
Thelma

It is wise to name like fields the same in different tables. It is not wise
to use the "#" sign in a field name. Are the two Dept fields the same
DataType?

Thel wrote:
My Table layout for Employee is dept desc employee name (key field) address,
city, state zip, status, phone number, wage, ssn, GLcode.
The layout of the Dept# is dept# Desc, GLCODE
Thanks

Thel,

[quoted text clipped - 51 lines]
Any help would be greatly appericated.
Thelma

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200902/1

The name are the same in both tables. The dept table is for inputing
information,
the user does not want to lookup the data she needs to put in.
if she knows the dept nbr she wants it to put desc and glcode that match
that dept.
The coorsponding field are all of the same data type.

"ruralguy via AccessMonster.com" wrote:

It is wise to name like fields the same in different tables. It is not wise
to use the "#" sign in a field name. Are the two Dept fields the same
DataType?

Thel wrote:
My Table layout for Employee is dept desc employee name (key field) address,
city, state zip, status, phone number, wage, ssn, GLcode.
The layout of the Dept# is dept# Desc, GLCODE
Thanks

Thel,

[quoted text clipped - 51 lines]
Any help would be greatly appericated.
Thelma

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200902/1

dept, desc and glcode are in both tables with the same name and data type.
The user want to be able to put in the dept and access fill in the desc and
glcode on the input form.

"Gina Whipp" wrote:

Thel,

First, yhou do not need to store GLCODE and Dept Desc in both tables unless
you are alowwing changes to those fields independent from the Department
Table. What you do need in the Emplyee table id Dept#. Then create a query
that joins the two tables together via Dept# and that will help those field
show but you REALLY don't need to or want to store duplicate information.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
My Table layout for Employee is dept desc employee name (key field)
address,
city, state zip, status, phone number, wage, ssn, GLcode.
The layout of the Dept# is dept# Desc, GLCODE
Thanks

"Gina Whipp" wrote:

Thel,

I think you need to specify your table layouts. There might be an issue
there as to why these fields are not updating properly.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
How do I tell access it is a combo box on the form? All of the
information
is coming from the employee table except these three fields. If I use
a
combo box can the user put in the dept# and update the other two
fields?

"Gina Whipp" wrote:

I would suggest reading up on why using look-up fields in tables
causes
problem. Eliminate them and use a table/combo box on a form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
on the form I type in the dept number and it fills in the desc &
glcode,
when
you look at the table it has updated the dept number but not the
other
two
fields.
I am using access 2007.
I am not getting any messages.

"Gina Whipp" wrote:

Thel,

I am trying to understand this...

You have three fields you wish to update to a table but presently
only
one
is updating. IF that is what you are saying then we need to know
how
you
you are updating the three fields. Are you just typing the
information
in
but it's not appearing in the table? Are you using a query to
update
the
table and the query is not performing it's job. Or maybe the
fields
as
combo boxes and the field is not accepting the selections from the
combo
box? Of,course you should get some sort of message unless you
turned
those
off??? Or maybe it's the RecordSOurce of the form, when you go to
design
mode of the form does the word 'unbound' show in two of the three
fields?

It would also help to know what version of Access?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
I am using a form to update a table. I have 3 update fields in a
table.
When I do the lookup all three fields show on the form but only
one
updates.
How do I get the other two fields to update?
Any help would be greatly appericated.
Thelma

Thel,

Those can APPEAR but not be STORED in the table. Storing the same data in
two places defeats the purpose of normalization. The User will SEE the data
and that's all the User really wants to do. They will not have to type
anything into any extra fields.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
dept, desc and glcode are in both tables with the same name and data type.
The user want to be able to put in the dept and access fill in the desc
and
glcode on the input form.

"Gina Whipp" wrote:

Thel,

First, yhou do not need to store GLCODE and Dept Desc in both tables
unless
you are alowwing changes to those fields independent from the Department
Table. What you do need in the Emplyee table id Dept#. Then create a
query
that joins the two tables together via Dept# and that will help those
field
show but you REALLY don't need to or want to store duplicate information.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
My Table layout for Employee is dept desc employee name (key field)
address,
city, state zip, status, phone number, wage, ssn, GLcode.
The layout of the Dept# is dept# Desc, GLCODE
Thanks

"Gina Whipp" wrote:

Thel,

I think you need to specify your table layouts. There might be an
issue
there as to why these fields are not updating properly.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
How do I tell access it is a combo box on the form? All of the
information
is coming from the employee table except these three fields. If I
use
a
combo box can the user put in the dept# and update the other two
fields?

"Gina Whipp" wrote:

I would suggest reading up on why using look-up fields in tables
causes
problem. Eliminate them and use a table/combo box on a form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
on the form I type in the dept number and it fills in the desc &
glcode,
when
you look at the table it has updated the dept number but not the
other
two
fields.
I am using access 2007.
I am not getting any messages.

"Gina Whipp" wrote:

Thel,

I am trying to understand this...

You have three fields you wish to update to a table but
presently
only
one
is updating. IF that is what you are saying then we need to
know
how
you
you are updating the three fields. Are you just typing the
information
in
but it's not appearing in the table? Are you using a query to
update
the
table and the query is not performing it's job. Or maybe the
fields
as
combo boxes and the field is not accepting the selections from
the
combo
box? Of,course you should get some sort of message unless you
turned
those
off??? Or maybe it's the RecordSOurce of the form, when you go
to
design
mode of the form does the word 'unbound' show in two of the
three
fields?

It would also help to know what version of Access?

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Thel" wrote in message
...
I am using a form to update a table. I have 3 update fields in
a
table.
When I do the lookup all three fields show on the form but
only
one
updates.
How do I get the other two fields to update?
Any help would be greatly appericated.
Thelma