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.7825260.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 <*> 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/
