Re: Data Coding

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You can use Microsoft's autocorrect feature so everytime you type
"min" it would replace it with minimal.

Another option would be to use lookup tables so the user would enter
in 1 then the lookup table would return "Minimal" in another cell.

On May 29, 11:43 am, Whois Clinton
<WhoisClin...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi,

I would like to set up codes for faster data entry, similar to SPSS options.
For instance:
Entering 1 would display Minimal
Entering 2 would display Moderate
Entering 3 would display Severe
Entering 4 would display Maximum

There would be several variations on the above idea such as department names
etc. Is there any help or existing references for such topics?

Thanks in advance
Clint

.

Relevant Pages

  • Need help with GridView and LDAP/GC
    ... I could do the search with GC, and then lookup more ... DirectoryEntry searchRoot = new ... // Add search string if specified. ... // Display Name ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Guidance on entering and display date & time
    ... the data input and display. ... Is there something similar for entering the time? ... do NOT use separate textboxes for the date and time, ... in your report, or in the query upon which you base the report. ...
    (microsoft.public.access.forms)
  • Re: Entering return symbol in a program [compiler/decompiler]
    ... but I'm getting stuck on entering the return character (red shift. ... to suggest to a "display" function that the next thing in a string ... it's all the same to the compiler, and makes no difference, ...
    (comp.sys.hp48)
  • Re: displaying an "alias" value in a table
    ... In the lower pane of the table design window, click on the Lookup tab. ... You will see that it is set up as a Combo, where the bound column is ... HOWEVER the table field display substitutes the information in ... For instance I might select "Mary Ann" from a dropdown list. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL "NOT IN" doesnt function as expected (refresh)
    ... The unfortunate fact is that what is displayed in datasheet view of a query is not what is stored if you are using a field that uses the lookup feature. ... That's why most of us avoid using the lookup field. ... On forms you can use a combobox to display one value while actually storing another value. ... implementation of the form is -supposed- to be independant of the underlying storage, otherwise it makes a mockery of the SQL standard. ...
    (microsoft.public.access.queries)