Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Access 2010 reports

Access 2010 reports

Access 2010 reports

I have placed buttons on my access 2010 reports to performs such functions as print PDF, close report etc, but they only function when I open the database holding the shift key down. I have tried switching things like Allow Full Menus, Allow Default Shotcut Menus, Display Status Bar, Enable Layout View etc on and off and it still won't allow me to use a button without starting in Shift Key Down mode. There is no AutoExec file.

RE: Access 2010 reports

What are your 'Trust Center' settings? Check those first.

When all else fails, manipulate the data.

RE: Access 2010 reports

Thanks Trevil, but I had already added in the trusted location - I have just checked in Trust Center and reset to allow everything, but still no result. The function buttons appear, but they can't be clicked in the reports.

RE: Access 2010 reports

Make sure all your modules have 'Option Explicit' at the top, then COMPILE to make sure there are no errors.
Do you see any warning messages displayed when Access opens?
Holding down the shift key was designed to allow you to bypass startup options. Than means either a setting or macro or code.
Is this an '.accdb' file or other?

When all else fails, manipulate the data.

RE: Access 2010 reports

Sorry to be stupid, Trevil but I'm not very good with code. Do you mean where code "Option Compare Database" is , then follow this with "Option Explicit" on the next line, or replace that line?

RE: Access 2010 reports

Add a new line, after 'Option Compare...' with 'Option Explicit'

When all else fails, manipulate the data.

RE: Access 2010 reports

Oh dear, not that either. I'm racking my brains to see what the problem is, but so far no joy.

RE: Access 2010 reports

I've solved it - I've gone back to an earlier version, and changed the way the reports displayed (as "Report" rather than "Print Preview") and that has worked - a similar solution didn't work in the latest version for some reason.
Many thanks Trevil for helping me - I'd still like to know what was wrong, but just thankful that I have a working version again!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close