Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers
elance-zoho-creator-exam.pdf

Choose the VBA code to filter the rowsource in a multiple column listbox that will allow you to filter the records listed using the LIKE statement and the variable xCompany.

Me.List0.RowSource = "SELECT * FROM tblOrders WHERE Company LIKE '*" & xCompany & "*'"
Me.List0.RowSource = "SELECT * FROM tblOrders WHERE Company LIKE *" & xCompany
Me.List0.RowSource = ʺSELECT * FROM tblOrders WHERE Company LIKE 'ʺ & xCompany & ʺ'ʺ
Me.List0.RowSource = ʺSELECT * FROM tblOrders WHERE Company LIKE *'ʺ & xCompany & ʺ'*ʺ
Top
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon