Code:hello code
Code:hello code
I think I have gotten it now
Thanks so much for this assistance.
This thing has been a headache since I started posting on this page
So about my issue
Has anyone been able to find a fix for me?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Now crossposted at https://www.access-programmers.co.uk.../#post-1824055 without any acknowledgement to responses here.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Honestly, I don’t understand this debug print process so that’s making it difficult to find a solution.Now crossposted at https://www.access-programmers.co.uk.../#post-1824055 without any acknowledgement to responses here.
And since the help isn’t coming as expected, had to cross post because I need urgent help with this.
All I am suggesting is debug the code.
See the link in my signature. A video is worth a thousand words.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
You do realise that the members here help out in their free time?, they have other things to do in their life, and also have to sleep sometime?
You cannot expect to post on a forum and get an immediate answer all the time. Sometimes you will get lucky, but most times members have to extract information from the O/P to be able to focus on the problme. like pulling hen's teeth.
Not saying that you do not know how to debug or walk through the code does not help? You joined here over 2 years ago. I would have expected you to have to use debug and F8 by now.? It is invaluablefor find out what you actually have NOT what you think you have. it is also brilliant for finding what I call silly errors, that elude people, myself included, that is why I promote it all the time.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Changed a few things in tables and form to make it workable. Feel free to change your form properties back to what they were.
You should have Option Explicit in the declarations of all your modules.
Dont use special characters in field and object names.
No need for the IIf's since your validation does not allow nulls.
you should probably have tables for payment form and payment mode and store the PKeys.
Code:strCriteria = "[dteDATE] between #" & Me.OrderDateFrom & "# And # " & Me.OrderDateTo & "# And [PAYMENT_FORM] LIKE """ & Me.cboIncomeType1 & _ """ And[PAYMENT_MODE] LIKE """ & Me.cboIncomeType & """" Debug.Print strCriteria Me.Filter = strCriteria Me.FilterOn = True
If this helped, please click the star * at the bottom left and add to my reputation- Thanks
Managed to get a code that worked
Code:Else strCriteria = "[DATE] >= " & Format(Me.OrderDateFrom, "\#mm\/dd\/yyyy\#") & _ " And [DATE] <= " & Format(Me.OrderDateTo, "\#mm\/dd\/yyyy\#") & _ " And [PAYMENT_FORM] = '" & Me.cboIncomeType1 & "'" & _ " And [PAYMENT_MODE] = '" & Me.cboIncomeType & "'"
Sorry, I do not see anything that has changed with that code?
Managed to get a code that worked
Code:Else strCriteria = "[DATE] >= " & Format(Me.OrderDateFrom, "\#mm\/dd\/yyyy\#") & _ " And [DATE] <= " & Format(Me.OrderDateTo, "\#mm\/dd\/yyyy\#") & _ " And [PAYMENT_FORM] = '" & Me.cboIncomeType1 & "'" & _ " And [PAYMENT_MODE] = '" & Me.cboIncomeType & "'"
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba