A bitmap. Last night I added a pic to a DB at home and it gave me the DB window on open. I removed the bitmap and viola, no DB Window.
I came to work today, added a bitmap to a DB here on this computer and it did NOT give the DB window on open. So, the more I work on it, the more confuseder I get. ;) Lynn Bryant --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > Lynn- > > That shouldn't be affecting it at all. Are you pointing to a true Icon file > (.ico), or just a bitmap? > > 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: Tuesday, August 09, 2005 7:42 AM > To: [email protected] > Subject: [ms_access] Re: Switchboard Question > > > 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 Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hb1vapm/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123606821/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/
