By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

Restore size Datasheet View Form on top of Maximized Form

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.