473,395 Members | 1,442 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

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 3117
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Kent Eilers | last post by:
I want to follow naming conventions for my controls - i usually prefix combo boxes with "cbo". When a form is in datasheet view however i do not want the user to see the 'cbo' prefix in front of...
4
by: Terry | last post by:
I have created a Main Switchboard in Access 2000 and it has a button which opens a Form. I have set the form Properties Default View to Datasheet and this always opens in datasheet view. When I...
13
by: Aladdin | last post by:
I have an MS Access form on which I have a listbox listing tables in that database. I want to be able to click on any of those tables and view its contents on the same form using subforms or any...
1
by: R. Hopping | last post by:
I've changed the font size on the form but it only works in form view. When the data is displayed in Datasheet view it doesn't display the selected font size.
3
by: cefrancke | last post by:
The only reason I ask is that no one has made this subject clear or given a definitive answer. What I would like to do is, after turning off all the menus/tbars/etc using the startup options. ...
14
by: Galen Somerville | last post by:
My current screen resolution is set to 1024 x 768. My form size always comes up as 1032 x 748. I have tried the help sample ' Retrieve the working rectangle from the Screen class ' using the...
3
by: ZaphodBBB | last post by:
Hi again, would appreciate any assistance with getting forms to view at the correct size. (Win XP Pro SP2, MS Access 2003) I have a tabbed form that I open in Maximized view and that's the way...
2
by: rdemyan via AccessMonster.com | last post by:
Is there a way to set a common size for any form, when the user clicks on the middle button in the form control box the restore button for a maximized form. I'd like to have any maximized form,...
3
by: DAHMB | last post by:
I know this is a lazy issue but.... When I have a form I use to launch a report from when I click the Run Report button at the bottom of the form. My form is not maximized and is centered in the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.