Member Avatar for alleybye

Guys! im doing a search program where in ill just search the name of the product then print it.

Private Sub txtSearch_Change()
rsTransaction.Close
rsTransaction.Open "select * from tblTransaction where mid$(Date,3,2) like '" & txtSearch.Text & "%'", con, 3, 2
end sub

it is actually doing fine but i really dont know how to print that selected item on datareport? i try to do it but it print the whole table on the database to the page.

i just want to make a daily report of my database :(

help me please?

  • 2 Contributors
  • 1 Reply
  • 104 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

You need to pass only the desired record set to the report not the entire table.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.