R
rich
Hello,
I am a fairly novice Access programmer looking for best practices/examples
on building a search form. Also, on checking for the result of a query.
I would like to build a form that queries for and displays an employee
record. There should be 2 ways to query: By the employee number, if it is
known, or by the lastname and firstname (2 fields) if the ID number is
unknown.
Also, is there a way to check the result of a SQL query?
For examply, if the query finds a matching record, an internal code is set
to 100.
If now matching row is found, the code might be set to 999.
Lastly, does Access have a schema or system catalog that can be queried
similar to SQL Server?
TIA,
Rich
I am a fairly novice Access programmer looking for best practices/examples
on building a search form. Also, on checking for the result of a query.
I would like to build a form that queries for and displays an employee
record. There should be 2 ways to query: By the employee number, if it is
known, or by the lastname and firstname (2 fields) if the ID number is
unknown.
Also, is there a way to check the result of a SQL query?
For examply, if the query finds a matching record, an internal code is set
to 100.
If now matching row is found, the code might be set to 999.
Lastly, does Access have a schema or system catalog that can be queried
similar to SQL Server?
TIA,
Rich