Search results

In that case your SQL is not correct. Do you have in the table tblTest an ID of the question ? If that is the case, then this would work beter : SELECT tblQuestions.ID, tblQuestions.Question, tblQuestions.Module FROM tblQuestions LEFT JOIN tblTest ON tblQuestions.ID=tblTest.lngQuestionID WHERE...

Maybe that a Left join will help you ? Example : SELECT tblQuestions.ID, tblQuestions.Question, tblQuestions.Module FROM tblQuestions LEFT JOIN tblTest ON tblQuestions.ID<>tblTest.lngQuestionID WHERE (((tblQuestions.Module)=[Forms]![frmTest]![cboModule]));

Minty, Don't you get a lot of nice to haves the first 3 months before a total overhaul ? Here it is sometimes even worse : After a few months of developing and starting to deploy the amazing access app some manager comes by and just say 'nope we are not going to use that. Stick to the endless...

Does shift + double click on the database work ? (It works with Office 2016.) Otherwise i guess microsoft wanted an even more exclusive way for their office 365. Edit : nevermind the shift+click... It doesn't open the database in exclusive mode. My bad :/

I guess you already have a form where you can enter the month and use that text-field in your query ? If so, you only need to add a new text-field. (Or maybe a drop-down to select the customer). And in the query add in the where statement "or ((tblPayement.Cust = txtCust.value) and...

Your code works fine. It's just that the difference between 7/2/2016 and 9/20/2016 is 2 month or 80 days. But maybe you want the difference in total. Like 0 year, 2 month and 18 days ?

Wait are there people who turn that OptionExplicit off ? Better keep it on and make the code clean and with no mistakes.

Here is an example. You need to get the date from the field first. Also you need to close the "IF" or else the code will not work.

Here is what I did : Made a query who will reset all the records in the table. You keep all the lines in that table but you can enter new dates again. The old dates are lost. So I don't know if you want to keep them or not.

Here is a thread about the same problem : http://www.access-programmers.co.uk/forums/showthread.php?t=70551 It can give you some ideas i hope.

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.