Search results

  1. A

    Numbering in a recordset or Query

    Yes I can work with vba, recordsets and sql, although I can say I am a beginner. Would like my function to be able to start a count everytime a new code appears as in the example. Thanks
  2. A

    Numbering in a recordset or Query

    Hi All I have a Query which returns records that look something like this: Code QuantitySold Number 102 98 ? 102 110 ? 129 2 ? 129 78 129 67 Now in the recordset as you can see there are codes that can come...
  3. A

    Exporting to a Text Document

    Thanks guys, finally managed to do it in a somewhat unorthodox way. this waht I did. It works but dont think it is the best way cos you have to repeat the process for each field or column that you add into the file. Dim rst As Recordset 'DoCmd.OpenQuery "On Hand" Set rst =...
  4. A

    Exporting to a Text Document

    Please may you please help me on this one. Have a query that I want to output to a .txt file and also define the field lengths and put leading zeros in one of the fields if the data does not fill it up. Would also like to format these fields by justifying them as well, eg left right...
Back
Top Bottom