Search results

Actuallly I need to search for just a '*' not *'s in any part of the field not just at the end Thanks

I need to write a query that searches a field that contains *'s I tried using the Like operator with the Ascii chr(42) but can not get the right results as it seems to return all records SELECT tbl_catalog.upc, tbl_catalog.Caption FROM tbl_catalog WHERE (((tbl_catalog.Caption) Like Chr(42)))...

Yes, I am using a UPC code but the codes come from our distributors via a .csv file. No bar code scanner on our end. Would be an easy way to get the UPC into a database.

I have set the recordsoucre as: Private Sub Report_Open(Cancel As Integer) Dim strSql As String strSql = "SELECT tbl_Catalog.* " & _ "FROM tbl_Catalog " & _ "ORDER BY tbl_Catalog.Vendor, tbl_Catalog.Path, tbl_Catalog.ProdName, tbl_Catalog.Price;" Me.RecordSource = strSql...

I need to define a reports recordsource in the Report_Open procdure as I do not want to bind any of the controls in the detail section. How do i do that and how do i referance the recordsource fields in the detail_formatat procedure of the report? Thanks