I am rather new to this in spite of being an old geezer so please bear with me; I am weak on nomenclature. I have prepared a small database of specialized definitions used in my office with the intention of posting it on the office LAN for others to use. Part of this effort included setting up my first switchboard ever. When I open the database, the switchboard appears. If I then close the database and re-open it, the database window appears instead of the switchboard. If I continue to cycle opening and closing the database, the switchboard and the database window alternately appear. I have reviewed my startup options and the switchboard is selected as the default form. Questions: (1) is this toggling of opening windows normal, and (2) how do I stop it and have the database open only with the switchboard unless I choose otherwise? Thanks.
Switchboard
- Thread starter slrphd
- Start date
EmmaJane
Registered User.
- Local time
- Today, 23:25
- Joined
- Nov 5, 2003
- Messages
- 214
Hi,
Don't know if it will help but I have a switchboard that opens when my users enter I have unchecked the box in start up that displays database window and then when I need to go in and make changes just hold shift and this takes me to the database window. I have never had this happen with mine so may help but then again may not..........
Don't know if it will help but I have a switchboard that opens when my users enter I have unchecked the box in start up that displays database window and then when I need to go in and make changes just hold shift and this takes me to the database window. I have never had this happen with mine so may help but then again may not..........
EmmaJane,
Thanks for responding. I checked the Startup options and the "Display Database Window" box is not checked. Is your database on a LAN? I wonder if the security setup has any influence on the way this owrks? Maybe that needs to be invoked before I get the behavior I desire and this toggling of opening windows is a convenience for the designer. I have not tried any the security setup yet as I am reluctant to post the application until I known it is working as needed.
Thanks for responding. I checked the Startup options and the "Display Database Window" box is not checked. Is your database on a LAN? I wonder if the security setup has any influence on the way this owrks? Maybe that needs to be invoked before I get the behavior I desire and this toggling of opening windows is a convenience for the designer. I have not tried any the security setup yet as I am reluctant to post the application until I known it is working as needed.
scouser
Registered User.
- Local time
- Today, 23:25
- Joined
- Nov 25, 2003
- Messages
- 767
Start Up Code In Northwind
Function HideStartupForm()
On Error GoTo HideStartupForm_Err
' Uses the value of HideStartupForm check box to determine the setting for
' StartupForm property of database. (The setting is displayed in Display Form
' box in Startup dialog box).
' Used in OnClose property of Startup form.
If Forms!Startup!HideStartupForm Then
' HideStartupForm check box is checked, so set StartupForm property to Main SwitchBoard.
CurrentDb().Properties("StartupForm") = "Main SwitchBoard"
Else
' HideStartupForm check box is cleared, so set StartupForm property to Startup.
CurrentDb().Properties("StartupForm") = "Startup"
End If
Exit Function
HideStartupForm_Err:
Const conPropertyNotFound = 3270
If Err = conPropertyNotFound Then
Dim db As DAO.Database
Dim prop As DAO.Property
Set db = CurrentDb()
Set prop = db.CreateProperty("StartupForm", dbText, "Startup")
db.Properties.Append prop
Resume Next
End If
End Function
Function HideStartupForm()
On Error GoTo HideStartupForm_Err
' Uses the value of HideStartupForm check box to determine the setting for
' StartupForm property of database. (The setting is displayed in Display Form
' box in Startup dialog box).
' Used in OnClose property of Startup form.
If Forms!Startup!HideStartupForm Then
' HideStartupForm check box is checked, so set StartupForm property to Main SwitchBoard.
CurrentDb().Properties("StartupForm") = "Main SwitchBoard"
Else
' HideStartupForm check box is cleared, so set StartupForm property to Startup.
CurrentDb().Properties("StartupForm") = "Startup"
End If
Exit Function
HideStartupForm_Err:
Const conPropertyNotFound = 3270
If Err = conPropertyNotFound Then
Dim db As DAO.Database
Dim prop As DAO.Property
Set db = CurrentDb()
Set prop = db.CreateProperty("StartupForm", dbText, "Startup")
db.Properties.Append prop
Resume Next
End If
End Function
To EmmaJane,
Thanks for the offer of your example. I can always use a comparison but maybe try Phil's (scouser) idea first. If I get nowhere with that, I'll ask for your copy as a second example.
To scouser,
Whoa! I thought these forums were conducted in English. What am I looking at and what does it tell me? I am reluctant to tamper with the code unless absolutely necessary. I like your suggestion of comparing to Northwind database. I used to use it when I started with Access 97 but haven't referred to it in 3-4 years now. Begin at the beginning is usually good advice. Thanks.
Thanks for the offer of your example. I can always use a comparison but maybe try Phil's (scouser) idea first. If I get nowhere with that, I'll ask for your copy as a second example.
To scouser,
Whoa! I thought these forums were conducted in English. What am I looking at and what does it tell me? I am reluctant to tamper with the code unless absolutely necessary. I like your suggestion of comparing to Northwind database. I used to use it when I started with Access 97 but haven't referred to it in 3-4 years now. Begin at the beginning is usually good advice. Thanks.
Phil,
Here's a surprise. The copy of Northwind used in my office does not have the switchboard setup as the default opening window. I'll have to set it up and see if I get the same toggling behavior. Hmm, film at 11.
Steven
Here's a surprise. The copy of Northwind used in my office does not have the switchboard setup as the default opening window. I'll have to set it up and see if I get the same toggling behavior. Hmm, film at 11.
Steven
To Phil and EmmaJane,
The answer to my problem turns out to be simple and it is dependent on how I open the database. If I open using the most recently used pick list, I get the toggling effect. If I open by using the Open Database icon on the file drop down menu, I always get the switchboard as the opening window. The answer for me is to make a custum file menu. Thanks for your suggestions. I hope we can collaborate at some point in the future
Steven
The answer to my problem turns out to be simple and it is dependent on how I open the database. If I open using the most recently used pick list, I get the toggling effect. If I open by using the Open Database icon on the file drop down menu, I always get the switchboard as the opening window. The answer for me is to make a custum file menu. Thanks for your suggestions. I hope we can collaborate at some point in the future
Steven
Similar threads
