Search results

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...

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...

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...

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...

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...

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...