Search results

A belated thank you for your reply

Dear All I want my access database to store information about "tests" and "products" that are in each "test". So "tests" is the "one" and "products" is the "many" (each test has many products) My client needs to routinely send me lists of tests and the products that are in each test. I then...

Dear Jeff, We are using Sharepoint 2013 Yes, the appropriate licenses and Access services is installed and configured correctly on the server Appreciate your help Many thanks, Alex

Thank you very much for the replies I only have Access 2013 installed. Sorry not sure of the details of the Sharepoint that we use. I just know that my IT collegues want me to use Sharepoint instead of writing it as a desktop database and won't support a desktop Access database if it is used...

Dear Forum, I want to create a small relational database in Access 2013 and then publish it on to sharepoint. I want to be able to set up table relationships and design my forms etc I found an article that explained how to build and publish to sharepoint using blank web database template in...

Thanks The database is empty now, but when I get going, the data will enter via forms. I would ideally like to have the project identifier with the test autonumber all as one. Would concatenation on a query be the best approach? thanks agin, Alex

Dear Forum, I am creating a database that has the following tables linked with a one to many relationship. one PROJECT to many TESTS. So, each project has many tests I want each test to be numbered in such a way that it indicates which project it is from....e.g. Project ABC: tests...

Thank you all for your help The reason for the indeterminate join I think was a problem with how I had set the indexes. I think I have managed to understand and sort this out now. However, I do not understand the indexes view on the design tab and how to use it. Particularly for my compound...

Dear Plog, Thank you very much for your reply. If I remove the ProjectID from the Product table and then try to link the field TestID between the Test and Product tables, I get offered an indeterminate relationship, whereas I think I need a 1 to many relationship? See attachment Am I...

Dear Forum, I am about to set up a database but wanted to check the relationship of the main tables before I add to it. I have attached the relationship design For a PROJECT, there can be many TESTS, for a TEST, there can be many PRODUCTS Is my design reasonably sensible? Would you...

Dear Forum I am very pleased to join up. I am a strong advocate of using Access in our department but am a little alone in this regard - but think it really helps organize what we do I really like working on Access but am largely self taught and so need to know lots more to get the most out...