Recent content by Burboni

Still stopping when it hits a null field. Private Sub cmdStart_Click() Dim strSQL As String Dim qdf As DAO.QueryDef Dim partnumber As String Dim Customer As String Dim Description As String Dim CustomerNo As String Dim StartDate As String Dim EndDate As String partnumber = Me.PartNo Customer...

That is still not working. The if statement seems to do nothing as I still get the invalid use of null. Private Sub cmdStart_Click() Dim strSQL As String Dim qdf As DAO.QueryDef Dim partnumber As String Dim Customer As String Dim Description As String Dim CustomerNo As String Dim StartDate As...

Hi, I have corrected the & to an And. I am unsure how your code is to be implemented though. I do not understand the Where 1=1 part. Private Sub cmdStart_Click() Dim strSQL As String Dim qdf As DAO.QueryDef Dim partno As String Dim Customer As String Dim Description As String Dim CustomerNo...

Hi, I was wondering if someone could help me. I have a few tables in SQL that I wish to query. I have a form with a subform that displays my results. On my form I have 6 text boxes that will allow a user to fill in criteria. Now my problem is that not all the fields could be filled in. Maybe...