Search results

  1. L

    Sorting House Numbers in Acess

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

    Sorting House Numbers in Acess

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

    Sorting House Numbers in Acess

    it is saying it is missing a closing parentthesis
  4. L

    Sorting House Numbers in Acess

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

    Sorting House Numbers in Acess

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

    Help with d/b table setup

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

    Can MS access handle this many entries

    perfect, cant believe i didnt think of that :)
  8. L

    Can MS access handle this many entries

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

    Can MS access handle this many entries

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

    Can MS access handle this many entries

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

    Can MS access handle this many entries

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

    Can MS access handle this many entries

    with job number in both tables?
  13. L

    Can MS access handle this many entries

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

    Can MS access handle this many entries

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

    Can MS Access do this?

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

    Can MS Access do this?

    and the engineers can do that in the field?
  17. L

    Can MS Access do this?

    thanks for that nigel. i will take a look at it tomorrow and let you know how we go on. to give a little more detail: we are sub contracted by the UK owner of electrical meters cablings going into a dwelling. a previous engineer had incorrectly copnnected all the meters in a certain town (i...
  18. L

    Can MS Access do this?

    thanks nigel, i presume then that this was something that was set up for you? if so who did it and the cost implication? my only other option is that the engineers complete paper forms upon each visit and then they are inputted onto the central database. time consuming i know, especially...
  19. L

    Can MS Access do this?

    banana, thats what i was thinking. for a complete database novice, but with some time on my hands before we have to get this thing live.....is it achievable to set up the access database and program the pilots? i am able to learn software pretty quick......but is this just asking too much...
  20. L

    Can MS Access do this?

    is there any other software that may have this capability? are we looking at thir party software? i see gas companies etc when checking meters using palm pc's, so this must be possible. perhaps this is software that has been written for them specifically?
Back
Top Bottom