Recent content by cesarelias

hi Pbaldy, Thank you so much for helping! cesar

Hello, I have the bellow code, I need put in the table the missing lngNumber. How I do that? Tabdados = table cód = ID I want to query about the record missing. thanks cesar Public Sub MissingNumbers() Dim rst As DAO.Recordset Dim DB As DAO.Database Dim strTable As String...

hi, I managed to create the code to rename files with other extensions to txt files, through another code I found here in the forum. I am leaving here the code to help others who need it thanx cesar Private Sub Comando100_Click() ChDir ("C:\ajustetxt\") Dim stNewName As String, stOldName...

hi Dhake, I have several files extd11110001.ret, 'extv11110003.ret and extv11110004.ret etc. I want to rename txt file. I tried the name statement above, but it get error. do you help me again? thanx cesar 'Private Sub Comando100_Click() 'Dim OldName, NewName 'OldName = "OLDFILE": NewName =...

Hi, Does anyone know how to rename a file.ret to file.txt. I tried this above code, but I get error. I Would to change extensions to txt several files automatic. One help would be great thanx cesar 'Dim strpth, strnewpth 'Dim strfile 'strpth = "c:\ajustetxt\" 'strfile = Dir(strpth...

Kiwiman, thank you for your reply. I managed to import using the "us-ascii" thank you very much. Cesarelias

kiwiman, thank your help I do not manage to import because "+" it is not recognized in the access. When I import it appears "???????" instead of "+" would you know how you will import in the symbols "+" e "-" without appearing "?????" at their place? I annexed the archive with the wrong that...

I've got a txt file I want to import using the Docmd.importtext but I first need to delete the following text string '+'and '-'. If I do this manually i can get it to work but I need to do it from VBA. I need to alter the text file into and then save it. the txt file...