Form opens even when not specified in Startup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnB - 29 Oct 2007 11:54 GMT

Hi.

OK, this is probably very simple but I can't see it.

I have a small mdb that I wanted to experiment on, by converting it to
Access 2007. So the first thing I thought was to remove the feature that
opens a main form on Startup. So I go to Startup and nothing is specified!
I've looked in the Event code of the form in question and only a Maximise on
open event exists. I've tried introducing a different form in Startup and
they both open.

Can anyone tell me what could be causing this form to open, if it's not
specified in Startup? I think the answer is going to embarrass me.

Thanks,

Reply to this Message

Jeff Boyce - 29 Oct 2007 12:05 GMT

John

Check the "Macros" tab -- do you have one named "AutoExec"? Whatever's in
that will automatically execute on startup.

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

> Hi.
>
[quoted text clipped - 11 lines]
>
> Thanks,

Reply to this Message

JohnB - 29 Oct 2007 13:45 GMT

That was it Jeff, thanks.

In my defence I should say that this is not one of my designs - I only got
involoved when the users wanted some reports put together. I think I'll
remove the Autoexec function and revert to the Startup feature - much more
visable for something that's very simple.

Thanks again.

> John
>
[quoted text clipped - 17 lines]
> >
> > Thanks,

Reply to this Message

Douglas J. Steele - 29 Oct 2007 14:45 GMT

Just make sure that the AutoExec macro isn't doing anything else in addition
to opening the form before you delete it.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> That was it Jeff, thanks.
>
[quoted text clipped - 31 lines]
>> >
>> > Thanks,

Reply to this Message

JohnB - 31 Oct 2007 11:36 GMT

Sorry, just spotted this Doug. Thanks, will do.

Cheers.

> Just make sure that the AutoExec macro isn't doing anything else in addition
> to opening the form before you delete it.
[quoted text clipped - 34 lines]
> >> >
> >> > Thanks,

Reply to this Message