Databaseguy
MIS
Hi All.
I'm well versed in Access and VBA (I know I know, boo, hiss) and I am expanding my knowledge by learning VB.
I've learned to create a public function, and reference it in my queries. Our companies fiscal months end on the last Saturday of the month.
I took it one step further, and compiled it into a DLL. In the Object Browser window, my Class shows (clsWhatMonth) and it has three Methods, WhatMonth, LstSaturday and FirstSunday.
However, I can only use it by first declaring it, as follows:
Private Sub TestMyDLL()
Dim NewWhatMonth As New clsWhatmonth
MsgBox NewWhatMonth.WhatMonth(Now())
End Sub
My whole idea was to add a reference, and use it as you would an intrinsic function. Am I missing something here, or am I always going to have to declare and instanciate it ?? Tyrone Lumley
augerinn@gte.net
I'm well versed in Access and VBA (I know I know, boo, hiss) and I am expanding my knowledge by learning VB.
I've learned to create a public function, and reference it in my queries. Our companies fiscal months end on the last Saturday of the month.
I took it one step further, and compiled it into a DLL. In the Object Browser window, my Class shows (clsWhatMonth) and it has three Methods, WhatMonth, LstSaturday and FirstSunday.
However, I can only use it by first declaring it, as follows:
Private Sub TestMyDLL()
Dim NewWhatMonth As New clsWhatmonth
MsgBox NewWhatMonth.WhatMonth(Now())
End Sub
My whole idea was to add a reference, and use it as you would an intrinsic function. Am I missing something here, or am I always going to have to declare and instanciate it ?? Tyrone Lumley
augerinn@gte.net