A point of concern for him is that in addition to Excel VBA, he must program with Access VBA. I’ve made no secret of my distaste for non-Excel object models. Nevertheless, once you learn the idiosyncrasies of Access, you’ll have no problems. Here’s some advice:
If an intuitive object/method can’t be found (like Forms.Open), it’s probably under the DoCmd object.
You can’t change the properties of a form’s controls unless that control has the focus.
Learn what DAO and ADO are, and use DAO inside Access.
Learn the .FindFirst method, you’ll use it a lot.
Always split your database between a front end and a back end.
Get used to this:
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim sqlMyQuery As String
sqlMyQuery = “SELECT * FROM tblMyTable”
Set db = CurrentDb
Set rs = db.OpenRecordset(sqlMyQuery)
If Not (.BOF And .EOF) Then
‘do something with the current record
Me.tbxMyTextBox = .Fields(“MyField”).Value
.MoveNext ‘For the love, don’t forget this line
Loop Until .EOF
Set rs = Nothing
Set db = Nothing
The Access MVPs are great, so don’t be shy about posting your questions on the Access newsgroups. Everyone help a brother out and leave your Access tips and links to your favorite Access sites.