Search results

  1. M

    Copy record data to another table through form

    Hi all, I have a form with 2 subforms, each based on their own table. One displays categories of invoices (e.g. rent, electricity, etc.) including some details like monthly costs. I would like users to be able to select one of those categories and copy this to another table, after which they...
  2. M

    Problem exporting form to another database

    Hi all, I'm trying to export a form to another database. I've tried both simply copy/paste and using the export function. In both cases the form is copied to the other database, but my buttons go missing. Is there a way to move the form to another database and keep it intact?
  3. M

    Cascading combo boxes working yet not working

    Hi all, I'll try to explain this as clearly as possible: I have a database consisting of 4 tables, each containing items of a certain type. I also have a 5th table which is a join table, because different combinations of items have specific properties (e.g. 1 item is 50 cm long, the other is 60...
  4. M

    DLookup without criteria?

    Hi all, I've never used DLookup before and I can't get it to work for me so far. I have 1 table which contains products and different properties of each product, such as the weight of the product. I have created a query which sums the weight of all products, but only for those that have a...
  5. M

    Limiting order amount based on available stock

    Hi all, I have an inventory database with a few tables: 1 with product info 1 with customer info 1 with incoming stock 1 with outgoing stock (orders) I also have 3 query's: Total incoming stock per product Total outgoing stock per product Total current stock per product (based on the 2...
  6. M

    Limiting table input based on variable values

    Hi all, I'm quite new to Access and am just working on a little practice database where I keep track of sales of a product. Basically I have a table keeping track of the different types of products, a table keeping track of customers, a table for orders and one for replenishments of stock. I...
Back
Top Bottom