Yes, it is! On the HOME computer, adding a bitmap=Opening a DB window on Open. WORK comptuer, not. That's why I was thinking something in my computer settings?
Lynn Bryant --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > Lynn- > > 'Tis a mystery. I always use Icon files, not bitmaps. You can find several > icon editors available for download on the web. Try one of those and > convert your bitmap to a true icon. > > 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 10:00 AM > To: [email protected] > Subject: [ms_access] Re: Switchboard Question > > > 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 Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h31gkk9/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123648893/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/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 <*> 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/
