Search results

  1. creativefusion

    [access 2002] - report generation

    Hi All, I have a fully interactive 2002 ADODB driven database with 5 reports attached to parameter queries. I have a form called "UF_REPORT_SELECTION" with a combo box named CboReport. In simple terms, I want to allow my user to do the following: 1. Select any of the five reports from the...
  2. creativefusion

    VBA Update Recordset Loop

    All, I have a table of data containing 30 fields updated every morning by operations. For the purpose of providing some background to my problem, I will provide samples for 3 of these fields. Feild 1: ITEM Field 2: STATE Field 3: UOM My problem is that some of the UOM's recorded by the...
  3. creativefusion

    Convert Percent Value to Number Only

    Hi All, I have a list box that contains multiple records with 3 field values. Value 1 = Integer i.e. 1234 Value 2 = Text "NO NAME" Value 3 = "87.34%" On the double click event of the list box, I populate the above three values into seperate text boxes in the user form. These values are...
  4. creativefusion

    List Box Selection

    Hi All, I have a form that contains 9 list boxes. Each list box name contains Pod and a unique number. As Pod1, Pod2, Pod3 etc.. Each list box is populated with RefNo and StateCode Now, I need to write a function that identifies the above 2 values based on the users selection. So when the...
  5. creativefusion

    Convert Neg Values to Positive

    Hi All, I have a field in a query called TOT_DMD and it has all values displayed in negative numbers. I want to display them all in Positive numbers. Can someone help me with converting them all to Positive numbers? Thanks CF
Back
Top Bottom