Recent content by JoeyJ

Thanks reclusive monkey. I tried what you said, except instead of doing a seperate query, I just did it in the row source property of the field on the form, is that ok? It seems to work. I did say that is what you should do, well that is what I meant anyway.

Hi All I have a table with three fields: auto number primary key, last name and first name. I have another table where I want to assign tasks to people. I have been told that good programming practice is to link tables via autonumber primary key. This means that in the task allocation table, I...

Thanks for your help guys. It all got too hard for me, I am just gonna stick with the original advice - normalise the data and leave it at that. It wont take that much longer to enter that data, but it makes everything else much more simple.

Hi All I am trying to make a form where the default value of particular fields is the last value that was selected for that field. This is to make it faster to enter data. I have never done this before and am only taking a guess, this is what I have done so far: For the AfterUpdate property...

Thanks for that Pat. When I said it would be harder to look at the data as a whole, what I meant was you can't present it in a nice way AND be able to edit it at the same time. I know you could do some cross tab queries and reports to make it look like what I want, but you need to go back to...

Thanks for your response Neil Your posts have helped me understand normalization and good programming principles. My main concern is the database needs to be quick to interpret and modify, as it will be used on a day to day basis and so needs to be as fast as possible to use. Doing it the...

For example, with my method a typical project would look like this: Person Function Jan Feb Mar Ap Ma Jun Jul Aug Robert Accounts 0.5 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Jennifer Engineer 0.3 0.5 0.5 0.5 0.5 0.5 0.5 0.3 Using the other method, It would look like this: Person Function Time Utilisation...

Thanks for your suggestion neileg. I think I understand what you are saying, but I think it would be impractical. One person will be working over many time periods, perhaps 20 or so, using your method would mean creating a new entry for every time period and selecting that same person for every...

Hi All I am trying to create a database for estimating manhours on projects. There is a setup table with two columns: "Project" and "Time Period". The database is supposed to allocate manhours to tasks on projects, which is used in estimating man hour costs and also forecasting labour resource...

Hello I am a first time access user and have a question. I have two tables. Table 1 looks like this: Project Number......................Deliverable 1.........................................apples 1.........................................bananas...