Search results

This has been my last update on the code: Private Sub cmdPreview_Click() On Error GoTo Err_Handler Dim strReport As String Dim strDateField As String Dim strStaffID As String Dim strWhere As String Dim lngView As Long strReport = "TechnicalAssistanceR"...

That is really awesome that you are doing what you like now, that's all that counts :) At the moment, I'm an intern in a company and they gave two projects using Access, that's why I'm here in case I need help I can come to the right place.

Yes, that part is working but I don't understand why the error is related to the dates when I'm trying to add a combo box to the filter relating to the names. I think I'm not understanding to where in the code I have, it's where you say I need to add something to. And also what is exactly what I...

Does that mean I only need one if statement for the date range?

At the moment I'm using this: Private Sub cmdPreview_Click() On Error GoTo Err_Handler Dim strReport As String Dim strDateField As String Dim strWhere As String Dim strFilter As String Dim lngView As Long Const strcJetDate = "\#mm\/dd\/yyyy\#"...

I don't think I understand. Do you mean that the If statement for the StaffID criteria is right? I just need to add the last line? Sorry about the trouble, I'm just not good at coding.

Would you mind walking me through that? I tried adding something like: If Not IsNull(Me.cmbStaffID) Then strWhere = strWhere & "([StaffID] = " & Me.cmbStaffID & ") AND " End If It always gives me an error 3075 and I don't really know how to fix it.

Hi, Below it's the code I'm using to filter the report within a date range (using the Allen Browne example): Private Sub cmdPreview_Click() On Error GoTo Err_Handler Dim strReport As String Dim strDateField As String Dim strWhere As String Dim lngView As Long...

Hi everyone, I'm dealing with a little problem when filtering my report. You see, I had already created a form to filter a report according to a date range. It works perfectly! But today when I showed it to the staff, they asked me if I could add another criteria to it. They want me to add by...

Hello everyone, My name is Zandy. I'm a newbie to Microsoft Access. At the moment I'm using Microsoft Access 2013 in the office although I will be leaving in a week. I'm always open to learn something new :)