Hi,



  I have created a form in which the user can slect a report to print out. 

I am using Access 2000 and the form, ReportsMenu, contains controls that 

the queries for the reports use, so I can close the form. The user wants 

to "preview" the report and then print.All well and good. The problem that 

I have is I can sucessfully minized the Report Selection form, but when 

the user is done printing or closed the reprot using the close box, how 

can I get the ReportFOrm to automagically pop back up ?? I tried using the 

reports close event and no go. Any suggestiosn would be appericated,

thank you  :-)

marthaj@r...

Rather than minimize your ReportsMenu form, you can hide it by setting it's

visible property to False (e.g., Me.Visible = False).  Then you should be

able to make it visible again in the Close event of the proper report with a

statement like:



Application.Forms("ReportsMenu").Visible = True



Hope that helps.



-Roy



P.S. Do you need to bother hiding or minimizing this form at all?  Doesn't

the report open up on top of the form & hide it?  Then when the user closes

the report, the form comes back to the fore?



-----Original Message-----

From: Martha J Sayers [mailto:marthaj@r...]

Sent: Thursday, September 06, 2001 11:44 AM

To: Access

Subject: [access] forms and rports





Hi,



  I have created a form in which the user can slect a report to print out. 

I am using Access 2000 and the form, ReportsMenu, contains controls that 

the queries for the reports use, so I can close the form. The user wants 

to "preview" the report and then print.All well and good. The problem that 

I have is I can sucessfully minized the Report Selection form, but when 

the user is done printing or closed the reprot using the close box, how 

can I get the ReportFOrm to automagically pop back up ?? I tried using the 

reports close event and no go. Any suggestiosn would be appericated,

thank you  :-)

marthaj@r...

Roy,



 Thank you so much for responding. I am going to try your suggesstion.

  The report pops up "behind" the reportmainmenu form and I honestly don't

know why it's doing that. I always (in 97)  had it pop-up in front of the

form trhat called it.

Any ideas ??  It's displayed in "preview" mode and I use a cutomized menubar

that alllows printing, page settings etc.

thank you again,

marthaj@r... :-)

Interesting--perhaps your form is opening modally?  If so, is it practical

to change that?



-----Original Message-----

From: Martha J. Sayers, A.A.B. [mailto:marthaj@r...]

Sent: Thursday, September 06, 2001 5:44 PM

To: Access

Subject: [access] RE: forms and rports





Roy,



 Thank you so much for responding. I am going to try your suggesstion.

  The report pops up "behind" the reportmainmenu form and I honestly don't

know why it's doing that. I always (in 97)  had it pop-up in front of the

form trhat called it.

Any ideas ??  It's displayed in "preview" mode and I use a cutomized menubar

that alllows printing, page settings etc.

thank you again,

marthaj@r... :-)

Roy,



  Your suggestion worked great !! I have forgotten so much in Access since I

have not worked in about 2 years...Now, I will see if it works on the users

machine... acouple of things don't work. I have one workstation inwhich I

compeltely uninstalled 200, re-install (about 3 time) and I have 3 pages

that do not work. Okay on all other machiens. It's split so the front-end

runs on the workstation. And another thing with this workstation is if I

click on link Manger, it doesn't show any tables. I have to copy it from

another workstation, yet those 3 forms won't work on this workstation. Okay

elsewhere. It is driving me nuts and I sure as heck don't know what to do. I

can not use form design etc. But it says it completely uninstalls it. Any

clues ??

thanks so much :-)

marthaj@r...

I have had a similar problem to this.  I open the

original form as maximised with a control button to

view a report in print preview.  When I close the

print preview the form has shrunk, restored.  As I

have made the min/max buttons not accessable to the

user I am left with a messy screen that does not re

maximise.  I don't have any commands in to close, hide

or restore the original form. I have no idea how to

stop this.



 --- "Pardee, Roy E" <roy.e.pardee@l...> wrote: >

Rather than minimize your ReportsMenu form, you can

> hide it by setting it's

> visible property to False (e.g., Me.Visible 

> False).  Then you should be

> able to make it visible again in the Close event of

> the proper report with a

> statement like:

> 

> Application.Forms("ReportsMenu").Visible = True

> 

> Hope that helps.

> 

> -Roy

> 

> P.S. Do you need to bother hiding or minimizing this

> form at all?  Doesn't

> the report open up on top of the form & hide it? 

> Then when the user closes

> the report, the form comes back to the fore?

> 

> -----Original Message-----

> From: Martha J Sayers [mailto:marthaj@r...]

> Sent: Thursday, September 06, 2001 11:44 AM

> To: Access

> Subject: [access] forms and rports

> 

> 

> Hi,

> 

>   I have created a form in which the user can slect

> a report to print out. 

> I am using Access 2000 and the form, ReportsMenu,

> contains controls that 

> the queries for the reports use, so I can close the

> form. The user wants 

> to "preview" the report and then print.All well and

> good. The problem that 

> I have is I can sucessfully minized the Report

> Selection form, but when 

> the user is done printing or closed the reprot using

> the close box, how 

> can I get the ReportFOrm to automagically pop back

> up ?? I tried using the 

> reports close event and no go. Any suggestiosn would

> be appericated,

> thank you  :-)

> marthaj@r...

> 

> 

Hey Martha,



I'm happy to be of service.



As for your other problem, I think we'll need more info.  What are the

errors you're getting and when do they occur?  Does everybody have a full

version of A2K, or are some or all using a run-time version?  Are all the

installs service-packed (so to speak) to the same level?  Is the FE an MDE

file or an MDB?



Cheers,



-Roy



-----Original Message-----

From: Martha J. Sayers, A.A.B. [mailto:marthaj@r...]

Sent: Thursday, September 06, 2001 8:24 PM

To: Access

Subject: [access] RE: forms and rports





Roy,



  Your suggestion worked great !! I have forgotten so much in Access since I

have not worked in about 2 years...Now, I will see if it works on the users

machine... acouple of things don't work. I have one workstation inwhich I

compeltely uninstalled 200, re-install (about 3 time) and I have 3 pages

that do not work. Okay on all other machiens. It's split so the front-end

runs on the workstation. And another thing with this workstation is if I

click on link Manger, it doesn't show any tables. I have to copy it from

another workstation, yet those 3 forms won't work on this workstation. Okay

elsewhere. It is driving me nuts and I sure as heck don't know what to do. I

can not use form design etc. But it says it completely uninstalls it. Any

clues ??

thanks so much :-)

marthaj@r...

Hmmm... I'm afraid not much comes to my mind.  If you can't figure out why

the form is restoring, you may be able to work around it with

DoCmd.Maximize.  You may need to first select your form object with

DoCmd.SelectObject first...



HTH,



-Roy



-----Original Message-----

From: Graham Thompson [mailto:gpthompson50@y...]

Sent: Friday, September 07, 2001 1:18 AM

To: Access

Subject: [access] RE: forms and rports





I have had a similar problem to this.  I open the

original form as maximised with a control button to

view a report in print preview.  When I close the

print preview the form has shrunk, restored.  As I

have made the min/max buttons not accessable to the

user I am left with a messy screen that does not re

maximise.  I don't have any commands in to close, hide

or restore the original form. I have no idea how to

stop this.



 --- "Pardee, Roy E" <roy.e.pardee@l...> wrote: >

Rather than minimize your ReportsMenu form, you can

> hide it by setting it's

> visible property to False (e.g., Me.Visible 

> False).  Then you should be

> able to make it visible again in the Close event of

> the proper report with a

> statement like:

> 

> Application.Forms("ReportsMenu").Visible = True

> 

> Hope that helps.

> 

> -Roy

> 

> P.S. Do you need to bother hiding or minimizing this

> form at all?  Doesn't

> the report open up on top of the form & hide it? 

> Then when the user closes

> the report, the form comes back to the fore?

> 

> -----Original Message-----

> From: Martha J Sayers [mailto:marthaj@r...]

> Sent: Thursday, September 06, 2001 11:44 AM

> To: Access

> Subject: [access] forms and rports

> 

> 

> Hi,

> 

>   I have created a form in which the user can slect

> a report to print out. 

> I am using Access 2000 and the form, ReportsMenu,

> contains controls that 

> the queries for the reports use, so I can close the

> form. The user wants 

> to "preview" the report and then print.All well and

> good. The problem that 

> I have is I can sucessfully minized the Report

> Selection form, but when 

> the user is done printing or closed the reprot using

> the close box, how 

> can I get the ReportFOrm to automagically pop back

> up ?? I tried using the 

> reports close event and no go. Any suggestiosn would

> be appericated,

> thank you  :-)

> marthaj@r...

ah Roy .. here's the scoop.

 On all 3 workstations, they had Access97 Professional edition. When they

purchased new workstations, they purchased Access200 Professional upgrade.

So after some finger biting, I finally got all the Access97 to upgrade

properly (so much for that "just open and say yes to convert"  right...) .

On two of the workstations, every forms, and every option in the Access2000

works as you would expect. I can link, import etc.

On the third workstation, I can not use the link manager, it shows

aboslutley

no tables.So I can import them and then link, but still shows no tables when

I select link manager to refresh the tables or re-link them.

I split the database, so the server, which is just a WIn98 machine, has the

mdb_be and the workstations have the forms reports etc.

 I do not know if any service pack was installed, on any of the machines.

the only error I get is absolutley none, it just never brings the form up it

just

doesn't display the form, and the form that calls it , uses openargs to open

the form. I have tried to just use a filter and same results. just my blank

screen. And the forms, work fine on the other machines. It's totally weird

!!

 I did manage one time to recieve a "Invalid Page" error and that was it.

I cann't  alter the form and it's like it thinks it has Access fully

installed but doesn't really.

So I ran a regclean and it fixed 52 errors, none that were related to the

Access as far as I could tell. I used Systemworks.

This workstation has had the package uninstall, reinstall starting with

Access97 and up the ladder. No go.

It's just these three forms, which display data on a form.

I have to go in Saturday and try to fix it, but short of throwing it out

into the street, I am unsure what to try next...

and I thank you, I just ain't having much progress and things are getting

kind tense about it.

I know something has got to be causing it, but I do not know what.

marthaj@r...  :-(

well, I found Roy's solution very good and it resolved the problem. I do

know the form must have min/max alowed if I want minizie or max the form. I

use the on close event in the report and it works like a champ !!

 Kodoos to you Roy !!

:-)

marthaj@r...

Zounds, that's tough.  I'm not sure I fully understand everything below--are

you saying that the problem machine is acting as though it has only a

runtime version of Access installed, even though it has the full version?  



If it does have the full version, can you step through whatever code is

executing when the user goes to open the form?  Can you open the form in

design view on the problem machine?  Can you base a new form on the same

recordsource and if so, does that display as expected?



Cheers,



-Roy



-----Original Message-----

From: Martha J. Sayers, A.A.B. [mailto:marthaj@r...]

Sent: Friday, September 07, 2001 9:18 PM

To: Access

Subject: [access] RE: forms and rports





ah Roy .. here's the scoop.

 On all 3 workstations, they had Access97 Professional edition. When they

purchased new workstations, they purchased Access200 Professional upgrade.

So after some finger biting, I finally got all the Access97 to upgrade

properly (so much for that "just open and say yes to convert"  right...) .

On two of the workstations, every forms, and every option in the Access2000

works as you would expect. I can link, import etc.

On the third workstation, I can not use the link manager, it shows

aboslutley

no tables.So I can import them and then link, but still shows no tables when

I select link manager to refresh the tables or re-link them.

I split the database, so the server, which is just a WIn98 machine, has the

mdb_be and the workstations have the forms reports etc.

 I do not know if any service pack was installed, on any of the machines.

the only error I get is absolutley none, it just never brings the form up it

just

doesn't display the form, and the form that calls it , uses openargs to open

the form. I have tried to just use a filter and same results. just my blank

screen. And the forms, work fine on the other machines. It's totally weird

!!

 I did manage one time to recieve a "Invalid Page" error and that was it.

I cann't  alter the form and it's like it thinks it has Access fully

installed but doesn't really.

So I ran a regclean and it fixed 52 errors, none that were related to the

Access as far as I could tell. I used Systemworks.

This workstation has had the package uninstall, reinstall starting with

Access97 and up the ladder. No go.

It's just these three forms, which display data on a form.

I have to go in Saturday and try to fix it, but short of throwing it out

into the street, I am unsure what to try next...

and I thank you, I just ain't having much progress and things are getting

kind tense about it.

I know something has got to be causing it, but I do not know what.

marthaj@r...  :-(