Recent content by peterod

I will revise based on your comments. Thankyou.

i see its a many to many now after re-reading above. oops. ill add a junction table in. Majp. Do you have a sample kicking about or a link i could use to see how this would be achieved. I feel stupid now!:(

thanks for the replys. I will try to define it a little clearer. I work in a design office (architectural - timber frame) , we have specifications for each project which should be consistent and they are constantly inconsitant or even incomplete. Each project only has 1 specification but...

First post in a long time and im struggling to get my head back in to it. I think i am barking up the wrong tree. I have 2 tables. 1 simply contains project numbers the second contains specification elements and a yes no check box table The result i am trying to achieve is a check box form...

Hi All. :banghead: I am returning to access to try once more to sort out my life issues! I know thats a big ask lol. I started looking at access as a solution several years ago but didnt have the spare time needed to get everything working. I am a an architectural tech by day, from Scotland...

Hi. I am currently undertaking a massive project of getting our office paper free (as best we can) I have novice experience level so please be gentle. First thing I am doing is looking at the data I need and attempting to rationalize it. Where ai am looking for advice is the specification...

Ok I guess that this is not the right way to go about getting help. I think I better start a new thread with specific issues. For those that downloaded the database. any suggestions?

I am now at the extent of my knowledge on the database I am trying to do to manage my selfbuild house. Not sure which forum a post like this fits so the general one seemed best. I have created the attached so far. Please take a look. as it stands. I think it is nearly there in the...

Hi all. Relative newbie question For the purpose of this i will use an example. I have a table of values as follows. columns are value 1 | value 2 | Value 3 | Value 4 | I want to highlight the lowest value in each row using conditional formating or similar. i also want the lowest figure...

I am creating a database to help manage my self build house project. This is using access 2010 database The table that are concerned are materials merchants material prices I have a table of merchants with their contact details etc and another table The prices table has 4 fields id...

Please???? Need some help with this. cherry on top

This is a slight continuation of this post here, but this post inst really all that relevant unless you want to see the mess I have tided up... After a fair bit of trial and error I now think that I have followed normalization and binned the repeating data structures that I had before. I have...

Ok. Going on above i have further normalised my data structure which has simplified things immensely. As i am sure you would have expected. I know that this is the Queries subforum so I will make a new thread for my question here.

Would anyone be interested in advising on the database structure if I attached the database? Can I attach the database? It was based originally on a MS template file named tasks and is growing and getting quite messy. I have a format for the forms/sub-forms that works at the moment and allows...

Hi. thanks for the reply. I know that it doesn't fully follow normalization rules, but the data input forms require it to be set out this way and it works for the purpose required... Any ideas as to the query issue? Imagine the tables were normalized and I had several check boxes across the...