Writing Access functions

[new2access123]

I am an old FoxPro programmer (but have been out of programming for many years) and I have been through the Access basics that I have been able to find on line. So I can create tables, forms enter data the basics. I am learning VBA no problem there. Now I want to write some functions. I would like to write one function that is passed an ID and returns the last name of the person having that ID. I would like to write this function in two ways:

1. Connect to a table in my DB find the ID and return the name
2. Have the function perform a query that returns a record set from which the name is returned.

Does any one know where I can find some straight forward simple examples demonstrating this?



This is a training exercise for me to learn how to:
* Connect to tables and process data
* Create a record set and process data from the recordset
* Use debugging techniques breakpoints, run code from the immediate window etc.

I would really appreciate the help

Thanks

[llkhoutx]

Litwin & Getz's Access (2002 or2000) Developers Handbook, Desktop Edition is an excellent hornbook.

[new2access123]

Thank you. I will find it.

[llkhoutx]

You can find it used on amazon.com for about $10. Be sure to get the "Desktop Edition" (first, you'll want the other volumes too).

[new2access123]

Thanks. I'll get the books there.

[llkhoutx]

There are VBA, Desktop and Enterprise volumes. All are useful. I found the Desktop volume most useful, so will you. The Enterprise volume is good for multi-user apps and Access security. You might find the books as a set; CD for each volume (canned code) may be available.

The 2002 edition is marginally better than the 2000 edition.

I have a set for home and one for the office. the solutions they contain apply to all versions. A2K upward has more functionality.