Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Odd occurrence with a report??

Status
Not open for further replies.

tamer64

IS-IT--Management
Aug 27, 2007
120
US
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?
 
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.
 
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
 
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, [red]StrReport1[/red]

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

Thank you for suggestions!
 
Pure Genius! That was it "Auto Hide". Dhookom, Thank You!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top