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
6  38627 
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
ADezii 8,834
Recognized Expert Expert @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.
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)
NeoPa 32,571
Recognized Expert Moderator MVP @Shaft11
Set the .LimitToList property to No, and call a .Requery after updating the control.
Just do it in Excell, which will allow autocomplete, then import excel into Access.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
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 list box. After this product
is selected have another text box, ProductID update to reflect the product
number.
In VB I would use an OnChange type thing. Can anyone point me how to do
|
by: Dejan M. |
last post by:
CLAN_ID ||| IME(name)||| PREZIME(surname) ||| CASOPIS_ID (journal_id) |||
NAZIV (journal name)|||
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
I have the form with these fields.
When I enter CLAN_ID automaticly fill up fields IME (name) and PREZIME
(surname),
and...
|
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. allow the user to view the text contained in the text file via an Access
form.
I have been able to achieve this, albeit with one major limitation. That is
that the name of the text file needs to be known prior to runtime. In other
|
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
|
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, BTW.
Currently, when I'm editing any kind of textual material within Access, e.g. a SQL statement or something in the Properties for a GUI element, I find that whenever I move the text cursor within that text, it selects (inverts) the text between...
| | |
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 in versions 3.0 or later of
the class.
However, also just found out that the new Rich Text property in Access 2007
ALSO does not support full text justification! This seems incredible, that
MS would create a brand new application, and not...
|
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 know one way or the other whether that was
true or not, or could point me to an article or help text that would. What I
have seen so far online and in Access 2007 help seems to confirm the above.
But that (or at least (b)) seems incredible that it...
|
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 numbering, it's easy. You type in 1,2,3,4 etc. highlight this and drag or double click and magic the rest of the records are filled in for this field with the continued counting.
How the $#^%&$%#@ does one do this in Access. I have 2003.
Please Help!
|
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 invoices, product pricing, and customer contact info. I would like to automatically fill in the customer's contact info after typing in the first and last name, and the product pricing info after typing in the product name. From my searches I've...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
