Search results

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...

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...

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...

I have a database which has a yes no in each of the tables, set manually to true by the user. I want to query the database to return the fields with the check box true. I am unsure how to do this. I can get it to do it no problem on 1 checkbox.... Please see below a diagram of how I have...

I will use an example database as follows. table x table y there are other tables in the database though! I have a form which I want to use to add/edit data to both tables. the primary key in table x is ID and the foreign key in y is xID so relationship is 1 to many with It seems a...

Hi All I am attempting to make a bill of quantities database for a self-build project. Its so I can sort out the management side of my house build. I am now on re-design 3 as I learn more about access, i find better ways of doing the job. I now have various tables with various data sets...

This is hopefully a straight forward question... I have more columns than the table limit, nearly 400. I can easily group the column names to split the data up. What I want to know is the best way to set up the relationship between the new and existing tables. Do you need to do this. The...

this is hopefully straight forward for you guys. im struggling to get to grips with the select case statement and would really appreciate if i want to have a field that performs a different calculation for each record heres what i thought it should look like, Select Case [quantity]...

Hi all. Im new to access, thus im here :) I have a little mysql/php experience but am now trying to build a desktop app in access. I am trying to make a Bill of quantities application for my self build house, which will take the material dimensions To understand my question i will need to...

hi all. im Pete from Scotland. hope this is a friendly place.