Search results

  1. K

    TransferSpreadsheet not Updating Table

    It might help if you do a refresh of your table before you run the update query.
  2. K

    macro to handle 2 actions at once

    I made a form where I enter new products and info about it. I made another form where I enter the place where the product must be stored. Each form has it's own table. The two tables are connected with an update query, to copy the number and the name of the product from the product table into...
  3. K

    Simple inventory tracking database.

    I work at a small belgian company, helping with synthesis and organising the inventory of our chemicals. I made my own database for it. It has functions like adding or removing amounts of a product on date by it's order number, counting the value in stock for each product, and for the whole...
  4. K

    Having problems with a form, should be easy

    Hey, I'm writing a database to keep track on the inventory. Now I have a question about a form used to add or delete certain amounts of a product. My main form is based on a table containing the information of a product. It has a combo-box to select products by ordernumber, and text boxes that...
  5. K

    form/table linking issue

    Hey, I'm writing a stock database. Therefor I have a table with product info (primary key is the order number). I also made a form to add new products. I made a new form where I can put amounts of incoming and outgoing products into fields. A query is needed to calculate the amount in stock of...
  6. K

    how to get dynamic sum

    Hey, I made a table Products: order number (key), name, supplier, price,... I copied it into a query, and made a form of it, so I can look up products by order number with a combo-box. Now I'm into my next step (and it gives me a headache): In the form I added a new text box, where I should...
  7. K

    how to lock a form for changes?

    I made a table containing information about products (price, amount, supplier,...). The most inportant info is the order number (cause it's unique). Then I made a form, containing a combo-box and several text-boxes. The idea is to find a record using the combo-box, and vieuwing the information...
Back
Top Bottom