Solved

progress bar activeX control

Posted on 2003-12-02
3
1,142 Views
Last Modified: 2009-06-17
How can I use the Microsoft Progress Bar active X in my Form. When I put it in my form how can I activate it, link it to a value and get it work.
0
Comment
Question by:HaryMary
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Ryan Chong earned 250 total points
ID: 9864772
Try add the M$ ProgressBar Control from the More Controls button from ToolBox, draw a Progress Bar to your form, named it as progressbar, then draw a command button and named it as Command1, then in the Command1's click event, add the following codes:

Option Compare Database
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

Private Sub Command1_Click()
    progressbar.Max = 100
    progressbar.Min = 1
    progressbar.Value = progressbar.Min
   
    For i = 1 To progressbar.Max - progressbar.Min
        progressbar.Value = progressbar.Value + 1
        Sleep 50
        DoEvents
    Next
End Sub

Is that working? cheers
0
 
LVL 1

Author Comment

by:HaryMary
ID: 9864889
Yes It's Ok.  Thanks a lot
Finally, how can I get information about such ActiveX Controls lik (their available properties, methods...etc).
0
 
LVL 50

Expert Comment

by:Ryan Chong
ID: 9864972
Hi,

Thks for the pts.. By the way, to get the info regarding the ActiveX Control, in design view, simply right click the control, select the ProgCtrl Object > Properties to view its Properties, for methods, sorry, you may need to refer it's method from MSDN. Or if you got the Visual Basic, you can see it's method at Object Browser after you add in the Progress bar control.

Hope this helps

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

786 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