Recent content by barien75

  1. B

    export and transpose problem

    The tables are, but running a query to pull the different data for one applicant. Lot simpler to read the data vertically when sent for review. Already figured out a way to do it.
  2. B

    export and transpose problem

  3. 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...
  4. 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...
  5. B

    Trouble with VB script on a Form

    Totally strange, I had tried that and Access wasn't allowing me to do that. Now if enter that it works.
  6. 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?
See more
Back
Top Bottom