[AccessD] Ac2013 startup form

Bill Benson bensonforums at gmail.com
Thu Jun 25 17:33:11 CDT 2015


And for those of you who think I must be too dumb to live - just know that
it has always been my assumption that trusted locations were on an Office
basis - I did not know that all the trusted locations I have added while in
MS Excel (which this app's folder was among) - has to be trusted again in
MS Access.
-Hand smacking forehead!

On Thu, Jun 25, 2015 at 6:31 PM, Bill Benson <bensonforums at gmail.com> wrote:

> Stuart - exactly right. Solved the problem.
> Thank you.
>
> On Thu, Jun 25, 2015 at 4:44 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
> wrote:
>
>> By "before any macros are enabled", do you mean that the application is
>> not trusted/in a
>> trusted location and the users has to click to enable macros every time
>> that it is opened?
>>
>> If so, why not just establish trust?
>>
>> --
>> Stuart
>>
>>
>> On 25 Jun 2015 at 9:22, Bill Benson 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
>>
>
>


More information about the AccessD mailing list