Search results

I need a query so to split the date 18/01/2023 to day=18 , month=01 and year=2023 within query. Can anyone help?

Not really hard to add an extra column? :( Means that you didn't understand what exactly is the issue..! Anyway, thank for your interest.. (Please read all the communication with theDBguy and MajP..)

Really thanks for this update. Everything works fine..!!

Thanks. Your solution working fine but another one think if you have time please. Is it possible after the double click event on Listbox to open each current file? Thanks again for your time

Private Sub lstFiles_DblClick(Cancel As Integer) fShellExecute Me.lstFiles End Sub Thank again

Hi, unfortunally the same issue. Just let you know that i'm using the following code to call the function... Public Sub cmdDoSomething_Click() On Error GoTo ErrHandler Dim strFiles As String Dim boolVisible As Boolean 'empty list first Me.lstFiles.RowSource = "" Me.txtCount.Visible =...

is it possible for you to modify the above code as it must be? Thanks

It doesn't works because the listbox has just one column and the name is embedded (includes also the path and file name )

I prefer just not see the path (only the filename in the listbox)

Hi, I found the following code here in the our forum (special thanks to the writer thedbguy) buti'm trying to modify them in order to fill the Listbox only with file name without the path. Following is the code and i will be glad if someone can explain to me how can i do it. Public Function...

Could you please explain me where exactly is the problem ?

Hello, I'm trying to create a function so to copy from master folder another subfolder into C:\Program Files (x86) but i have some errors. First of all following is the function Public Function CopyFolderAndSetPermissions(ByVal sourceFolder As String, ByVal targetFolder As String, ByVal...

i just save the inno script file with the name CreateMasterFolder.iss which includes all the lines so to create the folder into path C:\Program Files (x86)\MyApp . What i need now is a vba code to open the above file within access..

I used the Inno Setup and already i created the following code in order to create successfully the master app folder into C\Program Files (x86). The Script file name is CreateMasterFolder.iss. Now the problem is how can i open this file using vba code into DB?

I tried to use the following batch file without result @echo off title folderpermission icacls "C:\Program Files (x86)\MyAPPP" /inheritance:r /grant Administrators:TRUE echo "Done!"

Any idea about which installer program is best for that?

Hi, is there a way to give full permission to my C:\Program Files (x86)\MyApp full permission using vba? I'm asking this because i don't want the user to see what i'm doing during the installation on PC thanks

1000 thanks..!!!

i did the copied correct..!! Stil having the same error

Hi, thanks, Maybe i made something wrong ? Dim dtLastDate As Date dtLastDate = CDate("#31/12/" & DatePart("yyyy", Now()) & "#") MsgBox dtLastDate