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
|
|||
|
|||
Recordset Update Issues
I have a button that filters a form filled with dates from two tables.
It filters the Season to Seasons and the DevCode to DevCodeA and pulls the marketingname from the current form for display. The dates pulled from the first table are set and do not change (except from the table by a manager) the dates from the second table need to be updateable as they are "actual" dates. Name Set Date Entered Date Milestone Mgr Set Actual Date Right now nothing is updateable. I am getting a recordset not updateable error. I check both date tables and they both have primary key fields (autonumber) and all of the other fields are not indexed. Is it something to do with the filtering? I am at my wits end. Please help me figure this out. |
#2
|
|||
|
|||
Recordset Update Issues
"hntsignif" wrote in message
... I have a button that filters a form filled with dates from two tables. It filters the Season to Seasons and the DevCode to DevCodeA and pulls the marketingname from the current form for display. The dates pulled from the first table are set and do not change (except from the table by a manager) the dates from the second table need to be updateable as they are "actual" dates. Name Set Date Entered Date Milestone Mgr Set Actual Date Right now nothing is updateable. I am getting a recordset not updateable error. I check both date tables and they both have primary key fields (autonumber) and all of the other fields are not indexed. Is it something to do with the filtering? I am at my wits end. Please help me figure this out. What is the RecordSource of the form? If it's a stored query, post the SQL of the query. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
#3
|
|||
|
|||
Recordset Update Issues
SELECT MilestoneDates.Seasons, MilestoneDates.ABrief, MilestoneDates.ADesRvw,
MilestoneDates.ADesToDev, MilestoneDates.ATPO, MilestoneDates.LPC, MilestoneDates.LineInFlex, MilestoneDates.BBrief, MilestoneDates.NameKO, MilestoneDates.BDesToDev, MilestoneDates.DesDebut, MilestoneDates.NameApprv, MilestoneDates.HGCBrief, MilestoneDates.AllDesSAMM, MilestoneDates.MarcomKO, MilestoneDates.GEOTDesRvw, MilestoneDates.AllTPOSAMM, MilestoneDates.PkgDirRvw, MilestoneDates.ColorInFLEX, MilestoneDates.SGCirCPADev, MilestoneDates.CopyLegalSaf, MilestoneDates.CopyTechTIs, MilestoneDates.PIMSAMM, MilestoneDates.ProtoTeardwn, MilestoneDates.PostSAMMtls, MilestoneDates.MarginRvw, MilestoneDates.PkgCopyKO, MilestoneDates.MLPContent, MilestoneDates.MLPInFLEX, MilestoneDates.SSFlagsFinal, MilestoneDates.PIMMLP, MilestoneDates.SGClrCodes, MilestoneDates.SGClrCodesFty, MilestoneDates.SSConfirm, MilestoneDates.PhotoSampl, MilestoneDates.SGPkgBrief, MilestoneDates.SGImageChk, MilestoneDates.GEOTCatFBs, MilestoneDates.PIMCatalog, MilestoneDates.PostSIMTools, MilestoneDates.CopyFinalPkg, MilestoneDates.HGFinalMatrl, MilestoneDates.PricingConf, MilestoneDates.BMLImagePost, MilestoneDates.SSShips, MilestoneDates.PIMGTM, MilestoneDates.AllPkgOut, MilestoneDates.SockFinalMatrl, MilestoneDates.ProdConfirm, MilestoneDates.PkgConfirm, MilestoneDates.BuyReady, DateActuals.ABrief, DateActuals.ADesRvw, DateActuals.ADesToDev, DateActuals.ATPO, DateActuals.LPC, DateActuals.LineInFlex, DateActuals.BBrief, DateActuals.NameKO, DateActuals.BDesToDev, DateActuals.DesDebut, DateActuals.NameApprv, DateActuals.HGCBrief, DateActuals.AllDesSAMM, DateActuals.MarcomKO, DateActuals.GEOTDesRvw, DateActuals.AllTPOSAMM, DateActuals.PkgDirRvw, DateActuals.ColorInFLEX, DateActuals.SGCirCPADev, DateActuals.CopyLegalSaf, DateActuals.CopyTechTIs, DateActuals.PIMSAMM, DateActuals.ProtoTeardwn, DateActuals.PostSAMMtls, DateActuals.MarginRvw, DateActuals.PkgCopyKO, DateActuals.MLPContent, DateActuals.MLPInFLEX, DateActuals.SSFlagsFinal, DateActuals.PIMMLP, DateActuals.SGClrCodes, DateActuals.SGClrCodesFty, DateActuals.SSConfirm, DateActuals.PhotoSampl, DateActuals.SGPkgBrief, DateActuals.SGImageChk, DateActuals.GEOTCatFBs, DateActuals.PIMCatalog, DateActuals.PostSIMTools, DateActuals.CopyFinalPkg, DateActuals.HGFinalMatrl, DateActuals.PricingConf, DateActuals.BMLImagePost, DateActuals.SSShips, DateActuals.PIMGTM, DateActuals.AllPkgOut, DateActuals.SockFinalMatrl, DateActuals.ProdConfirm, DateActuals.PkgConfirm, DateActuals.BuyReady, DateActuals.DevCodeA, DateActuals.DesRefine, MilestoneDates.DesRefine AS DesRefine_MilestoneDates, MarcomPackaging.MARKETINGNAME, MilestoneDates.Seasons FROM (MarcomPackaging INNER JOIN MilestoneDates ON MarcomPackaging.Season=MilestoneDates.Seasons) INNER JOIN DateActuals ON MarcomPackaging.TrackingNo=DateActuals.DevCodeA; "Dirk Goldgar" wrote: What is the RecordSource of the form? If it's a stored query, post the SQL of the query. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
#4
|
|||
|
|||
Recordset Update Issues
"hntsignif" wrote in message
... SELECT MilestoneDates.Seasons, MilestoneDates.ABrief, MilestoneDates.ADesRvw, MilestoneDates.ADesToDev, MilestoneDates.ATPO, MilestoneDates.LPC, MilestoneDates.LineInFlex, MilestoneDates.BBrief, MilestoneDates.NameKO, MilestoneDates.BDesToDev, MilestoneDates.DesDebut, MilestoneDates.NameApprv, MilestoneDates.HGCBrief, MilestoneDates.AllDesSAMM, MilestoneDates.MarcomKO, MilestoneDates.GEOTDesRvw, MilestoneDates.AllTPOSAMM, MilestoneDates.PkgDirRvw, MilestoneDates.ColorInFLEX, MilestoneDates.SGCirCPADev, MilestoneDates.CopyLegalSaf, MilestoneDates.CopyTechTIs, MilestoneDates.PIMSAMM, MilestoneDates.ProtoTeardwn, MilestoneDates.PostSAMMtls, MilestoneDates.MarginRvw, MilestoneDates.PkgCopyKO, MilestoneDates.MLPContent, MilestoneDates.MLPInFLEX, MilestoneDates.SSFlagsFinal, MilestoneDates.PIMMLP, MilestoneDates.SGClrCodes, MilestoneDates.SGClrCodesFty, MilestoneDates.SSConfirm, MilestoneDates.PhotoSampl, MilestoneDates.SGPkgBrief, MilestoneDates.SGImageChk, MilestoneDates.GEOTCatFBs, MilestoneDates.PIMCatalog, MilestoneDates.PostSIMTools, MilestoneDates.CopyFinalPkg, MilestoneDates.HGFinalMatrl, MilestoneDates.PricingConf, MilestoneDates.BMLImagePost, MilestoneDates.SSShips, MilestoneDates.PIMGTM, MilestoneDates.AllPkgOut, MilestoneDates.SockFinalMatrl, MilestoneDates.ProdConfirm, MilestoneDates.PkgConfirm, MilestoneDates.BuyReady, DateActuals.ABrief, DateActuals.ADesRvw, DateActuals.ADesToDev, DateActuals.ATPO, DateActuals.LPC, DateActuals.LineInFlex, DateActuals.BBrief, DateActuals.NameKO, DateActuals.BDesToDev, DateActuals.DesDebut, DateActuals.NameApprv, DateActuals.HGCBrief, DateActuals.AllDesSAMM, DateActuals.MarcomKO, DateActuals.GEOTDesRvw, DateActuals.AllTPOSAMM, DateActuals.PkgDirRvw, DateActuals.ColorInFLEX, DateActuals.SGCirCPADev, DateActuals.CopyLegalSaf, DateActuals.CopyTechTIs, DateActuals.PIMSAMM, DateActuals.ProtoTeardwn, DateActuals.PostSAMMtls, DateActuals.MarginRvw, DateActuals.PkgCopyKO, DateActuals.MLPContent, DateActuals.MLPInFLEX, DateActuals.SSFlagsFinal, DateActuals.PIMMLP, DateActuals.SGClrCodes, DateActuals.SGClrCodesFty, DateActuals.SSConfirm, DateActuals.PhotoSampl, DateActuals.SGPkgBrief, DateActuals.SGImageChk, DateActuals.GEOTCatFBs, DateActuals.PIMCatalog, DateActuals.PostSIMTools, DateActuals.CopyFinalPkg, DateActuals.HGFinalMatrl, DateActuals.PricingConf, DateActuals.BMLImagePost, DateActuals.SSShips, DateActuals.PIMGTM, DateActuals.AllPkgOut, DateActuals.SockFinalMatrl, DateActuals.ProdConfirm, DateActuals.PkgConfirm, DateActuals.BuyReady, DateActuals.DevCodeA, DateActuals.DesRefine, MilestoneDates.DesRefine AS DesRefine_MilestoneDates, MarcomPackaging.MARKETINGNAME, MilestoneDates.Seasons FROM (MarcomPackaging INNER JOIN MilestoneDates ON MarcomPackaging.Season=MilestoneDates.Seasons) INNER JOIN DateActuals ON MarcomPackaging.TrackingNo=DateActuals.DevCodeA; I can't be sure, but this may be a case of a query that is not updatable because it includes three tables in a many-to-one-to-many relationship. Try changing the form's Recordset Type property (on the Data tab of the form's property sheet) to "Dynaset (Inconsistent Updates)". If that doesn't make at least some of the fields updatable, modify the query so that it includes the linking fields from all tables, and (if not already done) index those fields. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
#5
|
|||
|
|||
Recordset Update Issues
That did it I changed the Type to Dynaset (Inconsistent Updates) and it
is now working! Thanks a bunch. This one was driving me buggy. I can usually figure them out but this forum has been fantastic for those times I just can't find the anwsers on my own. "Dirk Goldgar" wrote: I can't be sure, but this may be a case of a query that is not updatable because it includes three tables in a many-to-one-to-many relationship. Try changing the form's Recordset Type property (on the Data tab of the form's property sheet) to "Dynaset (Inconsistent Updates)". If that doesn't make at least some of the fields updatable, modify the query so that it includes the linking fields from all tables, and (if not already done) index those fields. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|