Search results

  1. M

    Transfering A Spreadsheet To Access Table

    ok il try that
  2. M

    Transfering A Spreadsheet To Access Table

    Can someone please help me?
  3. M

    Transfering A Spreadsheet To Access Table

    hello i would like some advice so i do this correctly. I have a access database with a customer table. And a excel spreadsheet wih customer details. I wish to transfer all the excel spreadsheet customers into the database - customer table. The format of the customer table in the database...
  4. M

    Excel help

    ok thanks mate...u always come to my rescue. cheers
  5. M

    Excel help

    but what if i want dn7, dn9, dn21? how do i write it inthe autofilter box? as it wont allow me to put dn7*, dn39*
  6. M

    Excel help

    Hi there i no this is an access forum but i guess a lot of u guys r excel experts to. what i need to know is this... i havea spreadsheet with a list of postcodes e.g "DN14 4TH" and have been given the task of searching and extracting various postcodes. i Have to therefore find all the...
  7. M

    Access search

    thanks a great deal !
  8. M

    Access search

    Hi im trying to run a search in a query. I have a list of business names and i want to search for all the businesses with "manufacturer" in there name, what do i put in the search criteria for the query? please help!!!! thanks
  9. M

    Combo Box Not Workin

    Hi can some one please help me? i have a query that uses parameters...e.g dates and also a combo box where a person on a form can choose the relevant sector. I have made a button on a form which when depressed should run the query, but its not working? im not sure how 2 link it to the query...
  10. M

    ERROR message! please help

    cheers il try this
  11. M

    ERROR message! please help

    I have a table that keeps crashing. The only error message I get is "Invalid Argument". Each time, a single record will turn into "#Error". Each field says this in the row. When this happens, Access won't let me delete just that row, Any ideas how to delete them?
  12. M

    Invalid Arguement Problem

    i have a problem. The access database we use has been working perfectly on a query which asks for a set of dates to be entered. We have recently added more records and since i tried to run the query i get a statement geting back saying "invalid arguement" why is this? Can someone please help
  13. M

    Grouping Data

    How do i group the following records ID Surname Pack 29679 Minican 1 29679 Minican 2 27818 Oliver 1 27818 Oliver 2 27818 Oliver 3 so its will show ... 27818 Oliver 29679 Minican ... on a spreadsheet
  14. M

    Setting Out A Report

    Hey its worked out now thanks a lot neileg! your a pure genius!
  15. M

    Setting Out A Report

    Thanks I have changed the columns to 2 "down then across" but when in print preview it still displays it as one long column?
  16. M

    Setting Out A Report

    Thanks I have changed the columns to 2 "down then across" but when in print preview it still displays it as one long column?
  17. M

    Setting Out A Report

    Hi I have 6123 records in a database. I need a report that prints the Customer ID and the Postcode I have managed to do this but it comes to 196 pages! Is there n e way i can format the report so instead of it being like this:- Customer ID Postcode 2334 LS89 8UJ 2333...
  18. M

    Help With Categorising Postcodes! :(

    P.S About your question about partial postcodes.. some regions do have partial postcodes. The regions do not cover the whole of the UK just certain areas. The most complex a postcode can be according to my lists is e.g HD1 5, LS9 7 The majority are HD1, LS7 etc
  19. M

    Help With Categorising Postcodes! :(

    Hi Neileg Im not sure on a few things You said "Sooner or later you are going to need a table that defines your areas in terms of postcodes. I would expect this to comprise a record for each postcode (or partial code) with the area as a field in this record. Then when you need to extract...
  20. M

    Categorising Postcodes? Can Someone Help?

    Thanks brian for helping! The regions we cover are 4, there are the yorkshire and humber region i have a 4 regions each with 50 postcodes per region approx However in my database i have 3000 people so these need categorising. Could you talk me through the best way step by step?
Top Bottom