Search results

  1. D

    Import Spreadsheet to Customer Table from a form and dialog box

    hi guys, I want to transfer data from a excel spread sheet to an access database, I want create a button saying import customers, a box opens up you select the file. the excel file is going to always be the same layout, example ( Name , DOB ) to accces database : Customers Field, (Name ...
  2. D

    Asking for Subdatsheet after adding extra relationship

    I have 2 relationships between 3 tables, Customer Table > Customer ID (pk) 1 Issues Table > Customer ID (FK) Many Complaints Table > Customer ID (FK) Many Each table has Customer ID as you can see, I have linked the Customer ID From Issues & Complaints table to the Customer ID field to the...
  3. D

    Foreign Key in a form

    Hi all, I basically have an Issue's table and a Customer Table relationship set-up. I want to information to be viewed in the Customer table however I can only see 1 Issue where as a Customer may have 2 or 3 Issues. I have come up with inserting the whole table into the form however I...
  4. D

    intergrating file servers in with database & networking online and offline

    Hi guys, I am looking to build a system for work that is going to be easy to use, as the system we have in work IMO is very complex and too long winded. as the process is quite straight forward. Basic Procedure OK. A large quantity of paper paper work is handed in to us every week...
Back
Top Bottom