Connecting Tech Pros Worldwide Forums | Help | Site Map

Restore size Datasheet View Form on top of Maximized Form

Alan Forsyth
Guest
 
Posts: n/a
#1: Jun 27 '08
That rather long subject says it.
In Access97 running on XP - I want to display a Maximized size Form01, then
open a Restore size Datasheet View Form02 on top of the first Form.

PopUp won't give me Datasheet view.
Dialog mode won't give me Datasheet view

I could make Form01 Restore size and expand it to fill the Window in
Restore size (maybe DoCmd.MoveSize Right, Down, Width, Height) - I don't
want this.

I could imitate a Datasheet with Form02 in Form Display mode - I don't want
to do that.

Access97 doesn't have WindowMode:=acDialog
Pity.

OK, where am I wrong or what have I missed? It can be done?

Thanks,
Alan Forsyth

Tom van Stiphout
Guest
 
Posts: n/a
#2: Jun 27 '08

re: Restore size Datasheet View Form on top of Maximized Form


On Fri, 23 May 2008 02:16:31 -0500, Alan Forsyth <Not@iHome.nzwrote:

You have some unusual requirements. What exactly is the difference
between a maximized form and a form of maximum size?

Anyway, you can always have datasheet view if you put a subform in
datasheet view on an unbound form.

-Tom.

Quote:
>That rather long subject says it.
>In Access97 running on XP - I want to display a Maximized size Form01, then
>open a Restore size Datasheet View Form02 on top of the first Form.
>
>PopUp won't give me Datasheet view.
>Dialog mode won't give me Datasheet view
>
>I could make Form01 Restore size and expand it to fill the Window in
>Restore size (maybe DoCmd.MoveSize Right, Down, Width, Height) - I don't
>want this.
>
>I could imitate a Datasheet with Form02 in Form Display mode - I don't want
>to do that.
>
>Access97 doesn't have WindowMode:=acDialog
>Pity.
>
>OK, where am I wrong or what have I missed? It can be done?
>
>Thanks,
>Alan Forsyth
Alan Carpenter
Guest
 
Posts: n/a
#3: Jun 27 '08

re: Restore size Datasheet View Form on top of Maximized Form


Comments inline.
Quote:
On Fri, 23 May 2008 02:16:31 -0500, Alan Forsyth <Not@iHome.nzwrote:
>
You have some unusual requirements. What exactly is the difference
between a maximized form and a form of maximum size?
"A Form of Unusual Size." :-)

A distinction I should have made more clear, perhaps with:
"Full Screen" to mean Maximized.
"Very Large Form" to mean a form in Restore View, made as large as
possible. (That's not an option for my "background" Form.)

Quote:
Anyway, you can always have datasheet view if you put a subform in
datasheet view on an unbound form.
You're right. It still won't look or act the same as a Restore Size
Datasheet View form (User resizing is an issue) and I may be able to get
closer to that appearance with the continuous form (which also has resize
issues.)
Users expect EXACTLY the same as a Query Datasheet.

Thanks, Tom. that's something I hadn't considered.

Alan Forsyth
Quote:
>
-Tom.
>
>
Quote:
>>That rather long subject says it.
>>In Access97 running on XP - I want to display a Maximized size Form01,
>>then open a Restore size Datasheet View Form02 on top of the first
>>Form.
>>
>>PopUp won't give me Datasheet view.
>>Dialog mode won't give me Datasheet view
>>
>>I could make Form01 Restore size and expand it to fill the Window in
>>Restore size (maybe DoCmd.MoveSize Right, Down, Width, Height) - I
>>don't want this.
>>
>>I could imitate a Datasheet with Form02 in Form Display mode - I don't
>>want to do that.
>>
>>Access97 doesn't have WindowMode:=acDialog
>>Pity.
>>
>>OK, where am I wrong or what have I missed? It can be done?
>>
>>Thanks,
>>Alan Forsyth
>
Closed Thread