Search results

I am desgning a holiday tracker. basically, each team member has a numbers of hours worked per day ech team meber has different days they work - so it can look like this >: Darren - Monday 5 hours, Tursday 5 hours, Wednesday 0 hours, thursday 5 hours , friday 5 hours. the working patter...

I have a UNION query which looks at three tables. it pulls REF - ACTIVITY_NEEDED - DATE NEEDED - TEAM - OWNER and some other fields What i want ... if a REF has three acitivities it only shows the OLDEST ONE according to DATE NEEDED. is this possible ? any one got any ideas ...

Question - splitting a database up. I have a case management system built in access. it services 8 teams, each team has 10 people. Its working ok and has about 10K records a month I am managaing the back end with weekly Compacts and even with 20K records its about 90meg. The main query (...

Hi guys I am currently using this code to detect Idle time and auto log of users after 30 mins if they have had ZERO DB activity. http://support.microsoft.com/?id=210297 it works a treat - even if the back end corrupts wich saves me loads of time as we have 100 users and most if not all...

HI guys, I have a head scratcher here and i need a little help. if you have a few mins i would really appreciate your help. I have a small DB that stores 4 fields only ( its a test database so i can understand the concept ) its about hire cars and when they were hired. it holds Date...

Hi guys, Im STUCK - been working on a project with access and so far so good. We are designed a mini case management system for my company. We are happy with it to date and we wanted to add the functionality to Track changes made to the system for audit purposes. However - this is where the...