It's the icon. Whenever I add an icon to the Reports & Forms from the Startup Menu, it signals the DB window to open and minimize On Open. Don't know why that is...........anyone?
Lynn Bryant --- In [email protected], "Lynn" <[EMAIL PROTECTED]> wrote: > I have nothing there but a Refresh Macro. :( > > L. > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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=12hf2kqju/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123598572/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</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/
