Create search engines in access db?
Ive been able to create forms that has a menu which looks up values from one field and displays the list of possible/closest matching entries.
However, i cant seem to create one which uses multiple attributes:
basically where i would have 4 different fields :
and a user could input any of the values to search like on amazon book search facility, you can search by many different values using multple criteria and find the best possible match.?
Is that possible on Access 2000? any helpful tips would be appreciated
Access 2000 and Access, in general, is a rapid development program and form values can be used to dynamically create multiple criteria for form filters and SQL strings.
They don't provide a best possible match, but all matches which satisfy the specific criteria.
The criteria and/or SQL string are substantially similar, but not identical in all respects to queries built in the SQL Servcer Enterprise Manager.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL