Recent content by creativefusion

Hi, Thanks for the advice. I am struggling with the following: 1. How do I fill the combo box with the list of reports 2. How do I collect the parameters for the query attached to the reports On item 2, the reports are based on 1, 2 or 3 reference numbers. So, when the user clicks view...

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

Banana, Your suggestions are great. Managed to do it with two steps. Part 1 to get the unique UOM for the item and Part 2 to Update. All is well. Thanks once again. Kind regards, CF

The records are captured daily (automatically) from a query that extracts the data from another system. When I say first record, I mean that for each ITEM, there is only ever 1(one) UOM. Never anything else to your reference. So, the way I was intending on making this happen was firstly...

Hi Banana, Thanks for the reply to my problem. I tried to use your method but unfortunately it appears it will not work. As I said in my first post, I have a table that looks like this. REF | STATE | UOM 233 1 " " 233 4 "CA" 233 7 " " I need to find...

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

G'idday GalaxiomAtHome, Works a treat!! Thanks muchly and enjoy the rest of your weekend. SJ

Thanks for the suggestion but unfortunately this val function does not fix my problem. The code is still collecting "1.84%" when the update button is clicked.

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

Hi Paul, Thanks very much for your help. The reason there are 9 lists boxes is because I have 9 shipping ports to discharge product into. My application lets users build multiple shipments for various ports. So, each list box displays all the products that are planned for shipping into each...

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

Thanks Galaxiom. Works fine. Have a good evening. CF:)

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