Darryl Collins
Darryl.Collins at coles.com.au
Mon Jul 21 19:53:47 CDT 2008
Hi Rocky, Goto "Insert" > "Hyperlink" and then follow the instuctions (ie, choose which form you want to open). Access will then drop the hyperlink on the form for you. It will use the form name as the hyperlink, so you will want to change that from frm_MyForm to something useful "Main Menu" for example. let me know if you need a sample. cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin at Beach Access Software Sent: Tuesday, 22 July 2008 10:41 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Facelift for my App Darryl: Great stuff! I've already started to implement many of your suggestions. Particularly positioning like objects from form to form like the header. I guess raised and sunken is really 90s now, huh? Who knew? So flat it is. But hyperlinking the menu buttons is a new one for me. How does that work to open a form? Thanks and regards, Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Monday, July 21, 2008 4:56 PM To: 'Access Developers discussion and problemsolving' Subject: Re: [AccessD] Facelift for my App Hi Rocky, I read the replies before I got back to you so hopefully I don't repeat - I feel Dan has covered much of what need to be looked at already. I would consider taking an 'iPod' approach. Keep it very clean, simple with single or complementary colours. Consider getting rid of the buttons altogether and using hyperlinked text to do the job. Dan's point on the font is spot on - you need to use a more modern looking font. I would also remove the sunken boxes, raised boxes and etched frames. On the data entry fields I like to use colours to help the user. All free form data entry fields I use a dark blue font on a light green background. All combo boxes I use a dark maroon font on a light yellow background. All locked fields I use a dark grey font on a light grey background. This helps the user understand exactly what is required in each field from them - and what their options are. I would remove the green colour on the screen background. Just make the entire sceen one colour with a single bar top and bottom where the form header ends and the form footer starts. -- Main Menu -- Use frames with tiles for the three menu grouping - consider dropping the buttons altogether and using hyperlinked text to jump to the form you want. This look a lot cleaner and takes up much less space than using buttons. The header should be the same colour as the rest of the form. Consider making the entire screen white including the background. Make the backgound and boxes around the date and current database flat and plain - You could also make the font 70% grey or so. -- Part Master Maint Form -- I would put all the navigation buttons in a close group (touching) Consider making the "Add" "Delete" etc buttons all the same size. -- Bill of Material Form -- Header is a different colour - this is a total 'no-no'. Be consistent (it is white on the Part Master Maint. Form and gray here) Consider using frames rather than the raised boxes. -- Supply Side Maint Form -- I find the sub form nav buttons and the main form nav buttons confusing. I would frame the sub form and put the nav buttons within that frame. I would put all the navigation buttons in a close group (touching) -- Supply Side Report Form -- Drop the raised platforms for the radio buttons. Keep this flat and frame them if the grouping needs to be held together. The position of the footer buttons is inconsistent with the other forms - All the above forms have the buttons to the left, here they are too the right. - Make Report (sort selections) Form Drop the etched frames and use flat frames instead. Definately use normal frames for the 3 sort fields - and get rid of the white background on the frame titles. Again - use frames rather than raised platforms for the option buttons as well. Consider keeping the footer buttons more consistent - these ones are spread out accross the whole form. - Make Report (Data selections) Form The "Clear All" button font colour should be the same as the other buttons. See above for the rest of form. Overall. Consider making a template footer form with all the buttons that you are going to use already on it. then you can just hide the ones that are not required. Each form should have the buttons in the same place. The navigation buttons shouldn't move around from form to form - ditto with the "Close form" (or goto here...) should be in the same place. Maybe consider the footer along the lines of tight to the left - all the nav buttons. Then to the right you can have a section with all the custom button for that form - they may have to move around due to the lenght of the text. I would tighten it up a lot on the menus. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin at Beach Access Software Sent: Tuesday, 22 July 2008 12:30 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Facelift for my App Dear List: This must be my day to ask for help. I want to give one of my apps a facelift - change the colors, fonts, controls - stuff like that - to look more moderne. So I guess I'm looking for some web sties that might have some screen shots of forms from which I could get some ideas. The current app forms can be seen at http://www.e-z-mrp.com/ss_mainmenu.htm. So you can see what I mean - functional but not beautiful. What colors do you all favor for backcolors and forcolors? Fonts? Any suggestions welcome. MTIA, Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material.