Lynn- No Autoexec macro? There's nothing "global" that could override it. It's happening either in the Open or Load events of the startup form or in the AutoExec macro.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Lynn > Sent: Sunday, August 07, 2005 4:49 PM > To: [email protected] > Subject: [ms_access] Re: Switchboard Question > > > Alright, it must be something "globally" overriding it because I > copied the DB, deleted the switchboard and table, re-added it and it > does the same thing. Start up options are: > > Application Title and Application Icon set > Display Icon in Forms and Reports = Yes > > Opens to Form Main Switchboard > Display Database Window = No > Display Status Bar = Yes > > All menu bars default > Allow Builtin Toolbars and Menu Items = Yes > Allow Shortcut Menus = Yes > Allow Full Menus = Yes > Use Special Keys = Yes > > I checked General Declarations and didn't see anything new. This all > of a sudden started happening, I didn't add anything other than some > code that John helped me with & it didn't have anything to do with > the Switchboard. > > This is making me crazy...it looks just like every other DB I've > done....there must be something tho. > > Lynn Bryant > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Lynn- > > > > You can see that the Current event is changing the form's caption > > (Me.Caption). What else do you have in your Startup properties? > Is this > > the Startup form, or is it something else? Do you have an AutoExec > macro? > > Something is selecting the database window and then minimizing it. > The code > > I posted earlier is from one of the database templates available on > > office.microsoft.com that uses a modified version of what the > Switchboard > > Manager builds. > > > > John Viescas, author > > "Building Microsoft Access Applications" > > "Microsoft Office Access 2003 Inside Out" > > "Running Microsoft Access 2000" > > "SQL Queries for Mere Mortals" > > http://www.viescas.com/ > > > > > -----Original Message----- > > > From: [email protected] > > > [mailto:[EMAIL PROTECTED] On Behalf Of Lynn > > > Sent: Sunday, August 07, 2005 10:44 AM > > > To: [email protected] > > > Subject: [ms_access] Re: Switchboard Question > > > > > > > > > Hi John: > > > > > > I don't see the code you showed me. Here's what I have in On > Current > > > and On Open. This is just what the Wizard gave me, I'm guessing.: > > > > > > Private Sub Form_Open(Cancel As Integer) > > > ' Minimize the database window and initialize the form. > > > > > > ' Move to the switchboard page that is marked as the default. > > > Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' " > > > Me.FilterOn = True > > > > > > End Sub > > > > > > Private Sub Form_Current() > > > ' Update the caption and fill in the list of options. > > > > > > Me.Caption = Nz(Me![ItemText], "") > > > FillOptions > > > > > > End Sub > > > __________________________________ > > > > > > I went ahead and changed the name back to Main Switchboard from > Main > > > Menu, but it's still not working. What do I need to do to fix it? > > > > > > Thanks again, > > > > > > L. > > > > > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> > wrote: > > > > Lynn- > > > > > > > > You'll find there's code in the Current event of the > Switchboard > > > form that > > > > is setting the form's caption. There's also this code in the > Open > > > event: > > > > > > > > ' Minimize the database window. > > > > DoCmd.SelectObject acForm, "Switchboard", True > > > > DoCmd.Minimize > > > > > > > > The SelectObject unhides the database window and the following > > > command > > > > minimizes it. The unhide effectively undoes your Startup > option. > > > > > > > > John Viescas, author > > > > "Building Microsoft Access Applications" > > > > "Microsoft Office Access 2003 Inside Out" > > > > "Running Microsoft Access 2000" > > > > "SQL Queries for Mere Mortals" > > > > http://www.viescas.com/ > > > > > > > > > -----Original Message----- > > > > > From: [email protected] > > > > > [mailto:[EMAIL PROTECTED] On Behalf Of Lynn > > > > > Sent: Sunday, August 07, 2005 8:35 AM > > > > > To: [email protected] > > > > > Subject: [ms_access] Switchboard Question > > > > > > > > > > > > > > > Another question I have: > > > > > > > > > > I changed the "Caption" on the Form Property on the Main > > > Switchboard > > > > > form to read: > > > > > Main Menu > > > > > > > > > > It still says Main Switchboard, regardless of what I put in > > > Caption. > > > > > > > > > > Why? And how can I change this readout? > > > > > > > > > > Thanks in advance, > > > > > Lynn Bryant > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor > > > > > --------------------~--> > > > > > <font face=arial size=-1><a > > > > > href="http://us.ard.yahoo.com/SIG=12htf6s9p/M=362335.6886445.7 > > > > > 839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123428874 > > > > > /A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/to > > > > > pics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http: > > > > > //groups.yahoo.com/">In low income neighborhoods, 84% do not > > > > > own computers. At Network for Good, help bridge the Digital > > > > > Divide!</a>.</font> > > > > > -------------------------------------------------------------- > > > > > ------~-> > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor > > > --------------------~--> > > > <font face=arial size=-1><a > > > href="http://us.ard.yahoo.com/SIG=12ht1efct/M=362131.6882499.7 > > > 825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123436726 > > > /A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org > > > ">Get Bzzzy! (real tools to help you find a job) Welcome to > > > the Sweet Life - brought to you by One Economy</a>.</font> > > > -------------------------------------------------------------- > > > ------~-> > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor > --------------------~--> > <font face=arial size=-1><a > href="http://us.ard.yahoo.com/SIG=12hn1g54l/M=362131.6882499.7 > 825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123458553 > /A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org > ">Get Bzzzy! (real tools to help you find a job) Welcome to > the Sweet Life - brought to you by One Economy</a>.</font> > -------------------------------------------------------------- > ------~-> > > > Yahoo! Groups Links > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hs7cuha/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123460945/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
