473,327 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

MS Access autocomplete/autofill text box

10
I have searched and searched and cannot seem to find an answer that fits my needs. Hopefully you can help.

I have a database that stores names,addresses, etc. I am trying to get it to where I start typing the last name it will 'suggest' names that are already in the table. ex. If the last name is "Johnson", When I start typing "Jo" it will automatically complete as i type.

Any Idea's?

Thank you
Shaft11
Aug 17 '09 #1
6 38480
ajalwaysus
266 Expert 100+
I would make the fields, you wish to auto complete, combo boxes where the record source is Last name, First Name...etc. When using a combo box, the results narrow as you type in the box. Try it and let me know if this works for your needs.

-AJ
Aug 17 '09 #2
ADezii
8,834 Expert 8TB
@Shaft11
What ajalwaysus is referring to is the AutoExpand Property of a Combo Box. You can use the AutoExpand property to specify whether Microsoft Access automatically fills the text box portion of a combo box with a value from the combo box list that matches the characters you enter as you type in the combo box. This lets you quickly enter an existing value in a combo box without displaying the list box portion of the combo box. You can also create a Text Box/List Box combination like the one in Windows Help. As you type in the Text portion of the Text Box, the List Box will scroll to whatever has been typed so far. It is a very handy feature but the coding is slightly complex.
Aug 19 '09 #3
Shaft11
10
Thanks,

It works, but if I add a name that is not in the list I get the 'Not in the list' Error

Other than that it works.

(Sorry it took me so long to reply, I had to buy a new computer due to a STUPID virus)
Oct 25 '09 #4
nico5038
3,080 Expert 2GB
Might be helpfull to check this page:
http://www.j-walk.com/ss/excel/tips/tip77.htm
when you want to match also sound-like names.

Nic;o)
Oct 25 '09 #5
NeoPa
32,556 Expert Mod 16PB
@Shaft11
Set the .LimitToList property to No, and call a .Requery after updating the control.
Oct 26 '09 #6
Just do it in Excell, which will allow autocomplete, then import excel into Access.
Oct 14 '10 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Dave | last post by:
Hi All, Just getting started with ASP (NOT .NET) and have a question: I have a basic form and I'm trying to add some functionality to it. I want a user to be able to select a product from a...
1
by: Dejan M. | last post by:
CLAN_ID ||| IME(name)||| PREZIME(surname) ||| CASOPIS_ID (journal_id) ||| NAZIV (journal name)||| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||...
1
by: Andrew Chanter | last post by:
I am writing a little routine to perform the following operations from an Acces 97 mdb: 1. create a fixed width text file 2. create/establish a table type link to the text file in Access 3....
4
by: raju5725 | last post by:
have a MS access table and I want to export it to comma delimited text file. How do I do this programmatically using VB.NET or C#? Thanks for any help in advance. Raju
7
prn
by: prn | last post by:
Hi folks, Sometime in the last few days, I must have accidentally done something that changed some kind of switch in Access, but I can't seem to find what it was. This is Access 2003 under XP,...
4
by: Neil | last post by:
Just found out that the Microsoft Rich Textbox does not support full text justification, since it's based on Version 1.0 of the RichEdit Window Class, and full text justification is only available...
16
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might...
8
by: jcoleshill | last post by:
Hello, I am new to Access, I'm trying to make the switch from Excel to Access as the databases I'm working with have over 200,000 records. In excel, when you want a field to autofill...
16
by: dybalabj | last post by:
I realize this should probably be a simple solution, but I have only been learning PHP and MySQL for a couple weeks. I am attempting to write an invoicing system that uses a MySQL database to store...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.