Search results

Nothing will happen if the file is not exists. Check that first and make sure the path is written correctly.

You can write it this way also : Shell "explorer.exe" & " " &"c:\windows\notepad.exe" &, vbNormalFocus No popp ups.

Is there any worries from using APIs?

Hi @Pat Hartman I'm still at the beginning of the journey. :) I recommended using this procedure for two reasons, firstly because that he requested not to use the Shell function, secondly I tested it and it does not fire alert messages. and I did not pay attention to the issue of IT men

You can use this code also : Public Declare PtrSafe Function FileProtocolHandler Lib "url.dll" _ Alias "FileProtocolHandlerA" (ByVal hwnd As Long, ByVal hinst As Long, _ ByVal lpszCmdLine As String, ByVal nShowCmd As Long) As Long Public Sub OpenHyperlink(ByVal Url)...

I use this function to replace the symbols from the path or directory by any character you want. Public Function RemoveSymbolsFromText(strGivenTxt As String, Optional ReplacmentTxt As String = " ") As String Dim Txt As String Dim R As String R = ReplacmentTxt Txt = strGivenTxt Txt =...

Try this one to extract Numbers from the text Public Function ExtractNumbersFromText(strText As String) Dim x As Long Dim L As String Dim r As String For x = 1 To Len(strText) L = Mid(strText, x, 1) If IsNumeric(L) Then r = r & L End If Next x ExtractNumbersFromText = r End...

It works in both ways. This is the row source of the combo box : SELECT DISTINCTROW ComboList_T.ComboList FROM ComboList_T LEFT JOIN Subjects_T ON ComboList_T.ComboList = Subjects_T.Subject WHERE (((ComboList_T.ComboList) Not In (select [Subjects_T].[Subject] from [Subjects_T] where...

Okay Mr. Pat , lets use the same technique but in a sub form this time. See what we got :

hello @Guus2005 I used Camtasia Studio to record and edit videos. No, I'm good in this ;) Thanks!

Hello @fliu2265 I have done some thing similar before, Any item selected Before disappears from the list. Check this : The demo is attached below

Try This Milad Just be aware of "SavedUser" table should be a local table in the Front End Copy not in the BE .

Hello every buddy.. This is my first post in here. My name is Moosa Al-Kalbani and I am an Access database designer. Today I am pleased to present to you this unique and wonderful gift 😊 (Smart Domain Functions Builder) Dloockup, DCount, DMax, DMin, Dfirst, DLast , DSum, DAvg This legend...