Solved

Whizzy control needed!

Posted on 2000-03-14
3
142 Views
Last Modified: 2010-05-02
Hello,

I have developed a utility for our operations team that serves as as a typical  'Explorer' style navigator that lets them track/complete actions on  batches of data that need to be loaded, processed, printed by our AS/400 application.

(It's Basicallymad up of  tree list & list view boxes).

As some of these 'steps' are merely initiated by the 'click' of a command button on the VB app -  the actual request is sent to the AS/400 app and is processed in the background, I need to add a control to the front end that will be periodically updated when AS400 jobs complete/fail etc.

I can return the necessary messages but would like to display them in a more appealing fashion than a run of the mill list box etc.

There must be fancy 'panel' or 'screen'  style control that would be suitable.
Perhaps something that will allow me to load the messages 'ticker tape' style (scrolling right to left).

I am open to suggestions though so all 'creative input' would be greatly appreciated.

50 points for the best looking solution.

Cheers,

Gareth

London

 
0
Comment
Question by:G_Evans
3 Comments
 
LVL 14

Expert Comment

by:wsh2
ID: 2616767
Well.. I don't know about creative.. how about simple.. making a listbox scroll.. <smile>.

<----- Code Begin ----->

List1.AddItem (strMessage)
List1.Selected(List1.ListCount - 1) = True
If List1.ListCount >= 50 _
Then
    List1.RemoveItem (0)
End If

<----- Code End ----->

This is the basis.. you can embellish from there.
0
 

Accepted Solution

by:
Dotar_Sojat earned 50 total points
ID: 2618433
Try this using a textbox of about 20 characters in length and a timer on a form...  You can add error messages to the end of the string using & and a space buffer to separate them.
  You can set the backcolor and forecolor of the text box to whatever you prefer. Here it is set up with a black background and a green foreground to make an LED effect.  If you want, you could even hunt up a dot-matrix style font to add to it.  Set the timer interval to however fast you would like it to run.  The way it is set here adds a character every 200 milliseconds.

---------------------------------------
Option Explicit
     Dim gstrTextScroll As String
Private Sub Form_Activate()
    gstrTextScroll = "Hey!  I'm scrolling!   "
With Text1
    .Text = Space(20)
    .BackColor = vbBlack
    .ForeColor = vbGreen
    .Font.Name = "Terminal"
End With
    Timer1.Interval = 200
End Sub
Private Sub Timer1_Timer()
    Static intTextPos As Integer
    intTextPos = intTextPos + 1
    If intTextPos = Len(gstrTextScroll) Then intTextPos = 1
   
    Text1.Text = Text1.Text & Mid(gstrTextScroll, intTextPos, 1)
    If Len(Text1.Text) > 20 Then Text1.Text = Right(Text1.Text, Len(Text1.Text) - 1)
   
End Sub
---------------------------------------
0
 

Author Comment

by:G_Evans
ID: 2623243
Cheers,

I have implemented your solution and we roll out the application next week!

Cheers,

Gareth London
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access 2016 VB code 9 115
Problem to skip loop 6 56
vbModal 12 51
Excel Automation VBA 19 67
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

813 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now