Recent content by ToddMac
-
T
With multiple linked dbs, wow do I drop linked tables all tables in only one of them.
Thank you. I will try.- ToddMac
- Post #3
- Forum: Modules & VBA
-
T
With multiple linked dbs, wow do I drop linked tables all tables in only one of them.
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...- ToddMac
- Thread
- Replies: 3
- Forum: Modules & VBA
-
T
Using LIKE operator in an SQL statement not working. Please help.
Sweet. I missed that. Works perfectly. Glad to be here! -
T
Using LIKE operator in an SQL statement not working. Please help.
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...