Recent content by dmarop

Hello, Thank you for your reply. The problem is solved. Regards, Dimitris

Hello, I will need your help. I have a database is Access 2016 and I have put the add-on Chilkat FTP 3.0.0. I am checking if there is the particular name file in a specific ftp folder with the following code: Imgs = ftp.GetCurrentDirListing(strImgName & "*.jpg") Imgs = Replace(Imgs...

Hello, Thank you for your answer. The user name and password are correct. What may be the problem? Thank you

Hello, I will need your help for the following. In Access I am sending emails with CDO and I take this error: Run-time error '2147220975(80040211)': The code of CDO was running great in windows and access 2007. From the moment I installed windows 2010 and access 2013 it is not working. I...

Thank you for your answer. I want to ask something about the Case 3734,3045. When the code gives me these errors in Insert what will doing the code? It will try to add the data or will go to the next? I will lost the data? In that case can you tell me what the code will do? Regards, Dimitris

Hello, I use the following code to add data in the table MyTable. I am checking if exists and if is not exist i add it. Sometimes i take the error messages 3734 or 3045, that the database or the table are busy. In the specific table write and read and other users. If Nz(DLookup("[ID]"...

Thanks for your reply. The outlook does not sutes me. That's I want is to read the mail from access and to use it in a part of automation. Can you tell me if this is possible and to give me an example how do to it?

Hello, I will need your help. I want to read mailbox with vba (not with outlook) and to read the emails in access. From the search on google, i found only how to send mail with vba. I can't find how to read mail with vba. Can you help me plesase? Thanks, Dimitris

Thank you for your answer. I want to check a directory that it is in a web server, if the file exists and not in the local directory of the pc.

Hello, I will need your help. I am using the following code to check if a file exists in an ftp directory. If i make the check in a local directory the code is working. Sub DirFile() Dim fso As New Scripting.FileSystemObject Dim sFile As String ConnectionFtp 'make login in an...

Hello, I will need your help. I want to use the following code as a part of a module. Dim message As String, Title As String Dim myValue message = "Select Category" Title = "Category" myValue = InputBox(message, Title) That I want is the user to select the value from...

Hi, I don't want with the method of Click in button. I am running a loop from a Module and i want in a point to make a check if the form is open or if is not to open it.

Hello, I will need your help for the following. I have two Forms and i want when the code is run to check if frmMain is open to make it focus and if is not to open it. I found the code below but it is not working. If CurrentProject.AllForms("frmMain").IsLoaded Then...

Hello, Thank you for your answer. Can you explain me what you mean that it is with my own risk? What I have to do I don’t understand.

Hello, The code is : Sub GoToWebSite() Dim IE As Object Dim sURL As String sURL = "www.mysite.com" Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True IE.Silent = True IE.navigate sURL Do DoEvents Loop Until IE.readyState = 4...