Search results
-
H
Auto Duplicate Record based on QTY
Good day folks, I have an inventory DB that generates current inventory by comparing two tables, "Item Purchases" and "Returns". During the form entry of Item Purchases, I would like to duplicate the record N times, where N is equal to the QTY of items on the form. I would like to incorporate... -
H
Programming Languages used in Access
Hello folks, So far Access has proven to be a very powerful tool. I have enjoyed the learning experience. I do have a question regarding the different programming languages used in Access. How many languages are there? I've seen this: Public Sub MakeNew_Click() DoCme.SaveRecord... -
H
Copy fields to new record
Lovely folks, I would like to be able to copy select fields from one entry to the next. I have product return forms that can have an arbitrary number of items on it. The items may vary in serial number, asset tag number, and possibly product name. All other fields on the form will be the same... -
H
Solved Group By Name then Count on criteria of another field
Hello lovely people, I'm trying to Group By ProductName, then Count the ProductNames that are still pending an AssetNumber. InventoryTable ProductName AssetNumber ProductA pending ProductA pending ProductA pending ProductB 1234 ProductB... -
H
Solved Change record field using Form fields
Good day lovely people, Still getting familiar with the various Access Functions. Status: Intermediate Noob. I've built an inventory table that looks like below. The Order# is always maintained with the database record. Inventory Table: Product | QTY | Order# A ------- 4 ------- 1111...