Large combo boxs + Registration

  • Thread starter Thread starter Adrian Brown
  • Start date Start date
A

Adrian Brown

Ive got a combo box that contains around 800 items, when you type in the
list it takes ages to process each key press. At the moment this list box
is filled in using AddItem from VB as i have a small subset of data, then a
dividing line ('-------') and then all the items. Is there a better and
faster way to produce this combo box?

Another question is on registration systems. When i release the database I
want to be able to lock it to the machine it is installed on. The idea is
when it is first run it produces a product key that is then activated over
the phone. The user then enters the appropriate key to unlock the software.
This is to stop people just giving copies of the software to other people
etc. What is the best way of doing this? Is there already a system
available?

Many Thanks
 
In line:

Adrian Brown said:
Ive got a combo box that contains around 800 items, when you type in the
list it takes ages to process each key press. At the moment this list box
is filled in using AddItem from VB as i have a small subset of data, then a
dividing line ('-------') and then all the items. Is there a better and
faster way to produce this combo box?
Click to expand...

Use a SQL statement ... if necessary, from a Union query. With indexes even
8,000 records should be very quick. Looping through AddItem will always be
very slow.
Another question is on registration systems. When i release the database I
want to be able to lock it to the machine it is installed on. The idea is
when it is first run it produces a product key that is then activated over
the phone. The user then enters the appropriate key to unlock the software.
This is to stop people just giving copies of the software to other people
etc. What is the best way of doing this? Is there already a system
available?
Click to expand...

There are commercial systems out there which may work for you. You might
Google for them. I'd like to discourage you from activation though, you will
have angry users if you are available 24/7 with a fool-proof system. Angry
customers will cost you more than cheating ones.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top