By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,379 Members | 3,035 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,379 IT Pros & Developers. It's quick & easy.

-> POP-UP FORM with PROGRESSBAR while LOOPING recordset

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
"@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 discussion thread is closed

Replies have been disabled for this discussion.