[AccessD] Ac2013 startup form
Rocky Smolin
rockysmolin at bchacc.com
Thu Jun 25 10:01:45 CDT 2015
Well, there's always the nuclear option of getting rid of the macros being
triggered by that form. I never used macros myself being warned off them in
favor of VBA when I started with Access 97. So I'm no help when it comes to
macro advice.
R
-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Thursday, June 25, 2015 7:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Ac2013 startup form
None of these suggestions help. For those which reference VBA, as I stated
early on, this is a problem with Macros not being enabled yet.
Setting AutoCenter to Yes did not help reduce the dialog to the desired size
(its last saved size was nice and compact - just as it appears in Design
View).
SOMETHING must be stretching this form out to monstrous proportions. Since
no VBA can be affecting the form on startup, and its size is compact in
design view, I think there must be a bug in MS Access.
Rocky - since you know (now at least, I hope) that this problem manifests
before macros run - and since you also know I am getting a runtime message
about macros (with a requirement to halt them) therefore AutoExec doesn't
save me - is there any other recommendation you have?
As I said earlier, I thought I had a solution by changing the Border Style
from Sizable to Dialog, because the very next time I opened the form it
looked fine. However I think I was misled by the possibility that macros
could have already been enabled while I did that test. the very next time I
opened the database to this startup form, it was back to a huge splash
screen ... and my nice background was runined and the controls I wanted to
appear nice and centered, on a compact form, were oddly positioned vis a vis
the form's large dimensions.
Hugely frustrating.
On Thu, Jun 25, 2015 at 10:13 AM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:
> Unfortunately (for you :)) a bit of VBA is the solution. I use
> MoveSize method a lot to position, and size, those pop ups.
>
> r
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of Bill Benson
> Sent: Thursday, June 25, 2015 6:32 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Ac2013 startup form
>
> Apparently changing border style from sizeable to dialog solved the
> problem with size. Now if I could just get positioning to work without
> the intervention of VBA/macros?
>
> On Thu, Jun 25, 2015 at 9:22 AM, Bill Benson <bensonforums at gmail.com>
> wrote:
>
> > I have created a popup form that I want to display as a splash screen.
> > Unfortunately on startup, before any macros are enabled and
> > therefore before my code can shape the form to the required size and
> > put it in the required position, it is opening super-huge.
> >
> > I could control this with an AutoExec that opens the form, but then
> > the user would be getting informaed that macros are present, and all
> > have been halted. That is an annoyance that has utterly put me off
> > the AutoExec macro
> > - so if anyone knows how to make THAT stop I would be grateful as well.
> >
> > So here I am with a form I know how large it should be - and really
> > want it to be because the image I use as its background is getting
> > centered and looks ugly on a stretched out form. the kind of code I
> > would be running to control the size and position is shown below. I
> > don't know why the darned form won't just stay in that condition.
> >
> > Option Compare Database
> > Option Explicit
> > Private Sub cmdBatch_Click()
> > DoCmd.OpenForm "frmBatchReporting"
> > End Sub
> > Private Sub cmdSingle_Click()
> > DoCmd.OpenForm "frmreportingfilters"
> > End Sub
> > Private Sub Form_Load()
> > DoCmd.MoveSize 5000, 2000, 8000, 5000 lblEnableContent.Visible =
> > False cmdSingle.Visible = True cmdBatch.Visible = True End Sub
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
More information about the AccessD
mailing list