MS Access 2007 Help.
|
|
MS Access 2007 Help. |
Access 2003 to Access 2007 Guide:
Access 2003 to Access 2007 interactive
command reference guide from Microsoft - very handy.
http://www.microsoft.com/downloads/details.aspx?FamilyID=b9574c72-657f-438c-9de9-f8f70dd2d40d&displaylang=en
Whats New in Access 2007:
http://office.microsoft.com/en-us/help/HA100241851033.aspx
Converting to Access 2007:
http://allenbrowne.com/Access2007.html
Access 2007 FAQ and help:
Jeff Conrad has some great resources at
http://accessjunkie.com/faq2007.aspx
http://accessjunkie.com/helplinks2007.aspx
New Features in Access 2007
http://www.access-freak.com/index.html
This website primarily deals with an introduction to new features
added in Microsoft® Access 2007 and a comparison between Microsoft® Access 2003
versus the new 2007 version.
Error Message: The Visual Basic for Applications
project in the database is corrupt:
You create a Microsoft Access 2007 database (.accde, or .mde
or .ade) file to give to your users. It runs fine on your machine and for
several other users, but some people get this error dialog as soon as they run
it:
"Microsoft Access 2007 SP1 Error Message: The Visual Basic for
Applications project in the database is corrupt"
For the life of you, you can't figure out why. The message says the VBA project
is corrupt, but the same file runs fine on other machines. And since it's an MDE/ACCDE/ADE
file, the user can't modify it making it doubly confusing how they could have
corrupted it.
In fact, it has nothing to do with VBA or database corruption. Your database is
fine. It just won't run on that machine..
See link for full details on how to fix this: http://www.fmsinc.com/MicrosoftAccess/Access2007%5FSP1/
How can you implement user level security if you are
using Access 2007
http://accessjunkie.com/faq_17.aspx
How do you close report in print preview mode in Access 2007
Kath Pelletti from the Access Mailing list said
she found this tool invaluable:
http://ribboncustomizer.clatonh.com/Main.aspx
She got it from a link sent to the list by Dan (see
http://blogs.msdn.com/access/archive/2007/12/05/access-ribbon-customizer.aspx).
It is a free download which helps you to quickly create a custom toolbar. It
allows you to select commands and it sets up the XML for you
One for reports and a different one for your main application.
Alternatively you could just customise the quick access toolbar and pop a close
button there....She has done that for one client. Right click on the
QAT (quick access toolobar, select customise....) That way you could get rid of
the ribbon. Or use the tool mentioned above to replace the ribbon with
one of your own.
(thanks to Kath Pelletti)