Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


What are good record browsing methods in RDS?

Posted on 1999-07-22
Medium Priority
Last Modified: 2013-12-25
I am developing web database applications using RDS.  The users are accustomed to using ACCESS applications in which they can find records by using combo boxes with autocompletion, etc.

What sorts of record selection techniques will such users find acceptable?  I've experimented with the Listbox Design-Time control, and that is just too slow with large recordsets.

Please advise.
Question by:garyz31
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

ssite earned 200 total points
ID: 1864267
First of all, don't use RDS, use ADO.

I assume that by auto completion you mean typing the word and it being selected automatically. Standard Windows behaviour is to look for words begining with the typed character.

Your solution is good old Javascript. You need to monitor the combo box's key press/down event and keep a buffer of what is typed, then you can itterate through the options in the select control and look for ones which suit the keys clicked. You must then have the browser not buble the event, or the control will revert to its standard behaviour.


Author Comment

ID: 1864268
Thanks, will definitely give it a try.

Expert Comment

ID: 1864269
Mind sending me the source code? :-)

Featured Post

Major Serverless Shift

Comparison of major players like AWS, Microsoft Azure, IBM Bluemix, and Google Cloud Platform

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmakerā€¦
This video teaches users how to migrate an existing Wordpress website to a new domain.
Suggested Courses

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question