Hi, Kevin.
Do you guys have any links on how to make a class from scratch.
Sorry. I didn't learn how to build a VBA class like that. I found a class
module someone I worked with copied from a class someone else wrote, figured
out what worked, what didn't, and why, then used the basic structure as a
template for my own classes.
Don't you have any VBA class examples handy as examples? If not, the
ComDlg.cls listing currently located on the following Web page is what got me
started:
http://msdn.microsoft.com/library/d...ry/en-us/dnovba00/html/CommonDialogsPartI.asp
I had to fix the typos and modify it for Access 97, because VBA 5.0 doesn't
have the Join( ), Split( ), or Replace( ) functions, nor ENUM, that VBA 6.0
does. It will be far less work for you to get it going in Access 2K if you
want to play with it.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.