D
Donna
Hello,
I have been using Access for many years and am always learning something
new. I also struggle many times simply because I don't know how to properly
code something in VBA. There are many books on Access and most of them
include the fundamentals. I am looking for a more advanced level. I recently
bought Using MS Access 2003 by Roger Jennings. It looks like a good
reference book, but still not exactly what I was looking for.
Currently, the applications that I developed revolve around tracking costs,
making scheduled payments, keeping up with coal and lignite leases, royalty
payments, landowners, permitting and another area I developed is for safety
training, accidents, employee awards. The databases are on a small scale.
I have not had any formal training, self-taught, learn as I go. I live in a
rural area and work full time. I gain a lot of knowledge from the newsgroups
here, the MVP's are so knowledeable and the questions that get posted here
are very interesting and challenging.
I would like to learn more along the lines of developing user interface that
is user-friendly for novice to experienced user.
I would like to understand how to use some of the library references, such
as the calendar control. There are lots of other objects that I have never
tried to use.
I want to learn more about making selections from lists or combo boxes. I
recently made a form with a drop down list to choose a name, then the user
selects the time frame for the report from an option group, and yet another
selection from an option group for a detail or a summary report, then the
user can select to do a print preview or print the report(s). I wanted to
use VBA code, but never could figure out how to write it out, so I ended up
using macros. It works great, but I really struggled with the Where
argument. I understand the logic, just don't know how to write it out
properly.
How do you learn to tap into the "next level" of Access? What other
resources are out there? I have a great admiration and appreciation for all
of you, and thank you in advance for your suggestions.
Donna
I have been using Access for many years and am always learning something
new. I also struggle many times simply because I don't know how to properly
code something in VBA. There are many books on Access and most of them
include the fundamentals. I am looking for a more advanced level. I recently
bought Using MS Access 2003 by Roger Jennings. It looks like a good
reference book, but still not exactly what I was looking for.
Currently, the applications that I developed revolve around tracking costs,
making scheduled payments, keeping up with coal and lignite leases, royalty
payments, landowners, permitting and another area I developed is for safety
training, accidents, employee awards. The databases are on a small scale.
I have not had any formal training, self-taught, learn as I go. I live in a
rural area and work full time. I gain a lot of knowledge from the newsgroups
here, the MVP's are so knowledeable and the questions that get posted here
are very interesting and challenging.
I would like to learn more along the lines of developing user interface that
is user-friendly for novice to experienced user.
I would like to understand how to use some of the library references, such
as the calendar control. There are lots of other objects that I have never
tried to use.
I want to learn more about making selections from lists or combo boxes. I
recently made a form with a drop down list to choose a name, then the user
selects the time frame for the report from an option group, and yet another
selection from an option group for a detail or a summary report, then the
user can select to do a print preview or print the report(s). I wanted to
use VBA code, but never could figure out how to write it out, so I ended up
using macros. It works great, but I really struggled with the Where
argument. I understand the logic, just don't know how to write it out
properly.
How do you learn to tap into the "next level" of Access? What other
resources are out there? I have a great admiration and appreciation for all
of you, and thank you in advance for your suggestions.
Donna