473,320 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

-> POP-UP FORM with PROGRESSBAR while LOOPING recordset

Hellow programmers,

does anybody has any suggestions for the next problem?

I'm looping a recordset and during the loop it allso calculate some
things.
Now I want display a POPUP FORM with PROGRESSBAR. The maxvalue is the
recordsetcount and every loop is value + 1. How can i pass these value
to the POPUP form. I've somthing with public tel but it won't work!

Thanx anyway
Nov 13 '05 #1
1 2750
"@ndy" <an*******@hotmail.com> ha scritto nel messaggio
news:6c**************************@posting.google.c om...
Hellow programmers,

does anybody has any suggestions for the next problem?

I'm looping a recordset and during the loop it allso calculate some
things.
Now I want display a POPUP FORM with PROGRESSBAR. The maxvalue is the
recordsetcount and every loop is value + 1. How can i pass these value
to the POPUP form. I've somthing with public tel but it won't work!

Thanx anyway

You have many way to do this, some of them:

1)Use OpenArgs like OpenForm Method Property(see on Help)
on POPUP Load Event you can get with Me.OpenArgs the value.
It's a String value, but clng(Me.OpenArgs), then set the Max.

2)Use a specific Form Property using Public Property

Private mMax as Long

Property Let Max(value As Long)
mMax = value
End Property

After POPUP is Open with Docmd.Open...... bla bla
Forms!PopupName.Max=Rs.RecordCount

Then on POPUP Form PBar Setting procedure :
Pb.Max=mMax

Bye.
--
@Alex (Alessandro Baraldi)
---------------------------------------------------------------------------
http://www.sitocomune.com/
http://www.mantuanet.it/alessandro.baraldi/
---------------------------------------------------------------------------
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Xenophobe | last post by:
I have a popup window (required by the client) containing a form and would like to prevent users from accessing it directly. They are instead required to access the page via a hyperlink on another...
0
by: RookieCard | last post by:
I've been stuck on this for 2 days. Here's the deal. I am working (3 levels down/deep)in a subform within a tab object that is within another tab obeject. Everything works great! Except here: 1)...
4
by: SteveS | last post by:
Hello. This is a strange problem which does not make sense to me. I open a popup page with the following javascript code: function OpenDenyWindow(changeId) {...
18
by: Colin McGuire | last post by:
Hi - this was posted last weekend and unfortunately not resolved. The solutions that were posted almost worked but after another 5 days of working on the code everynight, I am not further ahead....
4
by: Macbane | last post by:
Hi, I have a 'main' form called frmIssues which has a subform control (named linkIssuesDrug) containing the subform sfrmLink_Issues_Drugs. A control button on the main form opens a pop-up form...
9
by: rousseaud | last post by:
I'm having some trouble getting popup forms to work properly. I have a main form that contains 4 fields that I want to fill in by using a series of 4 popup forms that I initiate by clicking a...
7
by: EManning | last post by:
I have an A2003 database linked to SQL Server 2005. My problem is with a popup form with a filtered table as a recordsource. I set the filter with an SQL statement like this: SELECT * FROM...
2
by: harvindersingh | last post by:
Hello guys, I am developing a Windows Forms application in C#, I am using PostgreSQL as the Database. The application is bassically using the database to store and lookup information, nothing so...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.