MDI FORM in MSACCESS

[han]

Hi All,

I'm trying to create an MDI application using MS Access. Does anybody
know how to do it? My current application is using Access Switchboard
and the way it does multitasking is horrible because when it opens a
window it will resize the other (although the AutoResize property is
false).

Thank you in advance.

[Rick Brandt]

Re: MDI FORM in MSACCESS

han wrote:[color=blue]
> Hi All,
>
> I'm trying to create an MDI application using MS Access. Does anybody
> know how to do it? My current application is using Access Switchboard
> and the way it does multitasking is horrible because when it opens a
> window it will resize the other (although the AutoResize property is
> false).
>
> Thank you in advance.[/color]

Access apps are already MDI apps. Are you saying you want an MDI within the
existing MDI?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Larry Linson]

Re: MDI FORM in MSACCESS

"han" wrote
[color=blue]
> I'm trying to create an MDI application
> using MS Access. Does anybody
> know how to do it?[/color]

If you want something like Word, where one instance of Word may have
multiple open documents, that is not possible with any released version of
Access.
[color=blue]
> My current application is using
> Access Switchboard and the way
> it does multitasking is horrible
> because when it opens a
> window it will resize the other
> (although the AutoResize
> property is false).[/color]

AFAIK, Access does not, repeat _not_, do multitasking (unless perhaps your
definition differs from Microsoft's and mine). Resizing a window, that is, a
user clicking and dragging the edge, does not resize other windows.
Selecting "Maximize", "Minimize", or "Restore" does affect all the
Windows -- and, since 1993, that has never yet interfered with my use of
Access to create normal business database applications (which, after all, is
the goal of Access database software).
[color=blue]
> Thank you in advance.[/color]

There are programming languages (not database application generator tools
such as Access) that give you multitasking and control over each window
(e.g., Access form), but at the expense of your delving deep into the
Windows API and having to code most everything, including display of your
forms. As for me, I'd much rather point and click my way to a nice user
interface and only have to add a little sprinkle of code here and there to
make it work smoothly to do what I want -- and I can do that with Access.

Larry Linson
Microsoft Access MVP

[David W. Fenton]

Re: MDI FORM in MSACCESS

"han" <hanwi@mjleola. com> wrote in
news:1124315660 .591870.269120@ g14g2000cwa.goo glegroups.com:
[color=blue]
> I'm trying to create an MDI application using MS Access. Does
> anybody know how to do it? My current application is using Access
> Switchboard and the way it does multitasking is horrible because
> when it opens a window it will resize the other (although the
> AutoResize property is false).[/color]

Er, that's the way the MDI interface works.

If you open multiple documents in Word and maximize one of them,
they are all maximized.

So, the way the Access form interface works is completely consistent
with the MDI.

I don't like MDI for database applications, because forms and
dialogs are not documents, and shouldn't be treated the same way as
documents are. This is exactly why you are having a problem --
Access is treating your open forms like documents when they aren't
anything at all like documents.

You might want to look on http://mvps.or/access and check out the
code for resizing forms. With that, you can set an individual form
to use the entire Access window without having any effect on the
other forms you've got open at the same time.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc