Search results

  1. B

    export and transpose problem

    I am trying to export an query into excel and then transpose the data so it is vertical instead of horizontal I have it mostly working except when try to do the transpose it give me an Rune Time error 1004, PasteSpecial method of Range Class failed. If anyone has any idea where I am going wrong...
  2. B

    SQL in module not giving correct result

    Don't See why this won't work when want to omit these two values, seems to only omit one of the values Case "68" Forms.FrmBuilder.TxtHoldValue2.Value = "AZ" Forms.FrmBuilder.TxtHoldValue3.Value = "321" Forms.FrmBuilder.CboMaterial.RowSource = "SELECT...
  3. B

    Trouble with VB script on a Form

    For some reason when run this I get an error. It seems to be when it hits the rounding function as when I comment it out it works fine. Any ideas what I am doing wrong?
Back
Top Bottom