By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,960 Members | 1,009 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,960 IT Pros & Developers. It's quick & easy.

Creating a search field similar to the built in Access 2007 function

P: n/a
For anyone that has the 'pleasure' of using Office 2007 you will know
of one handy feature built in - its the search function housed in the
record selector bar at the bottom of a form that allows to basically
start typing and it will automatically search any of the fields within
the form for matches and navigating to the first matching record as
you type....

I would really like to be able to build this function into an Access
2003 Database. Basically hoping that I can code an unbound field to
do the same thing!!

Does anyone know if this is possible or have any suggestions.

I am code novice so I will have trouble understanding wholeistic
instructions - just hoping someone has done something similar already
and might be able to share code or instructions.

Cheers
DeZZar

Sep 12 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Slightly different, but try this one:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html

It consists of a combo (to select which field to search), and a text box (to
enter the value to find.) You copy the code into your database, copy the
combo and the text box onto your form, and set one property. It figures it
out from there.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"DeZZar" <de**************@gmail.comwrote in message
news:4f**********************************@b38g2000 prf.googlegroups.com...
For anyone that has the 'pleasure' of using Office 2007 you will know
of one handy feature built in - its the search function housed in the
record selector bar at the bottom of a form that allows to basically
start typing and it will automatically search any of the fields within
the form for matches and navigating to the first matching record as
you type....

I would really like to be able to build this function into an Access
2003 Database. Basically hoping that I can code an unbound field to
do the same thing!!

Does anyone know if this is possible or have any suggestions.

I am code novice so I will have trouble understanding wholeistic
instructions - just hoping someone has done something similar already
and might be able to share code or instructions.

Cheers
DeZZar
Sep 12 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.