Restore size Datasheet View Form on top of Maximized Form

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

Comments inline.

On Fri, 23 May 2008 02:16:31 -0500, Alan Forsyth <Not@iHome.nzwr ote:
>
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:=acD ialog
>>Pity.
>>
>>OK, where am I wrong or what have I missed? It can be done?
>>
>>Thanks,
>>Alan Forsyth

>

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

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

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:=acD ialog
>Pity.
>
>OK, where am I wrong or what have I missed? It can be done?
>
>Thanks,
>Alan Forsyth

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:=acD ialog
Pity.

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

Thanks,
Alan Forsyth