Recent content by smig

Thanks I'm trying to use the ftp.exe window now I manage to connect to the ftp server, but unable to upload a file. the file will be created empty, and I get an "425 no data connection" error

Hi I'm looking for code to upload files to FTP or WEB disk (I can create them both) If it's a WEB disk I don't want to map it in any way, just put the files in it Thank you

You are correct that you need to do a .MoveLast to get the real .RecordCount number but you can just use it with no moving just to make sure there are any records in the RecordSet

Thanks for your time But nothing can explain why it jump back to the start of the subroutine, just after it show the "_TEST_XXX - errHere" msg and the Error (Sec. 5) rather then showing "_TEST_XXX - errHere 2" Also why will it go back to start, again, after it show the "ExitHere" and Err=0 (No...

I run this routine only. I made it as a SUB to run it directly. Not calling it Also, it should Exit sub after not going back 0:14 - Exit Here 0:14 - Err 0

Can you explain this loop, in the attached video ? Error in open db The path for the strFileName is wrong I run this routine only. I made it as a SUB to run it directly. Not calling it Here is the VBA code Public Sub TEST_XXX() On Error GoTo errHere Dim strFileName As String Dim...

Tישמ The "Clear after error" can't go another place it is to reread public vars that where lost by the error the problem is the code is getting stuck and constantly (On Office 365 machines, not mine) on this msgBox

After this MsgBox (I click OK) it show it again.... and again.... and again .... :( The code is get stuck showing the same MsgBox (Won't show _2_ I guess this is what filling up the stack space but why ???

Let me be more clear After this MsgBox (I click OK) it show it again.... and again.... and again .... :( The code is get stuck showing the same MsgBox (Won't show _2_

no. no query sngDataMDBVersion = fnGetDbVersion(pbDataPath & "\" & pbDataFileName, pbDataFilePass)

sngDataMDBVersion = fnGetDbVersion(pbDataPath & "\" & pbDataFileName, pbDataFilePass)

I have a function that I put some MsgBox in it trying to trap an "Out of stack space" error Public Function fnGetDbVersion(strFileName, strFilePassword) As String On Error GoTo errHere fnGetDbVersion = 0 MsgBox "_fnGetDbVersion - 1" Set DataDB = OpenDatabase(strFileName, False, False, "MS...

Im developing in AC2016 and need the app to run on office365 Are there any limitations I should be aware of?

I tried reversing to = Didnt work. Wont even work for LIKE. Actually it will error for the first fc (i=3). This realy put me into the conclusion that this error has nothing to do with the number of the fc perse In this situation using the wizard cant be done, as i want to let the end user set...

No I did not see it before, so i didnt try before. Now i tried it and found it to be the most mystery bug I ever saw 🤣 If i start on 3, as suggested it wont even work with LIKE. It will error on i = 3 But why do we need the cf at all, if we can simply use the Paint event ?