Recent content by mrnorth

Wheres he gone!? :(

Gotcha. Thanks Just need to wait for SJ McAbney's reply now!

Would this primarily to see at a glance which records/entries have times entered on the basis of a day and of a week? Would it not be another variable to juggle when I come to creating queries and reports?

Would you be able to elaborate on how to do this/what this would look like. I have plenty of ideas but don't know how to implement it and whether or not it will all come crashing in wards at a later date when there is more information in the db - like what is happening now. I really don't have...

Just experienced something very annoying which I've never seen before! Edited a form because it wasn't functioning correctly but it won't let me save it because it says "You do not have exclusive access to the database. Your design changes cannot be saved this time. Do you want to close without...

Well each project is budgeted for between 5 and 40 days each year and there are about 50 projects - 20 that need to be done every year, 20 every other year, and another 10 whenever they can be fitted in. There are so many 'activities' that are carried out during a particular project that it...

but it seems to work at the moment. I have UserID instead of UpdateId in the updates table and the tables contains hundreds of entries. Each entry is unique because the UserID, Date,Timespentonproject, ProjectID cannot happen more than once. If the User needs to add some more time to the same...

Thanks again. I'm going to give this another bash tomorrow in the office. Is it normal that I find this so bloody complicated!? I hope this all gives me the results I need. What if it doesn't? Is it easy to change? Remember, keep the language simple! I'm completely useless!

Do I really need a UserID in User table as there are only 5-7 of us and it is very unlikely that someone will have the same initials. I have at the moment Initials as the unique identifier in User table. I have since taken out Project Title from Project Progress as I realised it was the reason...

The actual project table has a one to many relationship with the project progress table and the employee has a one to many relationsip witht he project progress table. That is the basic structure of it it seems. The database sample I found in this forum was called ManyToManyAXP.mdb and seemed to...

I'm sure I have. I can't see where I'm going wrong? I'm using the ManyToMany sample database (in the sample database forum) as I guide as it appears to be the closest type of 'sample' I could find to get my structure right. Any suggestions?.... pls? :)

Sigh.. please help me out I have a datasheet form linked to a query 'project entries' which brings together information from two tables. 'project' and 'project progress'. When the data is entered into the db all the data appears to be there in the 'project entries' query but not the 'project...

A few months back I inherited a Time Recording System database. Actually there wasn't much there in terms of doing anything useful but it meant there was alot of mess to sift through and sort out. I have little experience with Access and have little time to get this system up and running. I...