Recent content by kee2ka4

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 =...

Can you give an example, I am not sure how to put it in a query's Criteria row. Isn't there a way to apply the conditions to the text box in the details section of the report? So say the query give me 4 records: Tom, Bob, Bill and Jack and Jack has deleted flag = 1 and the rest has 0, then I...

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...

Hey guys.. thanks for you replies.. i'll give that a go. David, you are right about simplifying the code. Acually there is gonna be only one query for all the three case condidtions, only the report will be different because each report has different layout! I will post the actuall code if I get...

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...

Thanks for your help man..

Hi, thanks for your email. Yea actually all the three reports is gonna like very different hence I will need three different reports and also I need to relate the person to the sport type rather then the name. I gave the above example to simplify things :)

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...

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...

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...

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)=" &...