Recent content by tome20

Thanks for the response. As to your fist assumption, I'm afraid I do have several teams (4 teams with a total of 9 sub-teams right now, and we're expecting to grow in the next year) The attribution of orders to persons is based on the step they completed (ie. if I process three order requests...

Hi all. I've been getting great information from this forum for a couple of years now, but I'm not having any luck finding a solution to a new problem I'm encountering in a database design. So my team of approximately 40 people works on electronic order forms collaboratively via Sharepoint...

I'm afraid consultant work isn't an option as we are legally prohibited from making our records available to any member of the public.

My database has returned the dreadedMSysDb error, and a coworker made a back up of the corrupted file before the error reared it's evil head. So my backup is corrupt, my original is corrupt, I'm on a stand-alone system and can't load MS' jetcompact database utility and I've lost 24000 records...

SQL String as follows- (There could be a typo here. I had to hand-type it on this web connected PC after reading it off of a stand-alone) SELECT AllTasks.Status, AllTasks.SuspenseDate, AllTasks.SuspenseTime, AllTasks.LogID, AllTasks.EntryDate, AllTasks.Subject, AllTasks.ActionTo...

It seems simple enough, but it's not taking. I'm still pulling records within the next seven days. Should it make any difference that I'm using Access '02?

I'm trying to run a report that returns all entries with a due date of 60 days from one week from today. ie: If today is January 1st, my report would run from 8 Jan to 8 Mar (give or take a day...) I currently have a report that pulls all records within the next sixty days (ie: if today is...