INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!

*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.

Jobs

Odd occurrence with a report??

Odd occurrence with a report??

(OP)
I have an odd thing going on here with one of my Reports. The navigation bar at the bottom of the report where it allows you to navigate through pages is only visible to me only. Whatever computer I logon to it is visible to me only, but if someone else logs onto a computer the page selector is not visible to them.

I am using MS Access 2007, so built-in security in not the problem as it does not exsist. I have checked the permission for the database. Windows security permissions for users were set to modify rights and changing it to Full Permission did not make any difference.

I need to have that page selector visible on the report so the users can navigate. Page Down and Page Up work just fine for navigating that is until the a user uses the left click on the mouse to zoom-in on a report. When this occurs it disables the page up and page down.

Any Ideas on why I am the only one who can see the page selector and not other users at the bottom of a report? Additionally, why is it when you zoom-in on a report in print preview, the Page Up and Page Down feature is disabled once you left click to zoom-in on a report?

RE: Odd occurrence with a report??

Are you sure this is a report and not a form? It sounds a lot like you are talking about the Navigation buttons being turned off in a form.

In any case, I would look at the code that is on the form/report as well as the code that opens it for anything unusual.

RE: Odd occurrence with a report??

(OP)
I dont see anything unusal as far at the report opening. On the form itself, I have a button which opens the report. The main report itself does contain a subreport.

DoCmd.Maximize
DoCmd.RunMacro "mcrHide"
Dim strInput As String
Dim i As Integer
Dim intCopies As Integer
Dim StrReport1 As String
StrReport1 = "Schedule"

MsgAnswer = MsgBox("Yes=Print Now. No=Preview. Cancel=Cancel.", vbYesNoCancel, "Print Options")

Select Case MsgAnswer
Case vbYes
intCopies = InputBox("Please enter number of copies", "Copies")
' DoCmd.PrintOut , , , , intCopies, True
DoCmd.OpenReport StrReport1, acPreview
DoCmd.PrintOut , , , , intCopies, True
DoCmd.Close acReport, "StrReport1"
DoCmd.OpenForm "Form_Assignments", acNormal
DoCmd.Close acReport, "Schedule"

GoTo Exit_Command458_Click
Case vbNo
DoCmd.OpenReport StrReport1, acPreview
DoCmd.Maximize
GoTo Exit_Command458_Click
Case vbCancel
MsgBox "Print Cancelled.", vbOKOnly, "Print Message"
End Select

Exit_Command458_Click:
Exit Sub

Err_Command458_Click:
MsgBox Err.Description
Resume Exit_Command458_Click

DoCmd.Maximize
End Sub

RE: Odd occurrence with a report??

I must say I am at a loss... If it works with you logged in on the same system... Then it must be a user profile thing whether that is an Access property or some other weird thing...

The only thought I have is to write something to read all the Access properties. Run it as you and have a user run it. Compare the data to find any differences... Hopefully it will be illuminating... I did not see anything in Access 2007 that jumped out at me.


Unrelated, thers is a small change I would make in your code...

DoCmd.Close acReport, "Schedule"

Change to ...

DoCmd.Close acReport, StrReport1

RE: Odd occurrence with a report??

(OP)
Ok I will try that and do somemore digging around to see what the problem may be.

Thank you for suggestions!

RE: Odd occurrence with a report??

I would also check to see if other users have Auto-Hide the task bar checked in Windows.

Duane
Hook'D on Access
MS Access MVP

RE: Odd occurrence with a report??

(OP)
Pure Genius! That was it "Auto Hide". Dhookom, Thank You!

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!

Resources

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