Search results

  1. K

    newbie needs help with vba code syntax

    Hey Guys, I am new to vba and I need some help with writing the correct syntax for the code to work. Basically I have the following logic: strSELECT = "SELECT qryReportBuilderNew.* " strFROM = "FROM qryReportBuilderNew" strWHERE = " WHERE qryReportBuilderNew.CompanyID = " & Me.Text10 strSQL =...
  2. K

    how to filter data that is displayed in a report from a query

    Hey peeps, I have data that is displayed in a report from a query. How can I filter that data with a conditional statement? Is this possible in access? So for example, my record has got a "Detail section" that has two textboxes, these two textboxes displays names of employee. So I want apply a...
  3. K

    I need to run a query in a on click event and display it in a report with this logic

    Hey peeps, I need some guidance here. I have the following vba code in a On Click event: Private Sub Command12_Click() Dim intCountryID As Integer intCountryID = DLookup("CountryID", "qryCompanyFilter", "[CompanyID] = " & Me.Text10) Select Case intCountryID Case 1 DoCmd.OpenReport...
  4. K

    Need help to run this logic in VBA from Access On Click event

    Hey Guys, I a newbie in VBA code and need some help. I have an access database and have the following structure: I have two tables called player and sports. Also the table sport has a field name sportType, and every sports name belongs to a type 1, 2, or 3. So for example, Football has type 3...
  5. K

    Need to run a custom query and export it to excel?

    Hey Peeps, I have a form in Microsoft access with some fields and checkboxes with a Search Button. On filling in the fields and ticking the check boxes, it creates a query on the fly and displays it as a report. This all works fine but I want to add an extra button on the form that would create...
  6. K

    Check box need the correct syntax

    Hey peeps, I have added a check box in an access application, which when ticked and on pressing the submit button, it builds a query and displays the result. I am not sure what is the correct syntax in VBA, that would do the following:IF checkbox is ticked THAN do something, so in my case add...
  7. K

    Update query to concatenate values into a string field

    I have the following VBA code that runs the Update sql and updaes the field CandidateNumber. strCNum = "UPDATE tblExamDetails " & _ "SET tblExamDetails.candidateNumber =" & Me.Text38 & "/0" & Me.fkDesignerID & " " & _ "WHERE ((tblExamDetails.fkDesignerID)=" &...
Back
Top Bottom