Is there a way to change a value in another form/table from a different form? For instance, I have a form called customer invoices. When the user is finished entering a part number I want to open the inventory form and deduct the quantity of the part number from inventory based on the quantity...
Does anyone know how to make a control array in vba? I have a series of 14 part numbers that I need to manipulate through a loop. I know how to make a control array in visual basic just by naming the textboxes the same name. It always produces a popup menu asking if you wish to create a...
I have a form frmInvoice. After entering all of the info in the form and printing it I need to move on to another blank form. When I go to the next form (with the little arrow for navigating) all of my previous info is still there. I would like to use a command button to go to the next...
I am new to Access so please don't laugh, but I am having problems with a simple invoice form I created. I have it set up as a series of textboxes: Quantity, UnitCost, and TotalCost. Quantity is formatted as a general number, and the other two are formatted as currency. I have it set up...
I am having problems creating an invoice number the way my boss wants it. The first part of the invoice number should be the current year. The second part should increment by one. The way she wants it to look is: 2002 - 0100 I have no idea how to make it do this. By mistake I have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.