Sound and labels rotates no longer works correctly

Posted on 2014-01-24
Last Modified: 2014-01-27
I have an 80 number keno game and on a win 2 labels rotate up to the amount won
at the same time a sound plays at the same time and the sound stops when the labels stop rotating.
This has worked in the past, but now the labels do not rotate until the sound has stopped.
 i cannot determine why. the code:

Dim miCnt As Long' form level variable

Sub AddRunWinning(AmountWon As Currency) 
mEndNum = AmountWon

        miCnt = 1
        Timer1.Interval = 60
        Timer1.Enabled = True
        'Play the ADDINGWINNINGS.wav file frome the resource file
        sndData = LoadResData("ADDINGWINNINGS", "SOUND")
        sndPlaySound sndData(0), SND_LOOP Or SND_ASYNC Or SND_MEMORY

End Sub

Private Sub Timer1_Timer() 
Dim lblcreditcurrency As Currency
lblcreditcurrency = GetPriceByBetMode(mBetMode)
  Debug.Print "miCnt " & miCnt
        If miCnt <= mCreditsWon Then
            lblWinThisRun.Caption = lblWinThisRun.Caption + 1
          If mCreditMode = 1 Then' currency
            lblCredit.Caption = CCur(lblCredit.Caption) + lblcreditcurrency
            lblCredit.Caption = Format(lblCredit.Caption, "currency")
            miCnt = miCnt + 1
            lblCredit.Caption = Val(lblCredit.Caption) + 1
            miCnt = miCnt + 1
          End If
             Timer1.Enabled = False
            'Stop the Sound
            sndPlaySound ByVal 0, 0
        End If
End Sub

Private Function GetPriceByBetMode(ByVal betMode As Integer) As Double
    Select Case betMode '1cent, 2cents etc
        Case 0
           GetPriceByBetMode = 0.01
        Case 1
           GetPriceByBetMode = 0.02
        Case 2
           GetPriceByBetMode = 0.05
        Case 3
           GetPriceByBetMode = 0.1
        Case 4
           GetPriceByBetMode = 0.25
    End Select
End Function

Open in new window

What is wrong ?
Question by:isnoend2001
  • 3
  • 3
LVL 29

Expert Comment

ID: 39808313
Couple of questions
I tried to get your code to work but missing following:

What is the interval of the timer ?
I am missing a sub sndPlaySound

and what is the initial value of lblcredit and lblwinthisrun

as if I get both to be 0 the routine stops when they are both 1 How should it work ?

Author Comment

ID: 39808638
Private Declare Function PlaySoundData Lib "winmm.dll" Alias "PlaySoundA" (lpData As Any, ByVal hModule As Long, ByVal dwflags As Long) As Long
Const SND_ASYNC = &H1 ' /* play synchronously (default) */
Const SND_NODEFAULT = &H2 '/* silence (!default) if sound not found */
Const SND_MEMORY = &H4 '/* pszSound points to a memory file */
Const SND_LOOP = &H8 '/* loop the sound until next sndPlaySound */

What is the interval of the timer ? Line 8

and what is the initial value of lblcredit and lblwinthisrun
lblcredit, could be any value
lblwinthisrun;could be any value
lblwinthisrun;always starts at 0 and is increased by the amount of the win
lblcredit,could be any value, but is increased by the same win amount
The problem is the labels and sound should both run at the same time.
I start the timer before the sound, but the timer does not fire until after the sound plays.
I confirmed this by putting a brake at lblcreditcurrency = GetPriceByBetMode(mBetMode) in the timer, but it does not hit the break point until the sound stops

Author Comment

ID: 39808673
I have found a work around by putting label rotation and sound both in the timer
Private Sub Timer2_Timer()
    If iCnt <= mEndNum Then
        lblWinThisRun.Caption = iCnt
        LblCredit.Caption = LblCredit.Caption + 1

If mbStop <> True Then ' form variable
      sndData = LoadResData("ADDINGWINNINGS", "SOUND") 'load from resource file
    sndPlaySound sndData(0), SND_LOOP Or SND_ASYNC Or SND_MEMORY
    mbStop = True
 End If
    iCnt = iCnt + 1
        iCnt = 1
        Timer2.Enabled = False
        'Stop the Sound
        sndPlaySound ByVal 0, 0
    End If
    End Sub
Tried all kinds of corrections to code that worked previously
Deleted Timer1 and put a new timer and named itTimer1
Put a new Timer2 and coded that
Break point on the timer to be sure it was firing after the sound stopped.
All to no avail
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

LVL 29

Accepted Solution

gowflow earned 500 total points
ID: 39810418
ok I just made-up a new project and zipped it.
Once you open it rename the file
as it is not accepted by EE to upload.

run the project and tell me if this is what your looking for.

Author Closing Comment

ID: 39810826
i am giving you the points for your efforts. I have working example the way it is written in my question. The question remains why does the timer not start when the sound does.
don't know what programs open .SCC files my vb6 files are .vbp
LVL 29

Expert Comment

ID: 39811292
you may delete the file with .txt and simply run the vbp project. did you try the project I uploaded ?

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article ( for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question