I want to make a desktop search box to enter 1 of 4 different types of criteria.

[cshellntn]

Someone please help. I am very new to Access and my boss wants me to build a
database, which I have done and it is very easy to run queries to find the
data he wants. However, he wants a desktop "widget" so he can plug the number
in and get all the data related to what he entered.

He has mentioned indexing. I cannot find where that is logical.

Any help at all would be great.

Crystal

 

[Rui]

As far as I am aware, access does not have a library to implement such feature.

If you are good with programming, you could do a .NET application that
performs such task. this would connect to your access db and query it. But
this has nothing to do with this newsgroup.

Try a VB.NET forum. They should be able to help.

 

[AccessVandal via AccessMonster.com]

The closes is hide the access window. Here the code:

http://www.mvps.org/access/api/api0019.htm

Use this code to hide the access window, let your start up form as the search
widget.
Put a short-cut on the desktop. Change the icon if you like.