NoRecordFound Message from a Query

galaxyfun · 01-19-2005, 04:19 AM

Hello,
I am attempting to create a search engine that takes a number of values given by the user and pass them into a query to display the results of the search. All of my fields work correctly and display correctly except for my Date field which is in Date format. I have tried the criteria statement Like "*" & [Forms]![FormName]![TextBox] & "*", and tried replacing the * with #. But no go! If anyone has any ideas, I would be very grateful.
Cheers Mel

galaxyfun · 01-19-2005, 04:22 AM

Hello,
I am trying to create a query that return a record, but returns a No record Found Message if nothing is found. I have the query returning the correct records, but I am not sure how to get it to return the not found message when neccessary. If anyone can help that would be super
Cheers Mel

greyknight17 · 01-19-2005, 08:53 AM

Threads merged.

01-19-2005, 04:19 AM	#1 (permalink)
galaxyfun Registered User Join Date: Jan 2005 Posts: 4 OS: Win 98	Problem with Date Format passing to a Query in Access Hello, I am attempting to create a search engine that takes a number of values given by the user and pass them into a query to display the results of the search. All of my fields work correctly and display correctly except for my Date field which is in Date format. I have tried the criteria statement Like "" & [Forms]![FormName]![TextBox] & "", and tried replacing the * with #. But no go! If anyone has any ideas, I would be very grateful. Cheers Mel

01-19-2005, 04:22 AM	#2 (permalink)
galaxyfun Registered User Join Date: Jan 2005 Posts: 4 OS: Win 98	NoRecordFound Message from a Query Hello, I am trying to create a query that return a record, but returns a No record Found Message if nothing is found. I have the query returning the correct records, but I am not sure how to get it to return the not found message when neccessary. If anyone can help that would be super Cheers Mel

01-19-2005, 08:53 AM	#3 (permalink)
greyknight17 Analyst, Security Team Join Date: Jul 2004 Location: New York Posts: 14,331 OS: Windows 98 & Windows XP Home/Pro My System	Threads merged. __________________ Please do NOT PM me. Post whatever questions you may have in the forum and we will take a look at it when we get to it. If you have waited for more than 3 days, you may then and ONLY then PM me for assistance. I will take a look at it. Adaware :: CWShredder :: HijackThis :: Panda ActiveScan :: Spybot S&D Anti-Spyware Tutorial :: Spyware Prevention Tools