Search results

My 2 subs are linked by part number. I have uploaded a version of the database. frmIssue is the one in question, I have it opening up right away. InventoryID in use is 001-2250. After you enter a Batch ID after the Item, I want that record to also be selected on the bottom, but still showing...

Sorry that was a bad choice of words. What happens is in sub1 you choose an InventoryID and the bottom subform pulls up a list of all the different batches of that InventoryID that we have. For example.. Batch Qty 2301 5 2380 15 In sub1, you are also required to enter in a...

Hi, I have a subform Where you can choose InventoryID (2nd sub automatically shows records related to that InventoryID), and then select the correct PurchaseOrderDetailID. The 2nd sub shows only instances of that InventoryID and when you select the PurchaseOrderDetailID in the first subform, I...

I just started getting the error "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data". This query has been working fine for the past probably 3 months. This query along with a few others are giving me the same error message. Any fixes...

There we go, I got it working. Thanks so much for your help!!

Great. I might need a little help on this one. I just created a query "qryPartsPerOperationNumber" that looks at a couple tables at what has been checked out to what operation number. Now for the DCount.... Private Sub OperationNumberID_BeforeUpdate(Cancel As Integer) If DCount("*"...

I have a screen "frmIssueNew" where we issue parts from our parts room to trucks being built. Parts get issued to an Operation Number in the truck. Currently there is no way of limiting which operation number the inventory items go to. for example... They could issue Wrenches to operation number...

I am wanting to use an Append Query to append records from one database to another. I am having problem with deciding on criteria to append only the records that haven't already been appended to the second database table. Query: IssueQuantity InventoryID Cost PurchaseOrderDetailID Job ID...

Thank you! Greatly appreciated

Hi all, I have a form, frmIssueNew, that has 2 subforms in it. Subform1=IssueDetailSubNew, Subform2=FifoStock. IssueDetailSubNew has relavant fields of PurchaseOrderDetailID, and IssueQuantity. FifoStock has PurchaseOrderDetailID, and AvailableQuantity. Basically, I want to stop a person...

Just realized I could probably use a DLookUp...

Yeah, I already have a query that does that exact thing. I want to be able to show this cost in a form.

OK, so I have a query that shows me my last purchase. This is called qryLastPurchase. Basically it shows me the price for the last time I ordered each item. I want to be able to show this value in a Purchase Order form. When you select a product that you want to buy, that price needs to either...

Hello all, I know how to filter 2 combo boxes in a subform, but can't figure out how I would filter a combo box in a subfrom from a text box in main form. I have a main form "frmIssue" with a "JobID" text box. My subform is called "frmIssueSub" and has combo "OperationNumberID" and "JobID". I...

Thanks to both of you!

Hi All, I've been trying to figure this our for awhile and can't seem to catch where I'm going wrong. I have these tables... tblPurchaseOrder PurchaseOrderID (PK) PurchaseOrderDate tblPurchaseOrderDetails PurchaseOrderDetailID (PK) PurchaseOrderID (FK) InventoryID PurchaseOrderQty...

Just to clarify, I would like to have a copy of the locked in price that was quoted, and an up to date price.

I am working with an inventory system. I have a form that creates current cost of final product (Labor+Material). This form is linked to the inventory table, where the prices of material get changed quite often. I was wondering if there was a way to save the "quoted" prices, as they will be...