Search results

  1. mdschuetz

    Working with Recordsets...

    The next part of this project is pretty technical. I have a question… Purchase Orders Subform Date Job Part Description Price PO GPC Requested Received Due Rejected Invoice Number 11/9/2007 222 2252 bolts $2.25 27 CAM 5 3 2 0 MOSL223224 11/9/2007 222...
  2. mdschuetz

    Input box question

    I am trying to use an input box value as a parameter to return values, it is comming back blank. If I remove the input box related code, it returns all values, so there must be an error with the input box coding. Can someone help me identify it? Private Sub cmdQC9_Click() Dim strINP As String...
  3. mdschuetz

    If statement bad?

    Can anyone explain to me what I'm doing wrong with this? I've been at this problem for over a week and its driving me mad. Nothing I try works. I have a subform within a form. This code lies in the main form on a command button cmdQC9 in an on_Click procedure. If a value greater than 0 is...
  4. mdschuetz

    Theory and Implimentation

    I need some advice. In my database I have a form. The form holds a subform. The form is tied to tblPurchaseOrders. The subform is tied to tblInventoryTransactions Inventory transactions captures specific information related to each purchase order such as quantity ordered, quantity received...
  5. mdschuetz

    Using a Command Button to export the value of a textbox to a specific cell in excel

    Is this possible and if so, can someone please post me a walkthough?
  6. mdschuetz

    Calculating Subtotal in Textbox from Results from multiple rows in subform.

    I have a Form, frmPurchaseOrders On this form I have an object txtSubtotal Also, this Form contains a subform which pulls applicable results from tblInventoryTransactions The fields in the subform are txtUnitsOrdered, txtUnitPrice, txtPartNumber, txtTransactionDate, txtItemDescription This...
  7. mdschuetz

    Hello, I generally just use search and can find help to what I am looking for ....

    However, this one eludes me. On a FORM, I have 2 Objects. A check box and a combo box. checkTax cboAccount I have checkTax set to: YES/NO I have cboAccount functions with a rowsource lookup: SELECT Accounts.* FROM Accounts; Here is the layout... 6100-0000 = NO 6200-0000 = NO 5430-0100 =...
Back
Top Bottom