Complex question even for a programmer

[StefanScheidegger]

Hi there

I have the following on a form:

- 1 main form
- 1 subform
- 1 other subform (this subform has just informative information for the user)
- 1 command button (opening a complex report


Here now my problem:

- Due to the complexity of the report (report is a dynamic heading report based on a crosstab), opening this report may take up to 5 minutes. Therefore I would like to include an ActiveX ProgressBar on the form where the command button to open the report is included.
- The report should only be shown as shown when the ActiveX Progress Bar is full.
- which codes (if possible with a sample) have to be added where on the form. Im am really lost on this issue.


FYI, Here the current code of the command button:

Private Sub ZuBericht_Click()
On Error GoTo Err_ZuBericht_Click

Dim stDocName As String

stDocName = "Bericht"
DoCmd.OpenReport stDocName, acPreview

Exit_ZuBericht_Click:
Exit Sub

Err_ZuBericht_Click:
MsgBox Err.Description
Resume Exit_ZuBericht_Click

End Sub



Thank you so much in advance for your help on this very tricky issue.

Stefan.

 

[mp9]

Why use an ActiveX control-based progress bar? WHy not use the inherent Access one? Check out SysCmd method in Access help for more info on how this can be achieved.

http://www22.brinkster.com/accessory/

 

[mrf1xa]

Very similar coding can be used to run the ActiveX control available from the toolbox under 'more tools' and I have used this simply because I preferred to have the progress bar on my form rather than the status bar.

However, it seems to rely on opening a recordset and monitoring the progress looping through it. Fine for my original needs (updating values in a table). However, maybe i am being very thick, but I can't see how to use either of these to display the progress in opening a report based on a query, which is what I would now like to do (and so would the original poster).

Can you tell me what I've missed please? Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

 

[mrf1xa]

Hi

I have implemented the ActiveX progress bar available from the Access toolbox under 'more tools'. It uses very similar code to that described in the Help topic referred to above- I simply used it because I preferred to have the bar on the form instead of the status bar. This was for updating values in a table.

However, I would now like to use another to monitor the opening of a report based on a query, same as the original poster here. I may be missing the obvious, but I can't see how to pass the update value to the progress bar in these circumstances.

Can someone tell me what I'm missing please.

Thanks Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....