p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Database window always loads at startup - help please.


Message #1 by "Roddy Campbell" <scotiwis@b...> on Mon, 17 Jun 2002 12:43:55
since upgrading to Acess XP when I load my database it brings up 2 
windows - the switchboard and the database window. I want it only to bring 
up the switchboard as I don't want people accessing the database window. 
It was fine with Access 2000 - only loaded switchboard.
Can someone help please (database window is not selected in startup)
Message #2 by "Gregory Serrano" <SerranoG@m...> on Mon, 17 Jun 2002 14:57:06
Roddy,

<< since upgrading to Acess XP when I load my database it brings up 2 
windows - the switchboard and the database window. I want it only to bring 
up the switchboard as I don't want people accessing the database window. 
It was fine with Access 2000 - only loaded switchboard.
Can someone help please (database window is not selected in startup) >>

With your database open, click on menu items Tools | Startup.  A dialog 
box will appear.  Look for the checkbox that says "Display Database 
Window".  Make sure it's UNchecked.  The next time you open your database, 
the switchboard will open but the database window will not.

Greg
Message #3 by "Amy Wyatt" <amyw@c...> on Mon, 17 Jun 2002 18:08:28
This is an apparent bug in Access XP because I have seen it also. I think 
you are going to have to hide database window through an auto_exec macro 
or through code on the Open/Load event of the Switchboard. Simply 
unchecking the box in start-up does not work because mine is unchecked and 
the database window still shows up when the database opens. (even though 
you can't see it behind the form, if you click on the task bar the window 
shows up).

Microsoft will have to fix this one.

Amy


> Roddy,

> << since upgrading to Acess XP when I load my database it brings up 2 
w> indows - the switchboard and the database window. I want it only to 
bring 
u> p the switchboard as I don't want people accessing the database window. 
I> t was fine with Access 2000 - only loaded switchboard.
C> an someone help please (database window is not selected in startup) >>

> With your database open, click on menu items Tools | Startup.  A dialog 
b> ox will appear.  Look for the checkbox that says "Display Database 
W> indow".  Make sure it's UNchecked.  The next time you open your 
database, 
t> he switchboard will open but the database window will not.

> Greg
Message #4 by "Gerald, Rand" <RGerald@u...> on Mon, 17 Jun 2002 12:10:52 -0500
The database will load any form specified.

Create a macro called AutoExec

That macro can do anything you wish including loading the Switchboard 
form.
Access always executes the AutoExec macro when it opens the database.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: Amy Wyatt [mailto:amyw@c...]
Sent: Monday, June 17, 2002 1:08 PM
To: Access
Subject: [access] Re: Database window always loads at startup - help 
please.

This is an apparent bug in Access XP because I have seen it also. I 
think
you are going to have to hide database window through an auto_exec 
macro
or through code on the Open/Load event of the Switchboard. Simply
unchecking the box in start-up does not work because mine is unchecked 
and
the database window still shows up when the database opens. (even 
though
you can't see it behind the form, if you click on the task bar the 
window
shows up).

Microsoft will have to fix this one.

Amy


> Roddy,

> << since upgrading to Acess XP when I load my database it brings up 2
w> indows - the switchboard and the database window. I want it only to
bring
u> p the switchboard as I don't want people accessing the database 
window.
I> t was fine with Access 2000 - only loaded switchboard.
C> an someone help please (database window is not selected in startup) 
>>

> With your database open, click on menu items Tools | Startup.  A 
dialog
b> ox will appear.  Look for the checkbox that says "Display Database
W> indow".  Make sure it's UNchecked.  The next time you open your
database,
t> he switchboard will open but the database window will not.

> Greg
Message #5 by "Roddy Campbell" <scotiwis@b...> on Tue, 18 Jun 2002 09:52:48
OK thanks for all that, a bug in XP - who would believe it (!!). Its not 
the first I've come across since upgrading. Yes I have the show database 
window unchecked and its still loading at startup. So if I create a macro 
called autoexec what exactly do I put in it to load the switchboard but 
not to show the database window - the exact code of the macro would be 
most helpful.
thanks
Message #6 by "Amy Wyatt" <amyw@c...> on Tue, 18 Jun 2002 13:53:54
First use RunCommand and choose Window Hide as the parameter. Then do 
OpenForm with your switchboard as the form to open. Save it as autoexec 
and it will run when the database is opened.

Don't forget to change your start-up properties. You have to check the box 
that says show database window or the macro will error out because hide is 
not available. What is strange is that if you start from scratch in XP the 
Start-up settings work but if you upgrade from 2000 then they don't.

Good luck,

Amy

> OK thanks for all that, a bug in XP - who would believe it (!!). Its not 
t> he first I've come across since upgrading. Yes I have the show database 
w> indow unchecked and its still loading at startup. So if I create a 
macro 
c> alled autoexec what exactly do I put in it to load the switchboard but 
n> ot to show the database window - the exact code of the macro would be 
m> ost helpful.
t> hanks
Message #7 by "Roddy Campbell" <scotiwis@b...> on Tue, 18 Jun 2002 15:26:54
What is really strange is that if you upgrade from 2000 startup settings 
don't work, if you completely uninstall 2000 and install full version of 
XP + SP-1 from scratch it still doesn't work !! Only way it seems to work 
is if there's never been any version of office installed on the machine 
apart from xp.
Either way thanks for your help Amy, I've actually discovered through this 
a better way to do it anyway, if you disable differenct windows appearing 
in the taskbar it stops this happening, it also makes it easier to see 
everything that's open in general.
I don't suppose you know of another bug which I'm experiencing. I have an 
access project on the go which uses stored procedures as record sources 
for the forms. Prior to upgrading to XP these worked fine: the record was 
selected, the form refreshed feeding the record id into the stored 
procedure and returning the record to be displayed on the screen. Now 
since upgrading to XP it looks as if its working the same way but nothing 
is appearing on the form. Any ideas ?


