Search results

This works to drop all linked tables but now that the database has grown so large I have split it into 3 backends. I only want to drop linked tables from one of the dbs: salesauto_be.accdb Project is all Access databases. On Error GoTo Err_Load Dim db As DAO.Database Set db = CurrentDb() Dim...

Not sure what I am doing wrong and I am sure that it is a formatting error. This works: !lstSel.RowSource = "Select ag_auto, PID, AgreeNum, Contractor, LandOwner, Type FROM qryAgreeSel WHERE ag_del = 0 AND PID Like '*224*' Order by PID" This doesn't: !lstSel.RowSource = "Select ag_auto, PID...