Search results

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

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

thanks billmeya cheers.

I think I have found a method, if I right click on the table, and choose Sub-form it gives me an option of datasheet, or Form... The form look is what I like and would like to stick with however is their a way to keep it as form look as default?

Hi yes that's correct sorry for not expressing it clear enough, Form is ( Edit Customer ) The sub form from the issues form was created automatically when I dragged the table in the form, how ever this this does work for me, as I can see more than 1 issue (if more than one exists) how ever...

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

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