Re: How to code/perform a search

Tech-Archive recommends: Fix windows errors by optimizing your registry

See if there are some useful tips in this link:
http://allenbrowne.com/ser-62.html

rich wrote:
Hello,

I need to perform a search on an employee but don't know very much about
performing searches.

Here is what I believe I should be doing. Please advise if there are other
considerations.

1. User enters the empID or (last name AND first name). Run the select
query.

2. If a matching record is found, Then
populate the form
set a record_found flag
Else
display an appropriate error message
clear and re-display the form
End If
3. If record was found
edit the appropriate fields on the form
update the table with the records that were changed.
End If

I also need to design any appropriate code in case there is an error but
don't know what to consider here.

If you can point me to some quality on-line resources that detail using
ADO so that I can run select, update and delete queries, that would be very
helpful.

TIA,

Rich

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200708/1

.

Quantcast