Search results

  1. T

    Format date when exporting

    Hi ! I like to change the day value looking like this when I export it to txt file day examble 22.4.2010 15:46:58 should be like this 100422154658 I tried many times but not get it ? Br Timo
  2. T

    Problem to import all from textfile

    Hi ! I'm trying to import from text file like this ;000000000375000000;USD; ;000000002000000000;USD; ;000003000000000000;EUR; Why I can't get that marked as red ? Br Timo
  3. T

    Query show empty value ?

    Hi ! I have this kind of formula ! IIf([Hoitotili2]<>"51";IIf([Hoitotili2]<>"52";IIf([Hoitotili2]<>"61";IIf ([Hoitotili2]<>"62";"EUR";[Ulk os maa])))) I get only value EUR ,if value is examble 51 I the result is empty, not the value from field "Ulk os maa" Bs Timo
  4. T

    Exporting to txt problem

    Hi ! I'd like to export to txt by choosing path and name ! I have done this but it doesn't work ? What is the problem ? Private Sub komento32_Click() Dim wpath As String wtaph = InputBox("Anna polku ja nimi tai OK jolloin voit valita polun") DoCmd.TransferText acExportDelim, "", "taulukko...
  5. T

    Export to excel

    Hi ! How I can export to excel by selecting place an file name , I want that access ask path and filename ? I have done this but it work only if there is a excel file name ! Private Sub Komento5_Click() 'Function exportXL() Dim stDocName As String DoCmd.SetWarnings False...
  6. T

    Running excel background

    HI ! Is it possible to drive excel in the background without seeing it (hidden) ? Bs Timo
  7. T

    How to change number value

    Hi ! I have imported textfile and the numbers are like 500000000 but it shuold be like 500,00 how can I correct it ? Bs Timo
  8. T

    How to import textfile

    Hi ! How to import textfile named examble 123.dat to the access sheet ,I have tried with access ready macro import tex but it doesn't allow import file named .dat ? Bs Timo
Back
Top Bottom