Search results

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...