Recent content by leftpeg

Thanks for your detailed explanation. You guys really are a great help to us newbies of Access. I have one more question. I have a combo box in my table where i select an engineer which work has been allocated to. I then have second box which says who the work was completed by. Is there...

Brianwarnocks post is perhaps correct. Using his link i found the code i needed and put into my query and then sorted it by that. It worked perfectly. Thanks Brian

it is saying it is missing a closing parentthesis

Thanks DCrake for your answer. Apologies, but i am completely new to Access. When i type in the code below, the column comes up with an error. I havr replaced fldHouseNo with HouseNo - which is the name of the column with the numbers i require sorting. Where am i going wrong. In answer to the...

Probably an easy answer to yo guys and i probably oculd of found it using a search, but i hope this will be quicker. I have house numbers like below: 11 13 15 17 19 23 52 54 56 68 70 86 90 29A 82B...

Hi, I have posted several questions regarding how to set up my database recently and i am now a little bit confused. I would appreciate anyones help on how many tables to use, relationships etc. To briefly explain, my company has been awarded a contract to carry out safety checks on 6,000...

perfect, cant believe i didnt think of that :)

that info will be standard for every single job, and each has to be answered yes or no by the engineer. i am pretty new to access so you will have to bear with me. i am playing around with the database to try and make it work. another problem i have is that the customer supplied me with the...

okay here is all the information i will need, now i have looked into it. JobID House Number Address Post Code Town Complete Y/N Date completed (date) By who (combo drop down list of engineers) Meter Serial Number Meter reading Are the tails loose? Y/N Isolator fitted in correct orientation? Y/N...

perfect, thanks. best get my text book out and learn about junction tables then. but most i think, if not all, will be one to many. already made a table for engineer details.

i have just ofund out there is more information needed for the database. for each job i have to input meter serial number and about 10 other yes or no questions for each job eg. all seals in place? Y/N bare copper? Y/N So should i now have 3 tables tbl1 customer info with job number tbl 2 job...

with job number in both tables?

thanks for quick responses guys. yeah i had thought about having multiple fields for the address i.e. house number, road etc. below is the information i need to create tables for. to give you more info, i have five engineers who will be visiting properties, sometimes prebooked and sometimes...

Hi, I am very new to Access but i seem to be getting to grips with it. My business has just taken on a large contract for the UK main electric provider and we have 6,000 addresses to visit to carry out electric meter checks. I am about to recieve a data spread sheet with the 6,000 address...

they are being paid on price, so the insentive is to do as many as they can. so i think that may resolve the issue you raised above