Search results

This one works pretty good for me : http://www.databasejournal.com/features/msaccess/article.php/3734331/Access-TreeView-ListView-Basics.htm

First : the code is a function. You can't put it in onLoad() and expect it to work. You need to call this function and store the result in a variable. Second : The function will convert strings from left to right (so basically reverse the string) which can be done simply with StrReverse. What...

But that function as a static list of illegal characters. The OP has a table who contains all the characters.

So for each record in SearchFor table search in TableX if the value is present ? Or in your own words : Dlookup whilst looping through the searchfor recordset It will be the fastest way. Or make one big condition (with a lot of 'or') and add that to the Dlookup.

From what i can find on the internet, you need more steps to add the distribution list in vba... (see https://msdn.microsoft.com/en-us/library/office/ff860361.aspx) I think you cannot just add a recipient "Test" and outlook will change it into a distribution list.

Well in the To field you have Test because this is your code : Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .To = "Test" <==== YOU NEED A...

My bad about the Like %%... I didn't know that having a customer Number=null was a common thing in a well designed database. Anyway, he can use isnull(shead.cust_no,'') LIKE '%%' to get all the null customers. (Maybe he can make the cust_no field a not null one ? That will solve a lot of...

Since you have at least 1 'LIKE' criteria, you don't need to add 1=1. Since LIKE '%%' will give you all the records. Just make sure that you start with that criteria. Than add any additional criteria to the WHERE. Example: Private Sub cmdStart_Click() Dim strSQL As String Dim qdf As...

f) you can use sharepoint. (but you need accounts for all the users...)

Also don't forget that you still need AND or OR between each criteria. I wonder if that SQL you posted actually works.

Why did you changed all the parameters of that function ? And why did you change the string into a long ? Is your query "qryForRanking" a number ? Maybe that is your main problem why it doesn't work.

You can do this in access. What you need to do is open the file from Access : Dim wrdApp As Word.Application Dim wrdDoc As Word.Document Dim filepath As String Set wrdApp = CreateObject("Word.Application") wrdApp.Visible = True filepath = "C:\...\YourDoc.docx" Set...

Maybe you can follow this : https://bytes.com/topic/access/insights/951897-inactivity-detection-access

Since you are 'beginner/intermediate' I guess you tried something already ? If that is the case maybe you can show us the code and we can help you fix that. are the choices in a list or just buttons ?

Do you see the signature when you display the empty email ? You must enable the default signature in Outlook first. (See : http://stackoverflow.com/questions/8994116/how-to-add-default-signature-in-outlook)

I just pointed that you don't need a new field in your table. That was all :)

If you use the code above, that rank in class is calculated on the fly. No need to save it or add extra code.

You cannot mix block syntax and one line syntax : https://msdn.microsoft.com/en-us/library/office/gg251599.aspx When the there are more than one line between the if else it is best to fully use the blocks

Well what you tell here : "But sometimes we get codes from the company that are without "/" e.g CW21904 so in that case the table field will store CW21904 but when the form is loaded then it gives me AK280416/1 in the DocCode " is correct when I look your code. if there is no "/" : j = 1 Then...

Like JHB said : move the DoCmd.Close to a new line... If Isnull(ClientName) Then DoCmd.Close Else .... End If