[AccessD] Access 2010 + Navigation Forms

Hi Anita

Maybe I've seen too much!

The difference could be, that users in general believe they can handle Excel
while it is opposite for Access. So maybe a user maintained Access
application will receive a little more respect than an Excel workbook.

/gustav


-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Anita Smith
Sendt: 6. december 2013 09:56
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] Access 2010 + Navigation Forms

Oh but Gustav, you are so upbeat It's hard for me to curb my enthusiasm  ;-)


" After some years it will end as an advanced Excel workbook where no one in
the end knows why and how, nor by who it was created, and everything is a
mess."



Anita Smith


Hi Charlotte

At the contract I am working on we gave up on the Navigation form for
reasons though not identical then similar, and decided to bite the bullet
and use the ribbon. It allows you to move many of the buttons you otherwise
have sitting here and there for various tasks to a well-known location with
strict design and behaviour. 


/gustav

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Charlotte Foust
Sendt: 5. december 2013 22:06
Til: Access Developers discussion and problem solving
Emne: [AccessD] Access 2010 + Navigation Forms

Have any of you guys played with these?  The contract I'm on requires that
the product be maintainable by non-developers, engineers who have been to
Access classes but aren't fluent in it and don't tweak it on a daily basis.
 In the past I usually used tab controls and a fairly large amount of code
to design the user interface, but that isn't an approach that they would be
able to sustain.  One problem with Navigation Controls in Access is that
there is a wizard that builds a Navigation Form but I don't see any way to
use the controls on another form, and the wizard totally ignores Normal form
settings and even the Windows Themes setting in options.  I built code to
set the colors on the Open event of the Navigation Form but you have to use
RGB values to set them, and I don't see an easy way to make that modifiable
for when I'm gone.

Any suggestions?  One thing I learned accidentally is that if you set the
display size to 125%, you see some odd effects in the navigation control and
nav buttons.  Those disappear when you fall back to 100%, so apparently the
control is for people with normal eyesight!

Charlotte