Form opens even when not specified in Startup

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,

John

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

--
Regards

Jeff Boyce
www.InformationFutures.net

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

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

"JohnB" wrote in message
...
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,

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.

"Jeff Boyce" wrote:

John

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

--
Regards

Jeff Boyce
www.InformationFutures.net

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

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

"JohnB" wrote in message
...
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,

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

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


"JohnB" wrote in message
...
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.

"Jeff Boyce" wrote:

John

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

--
Regards

Jeff Boyce
www.InformationFutures.net

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

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

"JohnB" wrote in message
...
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,

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

Cheers.

"Douglas J. Steele" wrote:

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

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


"JohnB" wrote in message
...
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.

"Jeff Boyce" wrote:

John

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

--
Regards

Jeff Boyce
www.InformationFutures.net

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

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

"JohnB" wrote in message
...
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,