Pop Up Report does not work in Computer with Officce:2000

[Guest]

I have a Access DB in a Shared drive:

it's running OK,
but in computers that have Officce:2000 I having a problem when I try to
open a Pop Up report because it does not appear in Front of the Form,and I
can't see it.


the DB was created using Office 2003, and on the report Properties there is
the Option "Pop Up" to change it to YES, but when I want to modify this
option in Office 2000, the Option "Pop Up" does not exist.

the Pop Up report in Office 2003, it's running OK since when I open it , it
appear in front of my Form.

could you help me please.

 

[Phillip Windell]

You have to create Databases using the oldest version of Office you expect
to use the DB with. Office 2000 is not going to understand how to deal with
features that may be unique to only Office 2003 and newer. I'm assuming the
Popup feature is one of those things,..I don't know.

 

[Pieter Wijnen]

correct,
you would have to hide/close any forms with the popup property in older
versions to bring the report to front

Sub HandlePopupForms(ByVal Show as Boolean)
Dim frm AS Access.Form
For Each Frm in Access.Forms
If Frm.Popup = True Then
Frm.Visible = Show And Frm.Tag <> "HideAlways" ' caveat: Tag Property
could br NULL in Access 2.0
End If
Next

(Typing from the top of my head)

You could use this func in the opening code + the reportClose Event of all
MS Access versions since 2.0
hint: check this out as well:
Declare Function IsWindow Lib "User32" (ByVal hWnd As Long) As Boolean

HTH

Pieter

You have to create Databases using the oldest version of Office you expect
to use the DB with. Office 2000 is not going to understand how to deal
with features that may be unique to only Office 2003 and newer. I'm
assuming the Popup feature is one of those things,..I don't know.

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com

I have a Access DB in a Shared drive:

it's running OK,
but in computers that have Officce:2000 I having a problem when I try to
open a Pop Up report because it does not appear in Front of the Form,and
I
can't see it.


the DB was created using Office 2003, and on the report Properties there
is
the Option "Pop Up" to change it to YES, but when I want to modify this
option in Office 2000, the Option "Pop Up" does not exist.

the Pop Up report in Office 2003, it's running OK since when I open it ,
it
appear in front of my Form.

could you help me please.

--