Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 10th, 2004, 04:52 AM
Registered User
 
Join Date: Mar 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default VBA Access Automatic List Problem

<div align="left"></div id="left">

Hello,

I'm trying to automatize a result list of a form and I don't know how.
For example..I want (in order to have 'Miles' as the final result), by typing 'M', all names starting with 'M' to appear...then by typing 'I' all names starting with 'Mi' to appear automatically etc...

Please if anyone knows the peace of code that does that..sent it to me...I'd be grateful!

Thaleia

 
Old March 10th, 2004, 09:18 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

If you want to automate this, you can make the field a combobox. Comboboxes automatically fill in just like you want when you type in them instead of choosing from the dropdown list.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division





Similar Threads
Thread Thread Starter Forum Replies Last Post
List Available Fonts in Access VBA Nadine Access VBA 0 March 19th, 2008 12:24 PM
Change the Appearance of a list box (Access VBA) hewstone999 Access VBA 1 February 29th, 2008 09:12 AM
List Box Fliter MS Access VBA hewstone999 Access VBA 1 February 29th, 2008 09:01 AM
VBA access List data to text file Data-Base Access VBA 6 September 15th, 2005 04:04 PM
Beginning Access 2000 VBA Chapter 6: List Boxes greencw BOOK: Beginning Access VBA 1 June 13th, 2004 08:16 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.