Forms opened by buttons on other forms.

[Jarryd]

Hi,

I have two queries:

1. Datasheet opens as Single Form.
I have a button on a form (Single) that launches a form that has been
created as Datasheet. But when I click on the button it opens as a single
form. If I switch to design view and back (without changing anything) it
flips in to design view as desired. I assume it has something to do with
the fact that form from which it was opened is not a datasheet form. But
how do I get it to do what I want which is launch from a button as
datasheet.

2. Form window opens as maximised if the original form is maximised.
I have created a form that fits perfectly on to the screen if it is
maximised. There is a button on that form that opens a small pop-up form,
but it opens maximised. I change the original form to not be maximised
before I open the small one and then click the button it opens as it should.
How do I get Access to open the small form as small from the maximised
original form?

TIA,

Jarryd

 

[fredg]

Hi,

I have two queries:

1. Datasheet opens as Single Form.
I have a button on a form (Single) that launches a form that has been
created as Datasheet. But when I click on the button it opens as a single
form. If I switch to design view and back (without changing anything) it
flips in to design view as desired. I assume it has something to do with
the fact that form from which it was opened is not a datasheet form. But
how do I get it to do what I want which is launch from a button as
datasheet.

2. Form window opens as maximised if the original form is maximised.
I have created a form that fits perfectly on to the screen if it is
maximised. There is a button on that form that opens a small pop-up form,
but it opens maximised. I change the original form to not be maximised
before I open the small one and then click the button it opens as it should.
How do I get Access to open the small form as small from the maximised
original form?

TIA,

Jarryd

1) Regardless of the form's Default View settings, if you open a form
(default Datasheet View) from code, you must specify Datasheet view:
DoCmd.OpenForm "FormName", acFormDS

2) Are you sure the form's Pop-up property is set to Yes?

From Access Help:
Tip When you maximize a window in Microsoft Access, all other
windows are also maximized when you open them or switch to them.
However, pop-up forms aren't maximized. If you want a form to maintain
its size when other windows are maximized, set its PopUp property to
Yes.

Can you open the form in dialog?
DoCmd.OpenForm "FormName", , , , , acDialog