Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-15-2014, 03:26 AM   #1
rm.harper
Newly Registered User
 
Join Date: Mar 2014
Location: Manchester, UK
Posts: 47
Thanks: 11
Thanked 3 Times in 3 Posts
rm.harper is on a distinguished road
Creating a User Interface for an internal database

Hi, Just after a point in the right direction. Im looking to design and create a user interface for my database. Preferably hiding the standard access interface and upon opening the database have a pop up form with buttons to direct users to forms queries and the nice helpful stuff I made the database for.

Ive found various terms for what im looking to do; Custom menu bar (hiding access interface), Launch pad form, switchboard, front end etc... but all I want is the correct term or tutorial so I can have a proper good look into it.

Any sources or help is appreciated as always.

Thanks in advance
R Harper

rm.harper is offline   Reply With Quote
Old 04-16-2014, 06:16 AM   #2
Old Man Devin
Consul Of Code
 
Old Man Devin's Avatar
 
Join Date: Jan 2014
Location: UK
Posts: 183
Thanks: 7
Thanked 35 Times in 35 Posts
Old Man Devin is on a distinguished road
Re: Creating a User Interface for an internal database

Things like Front or Front End are the ones I've most commonly seen to refer to database user interfaces, so I would start there. The type of thing you are suggesting is one of the most common forms of front end design, so there will likely be templates or examples you can find through google to get you going!

The term 'swichboard' I've only heard when talking about making the front end have different entry routes (like different users seeing different parts of the database). As for the pop up form idea, what you want to look into is the Access setting that sets a form to automatically open when the database is opened. I think you congifure this through File-Options-Current Database (Access 2010). It needn't be a pop up for this, but you can make pop up forms by just setting the form's 'Pop Up' property to Yes.
__________________
The answer is out there.

For all your Access, Excel, VBA and GIS needs:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Old Man Devin is offline   Reply With Quote
Old 04-17-2014, 03:08 AM   #3
rm.harper
Newly Registered User
 
Join Date: Mar 2014
Location: Manchester, UK
Posts: 47
Thanks: 11
Thanked 3 Times in 3 Posts
rm.harper is on a distinguished road
Re: Creating a User Interface for an internal database

Quote:
Originally Posted by Old Man Devin View Post
Things like Front or Front End are the ones I've most commonly seen to refer to database user interfaces, so I would start there. The type of thing you are suggesting is one of the most common forms of front end design, so there will likely be templates or examples you can find through google to get you going!

The term 'swichboard' I've only heard when talking about making the front end have different entry routes (like different users seeing different parts of the database). As for the pop up form idea, what you want to look into is the Access setting that sets a form to automatically open when the database is opened. I think you congifure this through File-Options-Current Database (Access 2010). It needn't be a pop up for this, but you can make pop up forms by just setting the form's 'Pop Up' property to Yes.
Thanks, after posting this i made a back up file and just started experimenting. Ive set all my forms to pop up as Ive programmed by access to now hide behind my Main Switchboard (custom form with buttons which set macros automatically depending on the command i set, which helps alot!) Taking the Nav pane and ribbon out of the way once the acces file is opened my main switchboard is the only visible thing and also the only thing in access you can do anything with unless its closed down. Managed to get a nice little interface going without having to get hard into coding and such. Quite pleased with how its gone. Think access if generally and easy thing to use once you get your head around how things work and what you can do with it.

Thanks very much for your help

rm.harper is offline   Reply With Quote
Old 04-17-2014, 07:07 AM   #4
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,791
Thanks: 55
Thanked 1,027 Times in 993 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Creating a User Interface for an internal database

Personally, I like the standard MS Switchboard although I use a modified form of the A2003 one, rather than the switchboard supplied in later access versions

__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question Creating a user interface in Access 2007? teresamichele General 8 10-18-2010 08:44 AM
Chinese input into MSSQL 2005 database through MS Access 2003 user interface pradaloh General 0 09-02-2009 01:33 AM
Question Creating a User friendly Interface purceld2 General 5 12-08-2008 07:48 AM
New User creating an attendance database aquavelvaman Tables 1 01-03-2008 02:44 PM
[SOLVED] Create user interface for my database ilun82 General 1 10-31-2002 09:20 AM




All times are GMT -8. The time now is 01:24 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World