Hi,
During process of connecting tables from SQL Server which normally takes few seconds(let us say around 30 seconds) I planned to add a progress bar on my main login form. I have downloaded a bunch of lengthy code that stored in a module.
Moreover,below code placed onclick btn of login form
Code:
Private Sub cmdDWood_Click()
On Error GoTo Err_cmdDWood_Click
Const DELAY As Single = 0.1 ' Progress Bar
Dim intCnt As Integer
Dim sngTimer As Single
Dim cProg As New ClsLblProgress
With cProg
.Initialize lblback, lblfront, lblcaption
.Max = 50
End With
For intCnt = 1 To 50
sngTimer = Timer
Do While Timer < sngTimer + DELAY
DoEvents
Loop
cProg.Increment
Next intCnt
further code is here...
While compiling the code it is produced compile error User-defined type not defined on following line before I go ahead...
Dim cProg As New ClsLblProgress
Can someone please advise?