Search results

Hi Paul can you have a look over my database when you get minute http://www.access-programmers.co.uk/forums/showthread.php?p=1329400#post1329400 Cheers Shane

hi paul here goes here a sample db you will be looking at form frmwheredates so what im trying to achieve to be able to enter a date range be able to add one client name or two depend on the user wants then generate a report also be able to filter records if no date range is entered by...

To be honest I not very good with vba and now I so confused I don't fully understand the code but I doing my best If Len(Trim(Me.cboclient)) & (Trim(Me.cboclient2)) > 0 Then End If so are you say I should remove the if statement I'm still getting error Microsoft access...

Right Paul and Paul here's the hole the code Private Sub cmdPreview_Click() 'On Error GoTo Err_Handler 'Remove the single quote from start of this line once you have it Dim strReport As String Dim strDateField As String Dim strWhere As String Dim lngView As Long...

hi right I try adding field name and remove parentheses in the middle If Len(Trim(Me.cboclient)) > 0 Then If strWhere <> vbNullString Then strWhere = strWhere & "and" End If If Len(Trim(Me.cboclient2)) > 0 Then End If strWhere = strWhere & "(Client = '" & Me.cboclient & "or" & Client =...

im getting this when I debug print ([Date raised] >= #12/01/2012#) AND ([Date raised] < #10/02/2013#)and(Client = 'Luton Council')orFalse

ok I have now try this still can't bloody get it to work If Len(Trim(Me.cboclient)) > 0 Then If strWhere <> vbNullString Then strWhere = strWhere & "and" End If If Len(Trim(Me.cboclient2)) > 0 Then End If strWhere = strWhere & "(Client = '" & Me.cboclient & "')" & "or" & (Client = '"...

Paul can you point me in direction of which parentheses I need to change or add pretty please with a cherry on top cheers shane

hi have tried If Len(Trim(Me.cboclient)) > 0 Then If strWhere <> vbNullString Then strWhere = strWhere & "and" End If If Len(Trim(Me.cboclient2)) > 0 Then End If strWhere = strWhere & "(Client = '" & Me.cboclient & "or" & Me.cboclient2 & "')" End If still no good I'm running out...

right I have try this If Len(Trim(Me.cboclient)) & (Trim(Me.cboclient2)) > 0 Then If strWhere <> vbNullString Then strWhere = strWhere & " and " End If strWhere = strWhere & "(Client = '" & Me.cboclient & "OR" & Me.cboclient2 & "')" End If This doesn't work can someone point me...

Paul i'm guessing your saying put 3 and 4 together in one statement with a or to be honest Paul I m way over my head with this one would not no where to start thanks again shane

hi I tried debug print this is result looks right to me ([Date Raised] >= #10/03/2013#) AND ([Date Raised] < #10/24/2013#) AND (Client = 'S J Turner') OR (Client = 'Cavendish') can't understand why the value enter in cboclient2 does not apply to date range enter it show's all...

hi, all I have a sub form that I enter date range in 2 text box's txtstartdate and txtenddate this is filtering field "date raised" and I have combo box call cboclient this is filtering field "client name" this code is behind a command button after hitting the command button it...

thanks paul legend!!!! cheers shane

hi right this works If Me.[Job Cancelled 2] = True Then strWhere = strWhere & "AND" & " [job cancelled] = -1 " but now if I leave the date range box's empty and only select jobs cancelled I get syntax error thanks for your time shane

hi I'm getting syntax error missing operator I have attach picture so you may understand better then me cheers shane

Sorry to be a little slow but do I add that to my second lot of vba Thank you so much for you time Shane

hi all I have got like subform which I think is the tech term I use it to filter dates on field "date raised" and open's a report depend on date's entered in txtstartdate and txtenddate it works perfectly but I need to add some check boxes to check other field's are true/false right I will...

thanks plog for your help I don't understand parenthesis around the 1st pair of statements and another around the second pair where? sorry I not great with access cheers shane

hi , all I have 2 unbound combo box's on a form 1 called cboclient1 and the another called cboclient2. would like to be able to filter field name client name twice by cboclient1 and cboclient2 here my sql from my query WHERE (((Assets.Client)=Forms![report gen]!cboclient1)) Or...