469,576 Members | 1,694 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,576 developers. It's quick & easy.

Restore size Datasheet View Form on top of Maximized Form

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
Jun 27 '08 #1
2 2821
On Fri, 23 May 2008 02:16:31 -0500, Alan Forsyth <No*@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.

>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
Jun 27 '08 #2
Comments inline.
On Fri, 23 May 2008 02:16:31 -0500, Alan Forsyth <No*@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.)

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
>
-Tom.

>>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
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by cefrancke | last post: by
14 posts views Thread by Galen Somerville | last post: by
2 posts views Thread by rdemyan via AccessMonster.com | last post: by
3 posts views Thread by DAHMB | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.