X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Universal Search with Detail Form    
Candace Tripp
post Feb 1 2008, 01:25 PM

UA Admin & Utter Angel
Posts: 3,039
Joined: 30-January 00
From: Virginia, USA

This is a revision of the Universal Search demo that shows how to search for a string value in ALL non-system tables in ALL fields for the current database. These matching records are displayed in a list box. Double click an item in the list box brings up the detail view of the first 11 fields of that table.
Attached File(s)
Attached File  universalsearch.ZIP ( 33.42K )Number of downloads: 1204
Go to the top of the page
post Jul 2 2015, 11:42 AM

Posts: 299
Joined: 23-March 00
From: Rockford, IL USA

This works brilliantly, except where there are commas in the results you include which will confuse the listbox and mess up the result columns. If you're going to show results from a field that may include commas, include four double quotes on each side of that field.

.... & ";" & """" & fieldname & """" ....

Thanks to Candace Tripp for the original code and to LPurvis for providing answer in the Forms forum.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    23rd March 2018 - 06:13 AM