Search results

  1. G

    Mode function using WorksheetFunction produces error

    If I use ?WorksheetFunction.Mode(Array(1,2,5,8,12,13,1,1)) it works OK, but the following function gives the Error "Unable to get the Mode property of the Worksheetfunction class". Function Mode(strString As Variant) '?Mode("1,2,5,8,12,13,1,1") Dim VarOut As Variant VarOut =...
  2. G

    Using an Option Group to control a Loop produces error

    I have a form with unbound fields and using an option group (gStartStop) with two buttons, Start/Stop, I want to control the execution of a DO WHILE loop where a series of actions are performed, including action queries. Code of the option group: Private Sub gStartStop_AfterUpdate() If...
  3. G

    Recursion or too many records lead to "Not Responding"

    Using Access 2003, the following snipset produces 3.628.800 records. It is actually a permutation procedure, in this example, call GRListWords("", "ABBREVIATE", 10) 10 letters to form all possible words in groups of 10 letters. My problem is that I can not get them into a table - execution holds...
  4. G

    Passing a boolean operator string to a stored query

    I have a stored query. I want to run this query via a button from a form and pass a boolean such as "6 OR 8 OR 10" that is in a txtField on the form. So, I put in the respective field - in the design grid of the query this: [Forms]![Form]![txtField] and in the button: DoCmd.OpenQuery Query...
  5. G

    format decimal places in a continuous form

    I have a continuous form with a currency field (price) that I need to format it to 4 decimal places if it is less than 1 and to 2 decimal places if it is greater than 1. How difficult can this be? iif(int([me.price])=0,Format([me.price],"#,##0.0000€"),Format([me.price],"#,##0.00€"))However, the...
  6. G

    Why my Exit event fires twice?

    Hello all, The following modules are from a Continuous Forms view form. I want to check the TSTATUS and if it is 'S02' to provide the option of selecting a Vendor from the TSinfo. Then I want to check again for a null value, allowing however the option of a null value, if the user exits TSinfo...
Back
Top Bottom