If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can't update table from Form
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. |
#2
|
|||
|
|||
Can't update table from Form
|
#3
|
|||
|
|||
Can't update table from Form
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" Date: 6/8/2004 2:19 PM Eastern Daylight Time Message-id: 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. . |
#4
|
|||
|
|||
Not working- do I start a new thread?
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" Date: 6/8/2004 2:19 PM Eastern Daylight Time Message-id: 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. . . |
Thread Tools | |
Display Modes | |
|
|