Search results

Hello! I am making a stock and orders database and I need some help with calculating the totals. I have a table called Orders, as well as a Parts table (among others). I have the Quantity On Hand of each part listed in the Parts table. When we receive an order (indicated with a tick box on...

Hi I'm completely new to Macros (and pretty new to Access in general). I was wondering if anyone could help me to set up one. I am wanting to update a field in my table automatically when I input information into another field in the same table. The information needed for these fields is stored...

Hello, I was wondering if there is a way to start typing the part name (on the right of the combo box), rather than the part code and have the database find the part I am looking for. I would like it to be stored as the code but searching for the part by name is sometimes much easier.

Hi I'm wondering if there is a way to add text that is not included in the drop down list (from my other table) without first adding it to my other table. I ask as we have one off parts which would not be needed to be used again. I think the answer is obvious but I thought I would ask before...

Hi, I'm new to Access and I was wondering if it is possible to select an item multiple times on a drop down list on a table (where multiple items will be selected). Or if this is not possible, I would like to be able to write in the box the quantity of the item needed. Any help would be appreciated!