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 38619
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,569
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |