Help!

VBA Restore Window

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Set xlApp = CreateObject("excel.Application&..  
Author Message
F1stman
External


Since: May 05, 2006
Posts: 34



PostPosted: Fri Jul 13, 2007 6:38 pm    Post subject: VBA Restore Window
Archived from groups: microsoft>public>access (more info?)

Hello All,
I know that this should be very easy bu I am having trouble setting the
focus to and restoring a form through code. Here is the situation:

I have a directory form which opens a project information window when an
entry in the subform is clicked. Also when the subform field is clicked, the
directory window minimizes as the info window opens. The only problem is I
cannot figure out how to restore the directory once the info window closes.

I have tried SetFocus and even maximize commands in the info window's
OnClose event and the custom close button's OnClick event.

Please correct me or let me know if I am on the right track.

Many Thanks,
Adam Kem
Back to top
Michael Conroy
External


Since: Mar 01, 2007
Posts: 12



PostPosted: Fri Jul 13, 2007 6:50 pm    Post subject: RE: VBA Restore Window [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

F1stman:
Try Docmd.Restore. I put this command in every Form_Activate and it puts the
form size back to its original size. I ran into a problem where users were
previewing a report and they maximized the report to see it better. When they
closed the preview and went back to the report form, the form took up the
entire screen. This prevents anything like that from happening.
--
Michael Conroy
Stamford, CT


"F1stman" wrote:

> Hello All,
> I know that this should be very easy bu I am having trouble setting the
> focus to and restoring a form through code. Here is the situation:
>
> I have a directory form which opens a project information window when an
> entry in the subform is clicked. Also when the subform field is clicked, the
> directory window minimizes as the info window opens. The only problem is I
> cannot figure out how to restore the directory once the info window closes.
>
> I have tried SetFocus and even maximize commands in the info window's
> OnClose event and the custom close button's OnClick event.
>
> Please correct me or let me know if I am on the right track.
>
> Many Thanks,
> Adam Kem
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum