Lynn- Ummm. On the Macros tab in the Database window.
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 5:53 PM > To: [email protected] > Subject: [ms_access] Re: Switchboard Question > > > Ok, John, where do I look for that? I don't have a clue.... > > Lynn > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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=12hvsj4og/M=362131.6882499.7 > 825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123462367 > /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=12hgcmqmf/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123463225/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/
