POP up report

[leecsone]

HI


I have a switchboard with six buttons.Now I have the switchboard to pop up when it us open. I have the forms to pop up on top of the switchboarb when opened. How do I get the report to pop on top of the switchboard when opened.


Thank You

leecsone.

 

[Fornatian]

Off the top of my head you could put a sub in the report open and close events to hide the forms windows...

Private Sub Report_Close()
[COLOR=green]'show all open forms again[/COLOR] 
SetVis True
End Sub

Private Sub Report_Open(Cancel As Integer)
[COLOR=green]'hide all open forms[/COLOR] 
SetVis False
End Sub

Private Sub SetVis(blnVisible As Boolean)

Dim frm As Form [COLOR=green]'object[/COLOR] 
For Each frm In Forms [COLOR=green]'loop thru collection[/COLOR] 
[COLOR=green]'set visible property to passed argument[/COLOR] 
frm.Visible = blnVisible
Next frm [COLOR=green]'go again[/COLOR] 
End Sub

 

[leecsone]

pop up report

HI Fornatian

This code did not work. may be I placed the code in the wronrg place. I placed the code in eht event on open and than on close than both. Please advise.

 

[Fizzio]

The code Sub SetVis should be in its own module, not in a report's open or close event - this is because you want it available to everything.

 

[leecsone]

pop up report

HI Fizzio

I am new at so bear with me here. I place the code in its own module. so how do I link this to the report to have it pop on top or the switchboard .

 

[Fizzio]

Just use the code Fornation provided you with originally - He outlined what to put in the report_open and report_close events to trigger the visiibility code.

any clearer?

 

[leecsone]

pop up report

HI


I place the code in both the open and close event but nothing happened. the report did not show at all. please advise.

Thanks

 

[Fizzio]

Can I just clarify what you are trying to pop up in front of the switchboard, a form or a report?

 

[leecsone]

pop up report

A report

 

[leecsone]

pop up report

HI

If you think I am a dope you might be right. I found out what I was doing wrong. I wonted the switchboard when open to appear without the database window. So I used the pop up and hid the database window behind the switchboard. I wonted my forms to pop up in front of the switchboard which all worked fine I wonted my reports to pop up in front of the switchboard like the form did but that did not work. Now what I didn’t know was that I could right click on the database window go to set-up and untic display database window select the switchboard in database form. I untic the pop up for the switchboard and now everything pops up in front of the switchboard.

Where you guys ever like you or me all born smart.

Now that I kicked myself in the but I have other question?
How do I take the zoom of the report?

 

[Fizzio]

We were all born smart

What zoom?

 

[Fornatian]

It's a Chris Tarrant(UK Who Wants To Be A Millionnaire) thing - it's only easy when you know the answer. ::COUGH::

 

[leecsone]

zoom

HI Fizzio


Zoom is the magnification of the report. I have a magnifying glass as my pointer. How do I do away with it.




Thank You

leecsone

 

[Fornatian]

Check out the MousePointer help in VBA used as in:

Screen.MousePointer = 1 'arrow

 

[leecsone]

pop up report

HI Fornatian

I like that but that is not what I mean. The report is viewed in print preview. How can I view the in normal mode?


Thank you


leecsone.

 

[Fornatian]

When you say normal mode, what do you mean - you want to open the report in design view? If so...

DoCmd.OpenReport "YourReport", acViewDesign

Note: There are 3 constants when opening a report:

acViewDesign = DesignView
acViewPreview = PreviewMode
acViewNormal = Sends To Printer

 

[leecsone]

zoom

HI Fornatian


What I wont to do is, once the report shows up I wont to do a find on the report that will take me to the name I wont to see.
I can not do this because as I click on the report the report zooms to 25% I click again the report zooms back to 100%. How can I put a stop to this.


Thank you

leecsone.

 

[Fornatian]

As far as I am aware you cannot find a particular on a report and move to that page. You can move to a particular page but because reports can be varying heights this is not a suitable solution. The best I can suggest is to limit the report to display only your desired record. This would not mean a separate report as you could add a where clause to the OpenReport method at run time.

If that's not satisfactory, try opening another thread for this particular question as you will get a wider audience than an much replied thread.