enter data in access

[Rick Brandt]

hi,

in excel when i start typing data it automatically shows the best match
based on the previous entries in a column. Is it possible in access so
that when i enter data in form or table it will show me the best match
based on the previous records.

Mosaddeq

Entering directly into a table? No. On a form you can use a ComboBox to
get that behavior.

 

[emilybalise@yahoolcom]

hi,

in excel when i start typing data it automatically shows the best match
based on the previous entries in a column. Is it possible in access so
that
when i enter data in form or table it will show me the best match based on
the previous records.

Mosaddeq

 

[Rick Brandt]

thanks for the reply. can u elaborate a bit more.

ComboBoxes offer a list of choices. They have a property named
AutoExpand that when enabled causes the list to jump to the first choice
matching the characters you have typed thus far.

If you set up a ComboBox so it has a RowSource query that pulls in all
unique instances of past entries in the field the control is bound to
then you get the behavior you are asking for.

 

[Jack Cannon]

Mosaddeq,

You are referring to an Incremental Search. That is not possible in Access
if you are trying to enter data directly into a table. As Rick mentioned it
is possible if you are entering data on a form. The easiest way to implement
an Incremental Search function on a form is to use a ComboBox. It is also
possible to implement an Incremental Search function using a text box on a
form but that requires a high level of VBA experience. If you must have this
function then a ComboBox is usually the better way to go.

A note of caution: An Incremental Search works very nicely in Excel because
the records are probably in main Memory at the time that you are doing the
search. That is not necessarily true in Access. The records will usually be
on a hard drive. This means that a good typist will type faster than the
system can respond and the results are unusable.

This problem is particularly acute for a workstation on a network. Even a
poor typist will overrun the system response time and the users will cease to
use the function. You may very well end up wasting your development time
pursuing this function.

Jack Cannon

 

[pb110005-2351]

hi,

in excel when i start typing data it automatically shows the best match
based on the previous entries in a column. Is it possible in access so
that
when i enter data in form or table it will show me the best match based on
the previous records.

Mosaddeq

 

[pb110005-2351]

hi,

in excel when i start typing data it automatically shows the best match
based on the previous entries in a column. Is it possible in access so
that
when i enter data in form or table it will show me the best match based on
the previous records.

Mosaddeq

 

[pb110005-2351]

hi,

in excel when i start typing data it automatically shows the best match
based on the previous entries in a column. Is it possible in access so
that
when i enter data in form or table it will show me the best match based on
the previous records.

Mosaddeq

 

[pb110005-2351]

hi,

in excel when i start typing data it automatically shows the best match
based on the previous entries in a column. Is it possible in access so
that
when i enter data in form or table it will show me the best match based on
the previous records.

Mosaddeq

 

[pb110005-2351]

hi,

in excel when i start typing data it automatically shows the best match
based on the previous entries in a column. Is it possible in access so
that
when i enter data in form or table it will show me the best match based on
the previous records.

Mosaddeq

 

[pb110005-2351]

hi,

in excel when i start typing data it automatically shows the best match
based on the previous entries in a column. Is it possible in access so
that
when i enter data in form or table it will show me the best match based on
the previous records.

Mosaddeq

 

[Mosaddeq Aziz]

hi,

in excel when i start typing data it automatically shows the best match
based on the previous entries in a column. Is it possible in access so that
when i enter data in form or table it will show me the best match based on
the previous records.

Mosaddeq

 

[Mosaddeq Aziz]

Entering directly into a table? No. On a form you can use a ComboBox to
get that behavior.

thanks for the reply. can u elaborate a bit more.

 

[Mosaddeq Aziz]

Mosaddeq,

You are referring to an Incremental Search. That is not possible in Access
if you are trying to enter data directly into a table. As Rick mentioned it
is possible if you are entering data on a form. The easiest way to implement
an Incremental Search function on a form is to use a ComboBox. It is also
possible to implement an Incremental Search function using a text box on a
form but that requires a high level of VBA experience. If you must have this
function then a ComboBox is usually the better way to go.

A note of caution: An Incremental Search works very nicely in Excel because
the records are probably in main Memory at the time that you are doing the
search. That is not necessarily true in Access. The records will usually be
on a hard drive. This means that a good typist will type faster than the
system can respond and the results are unusable.

This problem is particularly acute for a workstation on a network. Even a
poor typist will overrun the system response time and the users will cease to
use the function. You may very well end up wasting your development time
pursuing this function.

Jack Cannon

Thanks for the info u and Rick has provided. I will test the feature if
it suits me. Thanks again.