Search results

Haha ok sorry :) And yes that is exactly how i would like the date search part to work.

Yes but aswell as that it needs to use multiple search criteria. for example they may want to find the dates Engineer X was working in december. So they would select Engineer X and then the dates and hit search. How would i represent this in my code and make it work? Much appreciated

I think so thanks alot

Ok thanks very much for your help.

DoCmd.OpenReport "VisitSheetTableReport", acViewReport, , strFilter Then how do i select the report to apply the sort?

Yes they represent names of engineers on the visit. It is a date field. ive used a text box with the short date format as apose the the DTtime picker. Thanks again

So i need to Select my report first?

I wonder whether this would help solve the problem as then it has to run something.. what you think? (Ive changed all the Ifs to Elseif) [CODE]Private Sub Command55_Click() Dim strFilter As String Dim VarItem As Variant If Me.Check72.Value = True And Me.Check74.Value = True Or...

Sort of except that thread is about search functionality this is about sort. I thought it would be better to keep them seperate so as not to confuse people and me.

Sorry i meant control source and have now renamed the comboboxes. I have Engineer 1 to 3 as field names because within this program there is a section to add visit sheets, there are 3 options for engineers as we very rarely have more than 2, if there was 4 the chances are they would be doing...

Hi thanks in advanced for any help. I have 3 checkboxes in my form i wish to when checked and search button is pressed to open the report and sort it by the corresponding field heres what i have so far... If Me.chkQuoteNumber.Value = True Then yea not alot :D i think i might need to use...

Thanks for any help you can give

Hi thanks for the help, my code is for a search function from a form into a report. it opens the report and filters the results. and no it doesnt error anywhere sometimes when i press the button nothing happens at all. and my code does look like that apart from there are gaps between each...

Well thankyou for your words of wisdom sir. All i wanted was for someone to proof read my code make sure there are no clear faults as i am no expert when it comes to vba. But apparantly i cant do this without a lesson on how to ask for help? I thought that was the purpose of these forums to ask...

The reason my complaint is unspecific is because i have no idea what the problem is. I cant tell you more than what i know myself. I am trying to learn more and more and whilst i thankyou for the tips about renaming i dont think it is helpfull to link me to a time wasters page. I am clearly not...

[CODE]Private Sub Command55_Click() Dim strFilter As String Dim VarItem As Variant If Me.Check72.Value = True And Me.Check74.Value = True Or Me.Check75.Value = True And Me.Check72.Value Or Me.Check75.Value And Me.Check74.Value Or Me.Check75.Value And Me.Check74.Value And Me.Check72.Value = True...