Search results

I got it ! Thanks !

Yes I have tried , now I have to find how I can use format function with this Now() function

I mean time when I run query because I want to export that time to the txt file !

One question more ! I'd like to get right time in this format when I run query !

Now I get it ! Thaks for your help !

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

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

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

I changed it but ,the same error

I tried it and I get : Run time error 2498 ,An expression you entered is the wrong data type for one of the arguments

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...

Thank you , it was just what I thought ! Bs Timo

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...

Purpose is to retrieve data directly from a text file into Access, but before I did it in Excel, where the field is edited in a couple of which I can not do in Access a field A example 000500000 was changed to 500 and field B 22221111 was changed to 2222-1111. Bs Timo

I like to use one excel file background , do you have any example Bs Timo

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

The file is a ready ascii text file not imported from excel ?

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

If I name the file .txt it work ,how I can change file named .dat to name .txt using VBA

I tried this but I get on error, file cant import ? Function Makro1() On Error GoTo Makro1_Err DoCmd.TransferText acImportDelim, "", "taulukko", "F338H0EF.dat", False, "" Makro1_Exit: Exit Function Makro1_Err: MsgBox Error$ Resume Makro1_Exit End Function