Recent content by cassius

Well, I decided I was hurt too bad to fix the old db so I started a new FE, imported all the objects that were not corrupted and rebuilt the ones that were. It links fine to the tables in the BE. I'll be going now to BACKUP BACKUP BACKUP. THX for this great forum!

Dave, Thx, when I tried to import objects to a new db, received the following: "You don't have permission to import, export, or link to [this object]". Somehow I need to set/reset permissions for these objects . . .

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...

So much to learn, so little time . . . The key to solving my mystery was adding the backslash string to sPath. sPath = CurrentProject.Path & "\" Especial thanks to JANR - vbaInet - ghudson! You have added to my limited knowledge and restored my sanity!

JR - Thanks for the quick reply! I use MsgBox sFile instead of Debug.Print sFile and get NOTHING. MsgBox sPath returns the correct path. If I change the path, I get error File Not Found, so I think it finds the file but returns a zero length string (for whatever reason . . .) I have tried all...

//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...

Thanks! This is what I was looking for. I could never get the expression quite right in my existing queries to exclude jobnos and I've never paid close attention to the options in the query wizard. :)

Hi Doug, My current criteria to exclude jobs [Task IDs] in six queries is the expression: <>"02-0859" And <>"02-0860" And <>"02-0652" And <>"02-0827" And <>"03-0801" And <>"03-U218" And <>"03-U763" And <>"03-U938" And <>"03-U139 " I am ready to exclude more jobs: 04-0601, 04-0606, etc. Current...

Possible but not practical; I import two tables with jobs (thousands) every couple of days (static updates). I wish not to modify these tables. I feel there must be some version of QBF that will work for me but just haven't hit upon it yet. Thanks!

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...