There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.
Solved
Controls on a form not HIDING as they should
Posted on 2016-10-04
I have a simple form plays an audio file to ask a child a question. While the audio is playing I wanted to hide two images that represent a YES and NO for them to touch their answer.
My problem is when the code is in the same SUB as the audio file player, it won't hide it. It will UNHIDE them after the audio plays.... and I can use the exact same line by itself from a button and it works. (Me.Image19.Visible = False)
My problem is when the code is in the same SUB as the audio file player, it won't hide it. It will UNHIDE them after the audio plays.... and I can use the exact same line by itself from a button and it works. (Me.Image19.Visible = False)
Private Sub DinoImage_Click()
On Error GoTo ButtonError
Me.Image19.Visible = False
Me.Image20.Visible = False
Dim stID As String
stID = Me.ID.Value
sndPlaySound "C:\HospitalIntake\Audio\Q" & stID & ".wav", SND_ASYNC
Me.Image19.Visible = True
Me.Image20.Visible = True
Exit Sub
ButtonError:
DoCmd.Echo True
DoCmd.SetWarnings True
Dim stErrMSG As String
stErrMSG = MsgBox(Err.Description)
End Sub
-
2
3 Comments
Active today
Generally, I don't hide buttons, instead I would set the Enabled property to true or false.
Try inserting a line:
DoEvents
or possibly
Me.Repaint
right before the line that plays the sound file.
Try inserting a line:
DoEvents
or possibly
Me.Repaint
right before the line that plays the sound file.
"Me.Repaint" did it thanks.
I agree, most of the time switching ENABLE to false is good enough. But they're going to be handing these tablets to pretty small kids. Thought it better to just hide them while question is playing. Some of the questions are longer than others, didn't want them trying to answer before entire question has been read.
Thanks again.
I agree, most of the time switching ENABLE to false is good enough. But they're going to be handing these tablets to pretty small kids. Thought it better to just hide them while question is playing. Some of the questions are longer than others, didn't want them trying to answer before entire question has been read.
Thanks again.
Featured Post
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Implementing simple internal controls in the Microsoft Access application.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month3 days, 21 hours left to enroll
589 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.