When creating a database application in Access 2010, you will sometimes come accross a situation where you will want to present several options to the end-user to choose from. For example you may have one form for data entry and one report, or you may have several forms and reports. This is where the idea of the ‘switchboard’ or ‘splash screen’ comes in. This handy switchboard can be used to present several choices for the end user to choose from. So this is what this tutorial is all about. And this is only the first part. In this part we will create the switchboard or splash screen (which will display as a pop up window when the user opens the database file), but in the next part of this we will fill the switchboard with photos and clickable (usable) buttons which will open forms and reports. So open up Access 2010 and get ready to create a switchboard!
The first step is simple. Just create a new form in design view. Resize the area to your liking and then click on the ‘other’ tab in the form’s properties. Change where it says ‘pop up’ from no to yes. Now switch to the format tab of the form’s properties. On this tab you will want to change ‘record selectors’ and ‘navagation buttons’ to NO and also set ‘control box’ and ‘close button’ to NO, and finally set min and max buttons to ‘NONE’. Now save your form and switch to display view. You should just see an empty window with no record selectors and no min,max,or close buttons, just like this:
OK, if you have something that looks like that then you are on your way. So close this switchboard out (right click somewhere in the popup window and select close). Now lets make this switchboard open automatically when this database is opened. To do that just go to the File tab and from there select the options tab towards the bottom, which will open up the database’s properties window, like this:
On the “current database” tab, you can set the title for the switchboard and even select an icon for the database itself. Just below those options is the one that will open the form when the database is opened. It says “Display Form” and you can select any form that you created in your database. The form that you select will open automatically when the database is opened. So choose the form that you just created, pick a title for it, then save these settings.
Close the database and reopen it. And when you do you should see the (blank) switchboard that we created earlier.
Not much here, just an empty window, but you can add whatever title you want and whatever graphics or photos to the background, and of course buttons to open forms or data entry. So this is just the starting point. Check the Switchboard’s properties add photos and other funcionalities to it.
Just be aware that you can even set this switchboard to open after a certain interval (or close after a certain interval) with some of the forms properties. But that is a little beyond this tutorial, but if you are interested in this just google it man.
O.k., next we will add some real functionability to this switchboard and even decorate it a little to make it look even nicer. So check back for part two of this tutorial.
Thanks for reading this blog!
Shane
This website offers pleasant quality YouTube videos; I always download the dance competition show movies from this site.
Terrific work! This would be the type of info that really should be shared across the word wide web. Shame on Yahoo for not positioning this submit greater! Arrive on in excess of and visit my web web site . Thanks =)
Hey There. I found your blog using msn. This is a very neatly written article. I’ll make sure to bookmark it and return to read extra of your helpful information. Thanks for the post. I’ll certainly return.
Hello friends, I am again at this place, and reading this post related to Search engine marketing, its also a nice article, thus keep it up.
it is really an informative post. thanks buddy lista de emails lista de emails lista de emails lista de emails lista de emails
I am lucky that I found this website , precisely the right info that I was looking for! .
Have you ever considered about adding a little bit more than just your articles? I mean, what you say is fundamental and all. But just imagine if you added some great images or video clips to give your posts more, “pop”! Your content is excellent but with images and videos, this blog could undeniably be one of the most beneficial in its field. Very good blog!
That is really interesting, You’re an overly skilled blogger. I’ve joined your feed and look ahead to in the hunt for extra of your excellent post. Additionally, I have shared your site in my social networks
Thank you for your blog post. Jones and I are already saving for just a new guide on this theme and your post has made us to save our own money. Your opinions really solved all our questions. In fact, above what we had known in advance of the time we came upon your great blog. I actually no longer nurture doubts plus a troubled mind because you have attended to all of our needs right here. Thanks
Follow this simple directions and you will be amazed how good this pizza
recipe really is. Just be sure to sprinkle the bottom
with cornmeal so the pizza will slide easier and pull the oven rack out so you aren’t likely to get injured while sliding it onto the pizza stone. Lay the dough on the tray or baking sheet, then dimple the dough until it’s a thick,
flattened circle.
Hey, you used to write fantastic, but the last few posts have been kinda boring¡K I miss your great writings. Past few posts are just a bit out of track! come on!
Wow, great weblog layout! How long have you been blogging for? you make blogging appear easy. The overall look of your web site is amazing, let alone the content!
i agreed, this is a fantastic article for all the newbie too… lista de email lista de email lista de email lista de email lista de email
Do you have a spam problem on this blog; I also am a blogger, and I was wanting to know your situation; many of us have created some nice procedures and we are looking to trade strategies with other folks, be
sure to shoot me an email if interested.
I have been surfing online more than 3 hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. Personally, if all site owners and bloggers made good content as you did, the web will be much more useful than ever before.
I have read so many posts about the blogger lovers however this paragraph is in fact a good article, keep it up.
This paragraph will assist the internet viewers for creating new web site or
even a weblog from start to end.
The very heart of your writing whilst appearing reasonable originally, did not sit properly with me after some time. Someplace within the sentences you managed to make me a believer unfortunately just for a while. I however have got a problem with your jumps in logic and one might do well to help fill in those gaps. In the event that you actually can accomplish that, I could certainly end up being impressed.
I also like Flash, but I am not a good designer to design a Flash, however I have computer software by witch a Flash is automatically produced and no additional to work.
What You Can Gain. Gaining information about your enemy is the
first step in assuring success in defeating him or her.
The Paleo Gluten Free Diet has many health claims.
– Exorphins: Anti-nutrient found in dairy products and wheat.
Obesity is an epidemic in our society. Ingredients.
As a Newbie, I am constantly browsing online for articles that can help me. Thank you
Cheap Gucci Handbags Is usually blogengine a lot better than wp for reasons unknown? Really should be which is turning out to be popluar today.
Heya i am for the first time here. I found this board and I find It really useful & it helped me out a lot. I hope to give something back and aid others like you aided me.
Everything composed was very reasonable. But, what about this? what if you wrote a catchier title? I mean, I don’t wish to tell you how to run your website, but suppose you added something that makes people want more? I mean How to Create a Switchboard (or Splash) Screen in Access 2010 by Shane Zentz | Shane Zentz's Blog is kinda boring. You could look at Yahoo’s home page and see how they write news titles to grab viewers to open the links. You might add a video or a picture or two to get readers interested about everything’ve got to say. Just my opinion, it would make your website a little bit more interesting.
Hi, it’s my personal first comment here, and already I need to commend Cie! Wonderful weblog! While looking at your entries over the feel feelings we given to this operate! Good luck inside your work! I expect that We are a typical visitor in this article!
This is very interesting, You are a very skilled blogger. I have joined your feed and look forward to seeking more of your magnificent post. Also, I have shared your web site in my social networks!
Great write-up, I am normal visitor of one¡¦s website, maintain up the nice operate, and It’s going to be a regular visitor for a lengthy time.
CL8Gcc ellsemjbdjpr, [url=http://vssshlygpbfm.com/]vssshlygpbfm[/url], [link=http://bbctittggvnj.com/]bbctittggvnj[/link], http://klonfvykwvcb.com/
Its such as you read my mind! You seem to know so much about this, like you wrote the e book in it or something. I believe that you just can do with some % to drive the message home a little bit, however instead of that, that is fantastic blog. An excellent read. I’ll definitely be back.
Nice post. I was checking constantly this weblog and I am inspired! Extremely useful info specially the closing section 🙂 I take care of such info a lot. I was seeking this certain information for a long time. Thanks and best of luck.
It is truly a great and useful piece of info. I am happy that you just shared this useful information with us. Please stay us informed like this. Thank you for sharing.
Hi, this weekend is pleasant designed for me, since this occasion i am reading this great educational article here at my house.
Your style is very unique in comparison to other people I have read stuff from.
Many thanks for posting when you have the opportunity, Guess I’ll just bookmark this page.
Maybe no one will probably read this. But just in case you do. Can You Put A “Thumbs Up “So Others Can See.. I Just started rapping seriously (type in lunden-be you). just a simple button can help my dream come true.. people will ignore this but if you don’t can you listen and subscribe God Bless
Thanks for finally talking about > %blog_title% < Liked it!
Hey! This is kind of off topic but I need some advice from an established blog. Is it hard to set up your own blog? I’m not very techincal but I can figure things out pretty fast. I’m thinking about setting up my own but I’m not sure where to begin. Do you have any ideas or suggestions? Thank you
I do agree with all of the ideas you have presented for your post. They are very convincing and can certainly work. Still, the posts are very quick for newbies. May you please lengthen them a little from subsequent time? Thank you for the post.
I was recommended this blog by my cousin.
I’m not sure whether this post is written by him as nobody else know such detailed about my difficulty. You are wonderful! Thanks!
Wow, amazing blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your web site is fantastic, let alone the content!
I am John, how are you everybody? This article posted at this site is actually nice.
I’ve been browsing on-line more than three hours today, but I by no means discovered any interesting article like yours. It’s lovely price enough for me. Personally, if all webmasters and bloggers made excellent content as you did, the net will probably be much more helpful than ever before.
I am curious to find out what blog platform you are utilizing?
I’m having some small security problems with my latest site and I’d like to find something more
secure. Do you have any suggestions?
With the proper equipment and ingredients, you can make homemade pizza that tastes a thousand times better
than what you’ll find at your favorite restaurant. The grill unfortunately is a risky place to cook meals, and also the griddle can be a great present towards the wellbeing aware. Add the water a teaspoon at a time so it’s not
over done.
Do you have a spam problem on this blog; I also am a blogger, and I was wondering your situation; we have developed some nice methods and we are looking to exchange techniques with others, please shoot me an email if interested.
I’m amazed, I have to admit. Seldom do I encounter a blog that’s both equally educative and interesting, and without a doubt, you have hit the nail on the head. The issue is something not enough men and women are speaking intelligently about. Now i’m very happy that I stumbled across this in my hunt for something regarding this.
You are a very clever individual!
Let’s say for example you find an 100 unit apartment building that is inexperienced in this industry. As a hard money lender. Recent lending policies enacted by banks and other costs will also only lend from the lender already owns.
I and my mates watch the football game clips at YouTube always, since they have in nice quality.
Does your blog have a contact page? I’m having a tough time locating it but, I’d like to shoot you an e-mail. I’ve got some ideas for your blog you might be interested in hearing. Either way, great site and I look forward to seeing it improve over time.