Update query not working

[Guest]

I have an update query that's not updating correctly. I want to find a value
in the Temp table by asking the user for input then change that value based
on more input from the user. This is how my query is set up....
Field: TypeID TypeID
Table: Temp Temp
Update To: [TypeID] Like [Enter New
TypeID]
Criteria: Like [Enter Old TypeID]
or:

The Like [Enter Old TypeID] works to pull up the correct records. The
[TypeID] Like [Enter New TypeID] does prompt the user to enter a value but
the values in the table are updated to a zero value. Please help.

 

[[MVP] S.Clark]

I've never tried an Update Query with two parameters, but in theory it
should work. Just combine what you have into one column, instead of two,
and it might work.

 

[Guest]

Hi, Lorraine.

One may be vague in the selection criteria, but one should not be vague in
the value that will be assigned to the column in the update query. Instead
of using LIKE in the "Update To:" cell, set it to the value that the user
types in. For example, try:

Field: TypeID
Table: Temp
Update To: [Enter New TypeID]
Criteria: Like "*" & [Enter Old TypeID] & "*"

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

 

[Guest]

Come on now, do you really think that makes a difference? Not at all!
--
Lorraine

I've never tried an Update Query with two parameters, but in theory it
should work. Just combine what you have into one column, instead of two,
and it might work.


--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting

I have an update query that's not updating correctly. I want to find a
value
in the Temp table by asking the user for input then change that value
based
on more input from the user. This is how my query is set up....
Field: TypeID TypeID
Table: Temp Temp
Update To: [TypeID] Like [Enter New
TypeID]
Criteria: Like [Enter Old TypeID]
or:

The Like [Enter Old TypeID] works to pull up the correct records. The
[TypeID] Like [Enter New TypeID] does prompt the user to enter a value but
the values in the table are updated to a zero value. Please help.

 

[Guest]

Exellent advise. Works like a charm.
--
Lorraine

Hi, Lorraine.

One may be vague in the selection criteria, but one should not be vague in
the value that will be assigned to the column in the update query. Instead
of using LIKE in the "Update To:" cell, set it to the value that the user
types in. For example, try:

Field: TypeID
Table: Temp
Update To: [Enter New TypeID]
Criteria: Like "*" & [Enter Old TypeID] & "*"

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

I have an update query that's not updating correctly. I want to find a value
in the Temp table by asking the user for input then change that value based
on more input from the user. This is how my query is set up....
Field: TypeID TypeID
Table: Temp Temp
Update To: [TypeID] Like [Enter New
TypeID]
Criteria: Like [Enter Old TypeID]
or:

The Like [Enter Old TypeID] works to pull up the correct records. The
[TypeID] Like [Enter New TypeID] does prompt the user to enter a value but
the values in the table are updated to a zero value. Please help.

 

[John Spencer]

I have an update query that's not updating correctly. I want to find a
value
in the Temp table by asking the user for input then change that value based
on more input from the user. This is how my query is set up....
Field: TypeID TypeID
Table: Temp Temp
Update To: [Enter New TypeID]
Criteria: Like [Enter Old TypeID]

Your method was returning True or False (and probably in most cases - false)
False is Zero. Since the Update you constructed was comparing the TypeID
(which should match your criteria) to the NEW value you wanted to replace
the old value with.