Can't update table from Form

  • Thread starter Thread starter sara
  • Start date Start date
S

sara

I feel like this should be easy, but after 6 hours of web
search, online help, and books, I am still stuck. I hope
someone can help.

I have 3 tables in a query whose results are used to
display my first form - parameter Cashier Number.

Tables:
Cashier - Their Name, CashierNumber, OffRegister (No or
Yes indicating removal for poor performance), DateOff
Register
Employee - File# (which is link to Cashier Number),
HomeLocation
OverShort - CashierNumber, SaleDate, StoreNumber,
OverShort$, Ignore (No or Yes, indicating the record,
received from our outside source, is wrong and a
replacement has been created [what I'm trying to do]) and
VarType (I, M or D). Key to table: CashierNumber,
SaleDate, StoreNumber and Ignore

My form is fine to bring up the OverShort records based on
the search. I have a button "Update this Record" that,
when clicked, brings the data from that record to another
form that will (should) allow the user to update
OverShort$, Ignore and VarType. Since I don't want to
ever lose the original record, I want to first change
Ignore to YES (from default NO), so I can Append a record
with the same Key info, and the corrected OverShort $
amount.

I click "Update this record" and open a new form. I get
all the data from the first form (Source is Form!
F_CashierOS!FieldName), and I want to be able to update
the 3 fields, but I can't.

I first want the user to be able to click "Ignore this
Record" button that runs a query simply to change Ignore
NO to YES. This works when I run the query and manually
enter the fields (the form names pop up as parameters),
but won't work when I try to run it from the button.

I just want to change Ignore to YES, so we can then put in
the NEW record with the proper data, but NEVER delete what
we got from the vendor.

Once Ignore is YES, the user can change the $ amount and
Ignore (and type), and add a new record - with an Append
Query.

I am not sure the Update form is right; I run the initial
query and get 202 records. I go to the "Update this
record": form and I get 56,813 records - but They are all
the same record!

I can get the data from the first form to show on the
second, but it can't be updated.

I've tried all that I can find - DataEntry, Updatable,
with Inconsistencies, - but nothing has worked.

Any and All help is appreciated. I have a class at the
end of the month, but I'm not positive they'll cover these
topics. I think it's more VBA.
 
Hi Sara

If you open your query, can you add a record that way? If not, I would suspect
that your joins are not right.

Best regards
Maurice St-Cyr

Subject: Can't update table from Form
From: "sara" (e-mail address removed)
Date: 6/8/2004 2:19 PM Eastern Daylight Time
Message-id: <[email protected]>

I feel like this should be easy, but after 6 hours of web
search, online help, and books, I am still stuck. I hope
someone can help.

I have 3 tables in a query whose results are used to
display my first form - parameter Cashier Number.

Tables:
Cashier - Their Name, CashierNumber, OffRegister (No or
Yes indicating removal for poor performance), DateOff
Register
Employee - File# (which is link to Cashier Number),
HomeLocation
OverShort - CashierNumber, SaleDate, StoreNumber,
OverShort$, Ignore (No or Yes, indicating the record,
received from our outside source, is wrong and a
replacement has been created [what I'm trying to do]) and
VarType (I, M or D). Key to table: CashierNumber,
SaleDate, StoreNumber and Ignore

My form is fine to bring up the OverShort records based on
the search. I have a button "Update this Record" that,
when clicked, brings the data from that record to another
form that will (should) allow the user to update
OverShort$, Ignore and VarType. Since I don't want to
ever lose the original record, I want to first change
Ignore to YES (from default NO), so I can Append a record
with the same Key info, and the corrected OverShort $
amount.

I click "Update this record" and open a new form. I get
all the data from the first form (Source is Form!
F_CashierOS!FieldName), and I want to be able to update
the 3 fields, but I can't.

I first want the user to be able to click "Ignore this
Record" button that runs a query simply to change Ignore
NO to YES. This works when I run the query and manually
enter the fields (the form names pop up as parameters),
but won't work when I try to run it from the button.

I just want to change Ignore to YES, so we can then put in
the NEW record with the proper data, but NEVER delete what
we got from the vendor.

Once Ignore is YES, the user can change the $ amount and
Ignore (and type), and add a new record - with an Append
Query.

I am not sure the Update form is right; I run the initial
query and get 202 records. I go to the "Update this
record": form and I get 56,813 records - but They are all
the same record!

I can get the data from the first form to show on the
second, but it can't be updated.

I've tried all that I can find - DataEntry, Updatable,
with Inconsistencies, - but nothing has worked.

Any and All help is appreciated. I have a class at the
end of the month, but I'm not positive they'll cover these
topics. I think it's more VBA.
Click to expand...
 
Well, Thanks. I now have the query and resulting form
allowing a new record to be added at the end, but I still
can't change Ignore to Yes.

I even tried putting the Button on the first screen, and
it then calls for the key fields (SaleDate, etc) as
parameters (Forms!F_CashierOS!SaleDate). And the button
on the second screen still gets "You are about to update 0
records".

Any further help you can offer?
Sara
-----Original Message-----
Hi Sara

If you open your query, can you add a record that way? If not, I would suspect
that your joins are not right.

Best regards
Maurice St-Cyr

Subject: Can't update table from Form
From: "sara" (e-mail address removed)
Date: 6/8/2004 2:19 PM Eastern Daylight Time
Message-id: <[email protected]>

I feel like this should be easy, but after 6 hours of web
search, online help, and books, I am still stuck. I hope
someone can help.

I have 3 tables in a query whose results are used to
display my first form - parameter Cashier Number.

Tables:
Cashier - Their Name, CashierNumber, OffRegister (No or
Yes indicating removal for poor performance), DateOff
Register
Employee - File# (which is link to Cashier Number),
HomeLocation
OverShort - CashierNumber, SaleDate, StoreNumber,
OverShort$, Ignore (No or Yes, indicating the record,
received from our outside source, is wrong and a
replacement has been created [what I'm trying to do]) and
VarType (I, M or D). Key to table: CashierNumber,
SaleDate, StoreNumber and Ignore

My form is fine to bring up the OverShort records based on
the search. I have a button "Update this Record" that,
when clicked, brings the data from that record to another
form that will (should) allow the user to update
OverShort$, Ignore and VarType. Since I don't want to
ever lose the original record, I want to first change
Ignore to YES (from default NO), so I can Append a record
with the same Key info, and the corrected OverShort $
amount.

I click "Update this record" and open a new form. I get
all the data from the first form (Source is Form!
F_CashierOS!FieldName), and I want to be able to update
the 3 fields, but I can't.

I first want the user to be able to click "Ignore this
Record" button that runs a query simply to change Ignore
NO to YES. This works when I run the query and manually
enter the fields (the form names pop up as parameters),
but won't work when I try to run it from the button.

I just want to change Ignore to YES, so we can then put in
the NEW record with the proper data, but NEVER delete what
we got from the vendor.

Once Ignore is YES, the user can change the $ amount and
Ignore (and type), and add a new record - with an Append
Query.

I am not sure the Update form is right; I run the initial
query and get 202 records. I go to the "Update this
record": form and I get 56,813 records - but They are all
the same record!

I can get the data from the first form to show on the
second, but it can't be updated.

I've tried all that I can find - DataEntry, Updatable,
with Inconsistencies, - but nothing has worked.

Any and All help is appreciated. I have a class at the
end of the month, but I'm not positive they'll cover these
topics. I think it's more VBA.
Click to expand...


.
Click to expand...
 
I tried the suggestion here and my problem still exists.
Do I start a new thread or can someone help by reading
this?
thanks
-----Original Message-----
Well, Thanks. I now have the query and resulting form
allowing a new record to be added at the end, but I still
can't change Ignore to Yes.

I even tried putting the Button on the first screen, and
it then calls for the key fields (SaleDate, etc) as
parameters (Forms!F_CashierOS!SaleDate). And the button
on the second screen still gets "You are about to update 0
records".

Any further help you can offer?
Sara
-----Original Message-----
Hi Sara

If you open your query, can you add a record that way? If not, I would suspect
that your joins are not right.

Best regards
Maurice St-Cyr

Subject: Can't update table from Form
From: "sara" (e-mail address removed)
Date: 6/8/2004 2:19 PM Eastern Daylight Time
Message-id: <[email protected]>

I feel like this should be easy, but after 6 hours of web
search, online help, and books, I am still stuck. I hope
someone can help.

I have 3 tables in a query whose results are used to
display my first form - parameter Cashier Number.

Tables:
Cashier - Their Name, CashierNumber, OffRegister (No or
Yes indicating removal for poor performance), DateOff
Register
Employee - File# (which is link to Cashier Number),
HomeLocation
OverShort - CashierNumber, SaleDate, StoreNumber,
OverShort$, Ignore (No or Yes, indicating the record,
received from our outside source, is wrong and a
replacement has been created [what I'm trying to do]) and
VarType (I, M or D). Key to table: CashierNumber,
SaleDate, StoreNumber and Ignore

My form is fine to bring up the OverShort records based on
the search. I have a button "Update this Record" that,
when clicked, brings the data from that record to another
form that will (should) allow the user to update
OverShort$, Ignore and VarType. Since I don't want to
ever lose the original record, I want to first change
Ignore to YES (from default NO), so I can Append a record
with the same Key info, and the corrected OverShort $
amount.

I click "Update this record" and open a new form. I get
all the data from the first form (Source is Form!
F_CashierOS!FieldName), and I want to be able to update
the 3 fields, but I can't.

I first want the user to be able to click "Ignore this
Record" button that runs a query simply to change Ignore
NO to YES. This works when I run the query and manually
enter the fields (the form names pop up as parameters),
but won't work when I try to run it from the button.

I just want to change Ignore to YES, so we can then put in
the NEW record with the proper data, but NEVER delete what
we got from the vendor.

Once Ignore is YES, the user can change the $ amount and
Ignore (and type), and add a new record - with an Append
Query.

I am not sure the Update form is right; I run the initial
query and get 202 records. I go to the "Update this
record": form and I get 56,813 records - but They are all
the same record!

I can get the data from the first form to show on the
second, but it can't be updated.

I've tried all that I can find - DataEntry, Updatable,
with Inconsistencies, - but nothing has worked.

Any and All help is appreciated. I have a class at the
end of the month, but I'm not positive they'll cover these
topics. I think it's more VBA.
Click to expand...


.
Click to expand...
.
Click to expand...
 
Back
Top