Newbie Help with Form Record Look Up

[fmulvaney]

I'm totally new to Access. I've been asked to set up a simple contact
database to track calls and mailings to a list of people. I created tables,
linked them together and set up a form where each record's information can be
found. Now I simply want to have a field where the user would type in a
record's social security number or name and the record would come up on the
screen. The only way I see to look up a record right now is using the record
count box at the bottom of the page. Thank you for any help you can provide.

 

[Allen Browne]

If you anticipate no more than a few thousand people, you could use a combo
in the form header to bring up the record for the person.

See:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

If you want the user to be able to select which field to search by, see:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
You can use this one on any form by copying 2 controls and setting one
property.

 

[fmulvaney via AccessMonster.com]

This worked great for me...Thank you!

If you anticipate no more than a few thousand people, you could use a combo
in the form header to bring up the record for the person.

See:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

If you want the user to be able to select which field to search by, see:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
You can use this one on any form by copying 2 controls and setting one
property.

I'm totally new to Access. I've been asked to set up a simple contact
database to track calls and mailings to a list of people. I created

[quoted text clipped - 8 lines]

count box at the bottom of the page. Thank you for any help you can
provide.

 

[fmulvaney via AccessMonster.com]

Sorry, I have a related question to the utility you provided. I used your
AppFindAsUType utility. The utility works great. I have a question though.
I’m setting this database up for a data entry person in our office to record
calls and correspondence with a group of people. I set your utility to
search for “Name†or “Social Security Number†from the database. If I type
in a Social Security Number that doesn’t exist I receive an error “error 2105:
You can't go to the specified record.†The form fields disappear and there
doesn’t seem to be a simple way to return to the form. Can I do something
that would simply alert the person that the record is not found and return
them to the beginning record so they can try again?

If you anticipate no more than a few thousand people, you could use a combo
in the form header to bring up the record for the person.

See:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

If you want the user to be able to select which field to search by, see:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
You can use this one on any form by copying 2 controls and setting one
property.

I'm totally new to Access. I've been asked to set up a simple contact
database to track calls and mailings to a list of people. I created

[quoted text clipped - 8 lines]

count box at the bottom of the page. Thank you for any help you can
provide.

 

[Allen Browne]

Are you saying that the entire Detail section of the form goes blank when no
records match?

If so, see:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html

The solution will be to avoid the situation that causes the combination of
no-records + cannot-add-records.
--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Sorry, I have a related question to the utility you provided. I used your
AppFindAsUType utility. The utility works great. I have a question
though.
I’m setting this database up for a data entry person in our office to
record
calls and correspondence with a group of people. I set your utility to
search for “Name†or “Social Security Number†from the database. If I
type
in a Social Security Number that doesn’t exist I receive an error “error
2105:
You can't go to the specified record.†The form fields disappear and
there
doesn’t seem to be a simple way to return to the form. Can I do something
that would simply alert the person that the record is not found and return
them to the beginning record so they can try again?

If you anticipate no more than a few thousand people, you could use a
combo
in the form header to bring up the record for the person.

See:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

If you want the user to be able to select which field to search by, see:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
You can use this one on any form by copying 2 controls and setting one
property.

I'm totally new to Access. I've been asked to set up a simple contact
database to track calls and mailings to a list of people. I created

[quoted text clipped - 8 lines]

count box at the bottom of the page. Thank you for any help you can
provide.