Welcome Screen

[FREDDY67]

I am helping my niece out with her school project, the part we are struggling with is to spell out "WELCOME" on the screen. The way we have gone is a sleep gap between displaying controls, but there is a focus issue. I have attached a basic db showing the issue, if you open Form1 is design view and then switch to form view it will work and then throw an error.

Any assistance with this or other ways of automatically spelling a word out on a screen would be appreciated.

Many Thanks

Freddy & Hannah

 

[HiTechCoach]

What does the courseware say about how to do this?

We may be able to show you how to do it, but it may not be the correct way for the lesson to learn the proper skills.

 

[FREDDY67]

Boyd

According to Hannah there are no specifics on how to do this, it sounds like the teacher will usually go through all the pupils results with the class and discuss the positive & negative issues .

Many Thanks

Freddy & Hannah

 

[DCrake]

For a start Why are you using non Access controls? such as Acardia Power buttons.

Anyway lets continue. Suppose these buttons were individual labels. You could set your form TimerInterval to say 400 then on the form Timer event you could have the following code

If Me.LblW.Visible = False Then
   Me.LblW.Visible = True
ElseIf Me.LblE.Visible = False Then
   Me.LblE.Visible = True
ElseIf Me.LblL.Visible = False Then
   Me.LblL.Visible = True
ElseIf Me.LblC.Visible = False Then
   Me.LblC.Visible = True
ElseIf Me.LblO.Visible = False Then
   Me.LblO.Visible = True
ElseIf Me.LblM.Visible = False Then
   Me.LblM.Visible = True
Else
  Me.TimerImterval = 0
  Me.LblZ.Visible = True
End If

So every 400 milliseconds it checks the visible status of each letter in turn and makes it visible. Note due to there being 2 E's in Welcome I have used Z instead. This is just a naming convention thingy. Also notice that once the last letter has been made visible it sets the timer interval to zero. This stops the timer event from firing repeadly even afer all letters are visible.

Thi scould be improved upon by using a loop statement but as this is for assessment the use of advanced programming would tend to give the impression that the student has seeked professional advice, and as such, if it was me, I would mark the student down.

David

David

 

[FREDDY67]

David

Thank you for your help, the method is great as we started of with trying "if visible" but we got it totally wrong because all we ended up doing was delaying the form opening until the timer had finished & all letters were visible on opening, therefore Hannah understands this process which is the desired result.

Many Thanks

Freddy & Hannah

 

[DCrake]

You still never mentioned about the buttons?

 

[FREDDY67]

Apparently the buttons were part of a package purchased for the PowerComboBox functionality, I have used the buttons as we have a template library for them & never had an issue with them.

Freddy

 

[DCrake]

Freddy,

Word of advice, if the controls you are using are a part of a suite of controls, which I assume they are, if they only exist on you development machine when you come to submit your mdb the controls will not be on the host machine, as was the case when I opened your sample, the teacher will not be able to test your results. Unless you have something in place that will register the controls on the host machine I would shy away from using them.

I appreciate that they may have added functionality of Access controls but if the user cannot take advantage of them, what's the point of including them.

If they are registered on the host machine then fair enough use them. Just a cautionary piece of advice, that all.

David

 

[FREDDY67]

David

Thanks for the advice, it's appreciated.

Freddy