mrrayj60
Registered User.
- Local time
- Today, 16:07
- Joined
- Sep 3, 2009
- Messages
- 103
I have a query that wont let me change anything. I have the rights in security, the properties of the qry are nothing diff thatn the others that I can edit. I've punched every button I can think of. access 2003. I can change data in each of the joined tables.
Any thoughts? Thanks, Ray
SELECT residents.name, residents.addr101, residents.addr102, residents.addr201, residents.addr202, residents.city01, residents.city02, residents.cntry02, residents.email, residents.coment02, residents.cell, residents.coment01, residents.num, residents.residentstatus, residents.phone, residents.slm, residents.sname, residents.special, residents.state01, residents.state02, residents.uaddr32, residents.uagecert, residents.ucity, residents.uemphone, residents.uendlease, residents.uleased, residents.uliendate, residents.ulienbook, residents.ulienpage, residents.ulienstat, residents.uname1, residents.uname2, residents.uphone, residents.uprevowner, residents.uprevownr2, residents.uprevownr3, residents.ustate, residents.utitledate, residents.uzip, residents.zip01, residents.zip02, residents.VacStart, residents.VacEnd, residents.Vacant, residents.Forclosuer, residents.EvacAssist, residents.Relation, BARCODES.TYPE, BARCODES.UBL, BARCODES.NAME, BARCODES.BARCODE, BARCODES.YEAR, BARCODES.MAKE, BARCODES.MODEL, BARCODES.licensetag, BARCODES.tagstate, BARCODES.ISSUEDATE
FROM residents LEFT JOIN BARCODES ON residents.num = BARCODES.UBL
ORDER BY residents.num;
**update
if I remove barcodes table from qry, I can edit. I can edit in barcodes directly. As soon as I add barcodes I cannot edit the qry. hmmmmmmmmmm
Any thoughts? Thanks, Ray
SELECT residents.name, residents.addr101, residents.addr102, residents.addr201, residents.addr202, residents.city01, residents.city02, residents.cntry02, residents.email, residents.coment02, residents.cell, residents.coment01, residents.num, residents.residentstatus, residents.phone, residents.slm, residents.sname, residents.special, residents.state01, residents.state02, residents.uaddr32, residents.uagecert, residents.ucity, residents.uemphone, residents.uendlease, residents.uleased, residents.uliendate, residents.ulienbook, residents.ulienpage, residents.ulienstat, residents.uname1, residents.uname2, residents.uphone, residents.uprevowner, residents.uprevownr2, residents.uprevownr3, residents.ustate, residents.utitledate, residents.uzip, residents.zip01, residents.zip02, residents.VacStart, residents.VacEnd, residents.Vacant, residents.Forclosuer, residents.EvacAssist, residents.Relation, BARCODES.TYPE, BARCODES.UBL, BARCODES.NAME, BARCODES.BARCODE, BARCODES.YEAR, BARCODES.MAKE, BARCODES.MODEL, BARCODES.licensetag, BARCODES.tagstate, BARCODES.ISSUEDATE
FROM residents LEFT JOIN BARCODES ON residents.num = BARCODES.UBL
ORDER BY residents.num;
**update
if I remove barcodes table from qry, I can edit. I can edit in barcodes directly. As soon as I add barcodes I cannot edit the qry. hmmmmmmmmmm
Last edited:
