Search results

  1. S

    Update form based on query

    I have created a form based on a Query. I have a text box which is the source for the criteria of one of the fields in the query. When I enter data into the text box it passes this to the query criteria. I know this works because if I open the query by double clicking on it the records are...
  2. S

    Northwind Explanation

    Products: Code (every different item has a unique code I allocate) SupplierCode (the ordering code of the supplier) Category (Lookup from the Category table) Supplier (Lookup from the Supplier table) Description (A brief comment on the item) Suppliers: Details of the wholesalers I buy from...
  3. S

    Northwind Explanation

    Following your advice I am off to the Amazon site today to order a book. I will look through the reveiws and decide what will work for me best. After reading through all the advice, articles and threads people have sent me from this discussion I think I have the basis of a plan. I will have...
  4. S

    Northwind Explanation

    Thank you very much for taking the time to help me. I will take a look at the file tonight and see if I can pick anything up. I sense a trip to the Amazon site site to get some more reading material ;-)
  5. S

    Northwind Explanation

    Thanks for the tips Pat. Unfortunatly I can't look at the the site you found on Google as it asks me for a username and password.
  6. S

    Northwind Explanation

    I have managed to accomplish quite a bit from my standing start. I have imported my products data from Excel and have 2 other table for catagories and suppliers. The main stumbling block for me is getting a form to reduce my stock level by the quantity sold and to write to another table the...
  7. S

    Northwind Explanation

    That is excatly what I want as I want to be able to understand the database that I build rather than just use one someone else has written so I can make it do (with time) exactly what I want. Unfortunetly there are no suitable examples in the examples section.
  8. S

    Northwind Explanation

    I haven't modified anything in the database, so no. Is that something I have to do? I would have thought as a sample database all those sort of things should have been done already. Does anyone know of a database similar to the Northwind one but more to do with retail point-of-sales rather...
  9. S

    Northwind Explanation

    I am still trying to get started making a database to control the stock for my new jewellery shop. After spending 2 weeks getting nowhere fast I have gone back to the Northwind example database to see if I can pick up any ideas. Can anyone explain why when I create a new order using the orders...
  10. S

    Shop database Help

    Yep Now I am beginning to think I may be really stupid because I can't see a form that does what I require. Could you point me in the right direction please.
  11. S

    Shop database Help

    Hello All, As a virgin member of the Access World Forums board and a new Access user I am trying to get started creating a database to run a stock control system for my recently opened jewellery shop. I started off by recording all my data in Excel so I have several workbooks containing each...
Back
Top Bottom