> First use RunCommand and choose Window Hide as the parameter. Then do 
O> penForm with your switchboard as the form to open. Save it as autoexec 
a> nd it will run when the database is opened.

> Don't forget to change your start-up properties. You have to check the 
box 
t> hat says show database window or the macro will error out because hide 
is 
n> ot available. What is strange is that if you start from scratch in XP 
the 
S> tart-up settings work but if you upgrade from 2000 then they don't.

> Good luck,

> Amy
Message #8 by "Amy Wyatt" <amyw@c...> on Tue, 18 Jun 2002 15:58:09
I just started using SQL Server2000 and do not have a lot of experience 
with the stored procedures. I had to convert a DB to SQL that was alreaded 
fully coded and it did not translate well into the Project Environment so 
I just Liked the tables thru ODBC for now (Still had a fair amount of 
fixing to do but lots less than true Access -> SQL Project) Anyway, I have 
also avoided upgrading to XP because I have experienced many problems with 
it and did not want to go there.

I do have two suggestions though. First, can you execute the procedure and 
have it work within SQL Query Analyzer? and also I would post this on the 
SQL Server threads as well to see if anyone there has a clue.

Sorry I could not help more.

Amy

> What is really strange is that if you upgrade from 2000 startup settings 
d> on't work, if you completely uninstall 2000 and install full version of 
X> P + SP-1 from scratch it still doesn't work !! Only way it seems to 
work 
i> s if there's never been any version of office installed on the machine 
a> part from xp.
E> ither way thanks for your help Amy, I've actually discovered through 
this 
a>  better way to do it anyway, if you disable differenct windows 
appearing 
i> n the taskbar it stops this happening, it also makes it easier to see 
e> verything that's open in general.
I>  don't suppose you know of another bug which I'm experiencing. I have 
an 
a> ccess project on the go which uses stored procedures as record sources 
f> or the forms. Prior to upgrading to XP these worked fine: the record 
was 
s> elected, the form refreshed feeding the record id into the stored 
p> rocedure and returning the record to be displayed on the screen. Now 
s> ince upgrading to XP it looks as if its working the same way but 
nothing 
i> s appearing on the form. Any ideas ?

> 
>>  First use RunCommand and choose Window Hide as the parameter. Then do 
O> > penForm with your switchboard as the form to open. Save it as 
autoexec 
a> > nd it will run when the database is opened.

> > Don't forget to change your start-up properties. You have to check the 
b> ox 
t> > hat says show database window or the macro will error out because 
hide 
i> s 
n> > ot available. What is strange is that if you start from scratch in XP 
t> he 
S> > tart-up settings work but if you upgrade from 2000 then they don't.

> > Good luck,

> > Amy
Message #9 by "Roddy Campbell" <scotiwis@b...> on Tue, 18 Jun 2002 16:46:36
Yeah SQL part works fine, just isn't linking through to Access all of a 
sudden. I'll try SQL forum unless anyone else can help here ?
And Amy - you are wise not to upgrade to XP and also not to update to 
Access Project. I had hair before I did both of the above   !
Message #10 by "Leo Scott" <leoscott@c...> on Tue, 18 Jun 2002 09:22:20 -0700
I haven't looked in a while but Micorsoft had a utility to clean the
registry after uninstalling Office because some things were not being
cleaned out of the registry when you did an uninstall.  You may have to
completely uninstall Office and run this utility.

|-----Original Message-----
|From: Roddy Campbell [mailto:scotiwis@b...]
|Sent: Tuesday, June 18, 2002 3:27 PM
|To: Access
|Subject: [access] Re: Database window always loads at startup - help p
|lease.
|
|
|What is really strange is that if you upgrade from 2000 startup settings
|don't work, if you completely uninstall 2000 and install full version of
|XP + SP-1 from scratch it still doesn't work !! Only way it seems to work
|is if there's never been any version of office installed on the machine
|apart from xp.
|Either way thanks for your help Amy, I've actually discovered through this
|a better way to do it anyway, if you disable differenct windows appearing
|in the taskbar it stops this happening, it also makes it easier to see
|everything that's open in general.
|I don't suppose you know of another bug which I'm experiencing. I have an
|access project on the go which uses stored procedures as record sources
|for the forms. Prior to upgrading to XP these worked fine: the record was
|selected, the form refreshed feeding the record id into the stored
|procedure and returning the record to be displayed on the screen. Now
|since upgrading to XP it looks as if its working the same way but nothing
|is appearing on the form. Any ideas ?
|
|
|> First use RunCommand and choose Window Hide as the parameter. Then do
|O> penForm with your switchboard as the form to open. Save it as autoexec
|a> nd it will run when the database is opened.
|
|> Don't forget to change your start-up properties. You have to check the
|box
|t> hat says show database window or the macro will error out because hide
|is
|n> ot available. What is strange is that if you start from scratch in XP
|the
|S> tart-up settings work but if you upgrade from 2000 then they don't.
|
|> Good luck,
|
|> Amy

Message #11 by "Roddy Campbell" <scotiwis@b...> on Tue, 18 Jun 2002 20:22:29
thanks for that, any idea at all where I'd get this utility ?

  Return to Index