Search results

Using Access 2007, I wanted to rename my FE/BE mdb files after some major modifcations. When I opened the FE.mdb, naturally could not find the BE.mdb linked tables. I tried to relink tables in the renamed BE but that did not work so I returned FE/BE to original names. Now, several of the BE...

//Edited to include Error Msg returned// I can't figure out why this code returns a zero-length string for TempFileName, resulting in error after rs.Update. Declaring Const sPath = "D:\Folder\" works great but when I try to use Dim sFile As Variant sPath = Application.CurrentProject.Path...

I use several similar queries that require the same criteria in the same field (jobs). I exclude jobs in each query's criteria with <>"job1" AND <>"job2" AND <>"job3". Occasionally I have to add another job to exclude. Is it possible (you know I'm new here) to create a control somewhere so...