Access - Remembering previously typed words

%3CLINGO-SUB%20id%3D%22lingo-sub-1605156%22%20slang%3D%22en-US%22%3EAccess%20-%20Remembering%20previously%20typed%20words%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605156%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20automatically%20remembers%20previously%20typed%20words%20on%20a%20workpage.%20How%20do%20I%20enable%20this%20function%20on%20Access%20when%20I'm%20entering%20information%20into%20fields%20-%20it%20will%20save%20me%20a%20heap%20of%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Echmwman%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605492%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20-%20Remembering%20previously%20typed%20words%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605492%22%20slang%3D%22en-US%22%3E%3CP%3ENo%20such%20functionality%20exists%20in%20Access.%26nbsp%3B%20If%20you%20want%20to%20reuse%20values%20then%20a%20Combo%20box%20or%20Listbox%20are%20your%20best%20options.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605560%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20-%20Remembering%20previously%20typed%20words%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605560%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767543%22%20target%3D%22_blank%22%3E%40chmwman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKeep%20in%20mind%20that%20Excel%20and%20Access%20serve%20different%20purposes%20and%2C%20therefore%2C%20include%20a%20large%20number%20of%20different%20features.%20Some%20things%20are%2C%20of%20course%2C%20%22similar%22%2C%20but%20it's%20not%20a%20good%20idea%20to%20count%20on%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%2C%20for%20example%2C%20it%20sounds%20like%20you%20are%20working%20with%20what%20is%20often%20referred%20to%20as%20%22a%20domain%22%20of%20values.%20Common%20examples%20might%20include%20days%20of%20the%20week.%20There%20are%207%20of%20them%3B%20they%20are%20universally%20understood%20and%20agreed%20upon%3B%20there%20will%20never%20be%20more%20than%20or%20less%20than%207.%20It's%20a%20%22domain%22%20of%20values%20and%20it's%20closed%2C%20so%20this%20kind%20is%20called%20%22A%20Closed%20Domain%22.%20Similar%20examples%20are%20months%20of%20the%20year%20and%2C%20depending%20on%20where%20you%20live%2C%20the%20states%20or%20provinces%20in%20your%20country.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EA%20second%20kind%20of%20domain%20is%20often%20encountered%20in%20Access%20relational%20database%20applications.%20These%20are%20well%20known%2C%20more%20or%20less%20stable%2C%20collections%20of%20values%20important%20to%20your%20organization.%20Vendors%2C%20for%20example%2C%20or%20Shippers%2C%20or%20Products.%20Each%20of%20these%20is%20a%20domain%20because%20it%20consists%20of%20the%20values%20relevant%20to%20your%20organization's%20activities.%20Departments%20might%20be%20important%20to%20a%20corporation%2C%20for%20example.%20These%20are%20%22Open%20Domains%22%20which%20consist%20of%20stable%2C%20but%20not%20totally%20rigid%2C%20groups%20of%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20both%20cases%2C%20though%2C%20you%20will%20have%20a%20table%20for%20each%20such%20set%20of%20Domain%20values.%20A%20Product%20table%20for%20a%20manufacturer%2C%20for%20example%2C%20or%20a%20Client%20table%20for%20a%20services%20provider.%20These%20tables%20are%20sometimes%20referred%20to%20as%20Lookup%20tables%2C%20particularly%20those%20that%20hold%20values%20for%20a%20Closed%20Domain.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstead%20of%20tasking%20your%20interface%20with%20the%20job%20of%20%22remembering%22%20them%20as%20you%20do%20with%20the%20not-terribly-reliable%20Excel%20feature%2C%20you%20use%20combo%20or%20list%20boxes%20on%20your%20forms%20which%20are%20bound%20to%20those%20Lookup%20tables%20to%20supply%20the%20appropriate%20values%20from%20which%20users%20select.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20what%20Daniel%20was%20referring%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20a%20relational%20database%20application%2C%20there%20are%20multiple%20benefits%20to%20using%20combo%20and%20list%20boxes%20for%20such%20tasks%20beyond%20the%20simple%20fact%20that%20you%20don't%20burden%20users%20with%20having%20to%20remember%20which%20ones%20are%20valid%20for%20YOUR%20organization%20and%20which%20ones%20are%20not.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Excel automatically remembers previously typed words on a workpage. How do I enable this function on Access when I'm entering information into fields - it will save me a heap of time.

 

Thanks

 

chmwman

2 Replies
Highlighted

No such functionality exists in Access.  If you want to reuse values then a Combo box or Listbox are your best options.

 

 

 

Highlighted

@chmwman 

Keep in mind that Excel and Access serve different purposes and, therefore, include a large number of different features. Some things are, of course, "similar", but it's not a good idea to count on that.

 

Here, for example, it sounds like you are working with what is often referred to as "a domain" of values. Common examples might include days of the week. There are 7 of them; they are universally understood and agreed upon; there will never be more than or less than 7. It's a "domain" of values and it's closed, so this kind is called "A Closed Domain". Similar examples are months of the year and, depending on where you live, the states or provinces in your country. 

A second kind of domain is often encountered in Access relational database applications. These are well known, more or less stable, collections of values important to your organization. Vendors, for example, or Shippers, or Products. Each of these is a domain because it consists of the values relevant to your organization's activities. Departments might be important to a corporation, for example. These are "Open Domains" which consist of stable, but not totally rigid, groups of values.

 

In both cases, though, you will have a table for each such set of Domain values. A Product table for a manufacturer, for example, or a Client table for a services provider. These tables are sometimes referred to as Lookup tables, particularly those that hold values for a Closed Domain.

 

Instead of tasking your interface with the job of "remembering" them as you do with the not-terribly-reliable Excel feature, you use combo or list boxes on your forms which are bound to those Lookup tables to supply the appropriate values from which users select.

 

This is what Daniel was referring to.

 

In a relational database application, there are multiple benefits to using combo and list boxes for such tasks beyond the simple fact that you don't burden users with having to remember which ones are valid for YOUR organization and which ones are not.