Hello, I have a DB that was built in access 2003 and works fine but now I have an employee that recieved a new PC and they have access 2007 installed. Everything works fine in 2007 except for one thing. When the employee pulls up a report it comes up but if the report is lets say 2 pages or more they can only see the first page due to there is no record selector. How can I get a record selector for a report if its more than one page?

Thanks,
Chad

Chad,

About the Access 2007 report, is the report viewed in Print Preview mode or in Report View? The page selectors are only in Print Preview. In Report View, you use the vertical scroll bars.

About using Access 2003 and 2007 at the same time:
I have found issues with 2003 and 2007 opening the same front end. I would make sure that every users has their own copy of the front end that is not shared.

Curious, Is your front end an MDE?

Hello, I'm not sure what view the report is opened in when its ran in 2007. The database is an .mdb because there is only ever going to be one person at a time opening the database, there is never more than one.

Two things:

1. Force your report to open in Print Preview mode in your Docmd.Openreport code (as Boyd aka HiTechCoach pointed out).
DoCmd.OpenReport "Name_Of_Report", acViewPreviewOR

2. Uninstall just Access 2007 from the Office 2007 suite and install Access 2003 on the machine.

Hello, will try option 1 on Monday.... Thanks!

Well I have access 2003 on my PC but I added the code to the on open event of the report and everything is working regularly but I have to wait untill tomorrow untill the user that has the access 2007 on thier PC to see if it worked... Let you know!

Thanks,
Chad

I don't understand when you said you're using the On Open event of the report? I thought you were opening the report using Docmd.openreport?

vbaInet, I messed up I was putting the code you gave me in the reports On Open event insted of the button that opened the report...:p Here is what I have in the button that opens the report:
Private Sub cmdOption2_Click()
On Error GoTo Err_cmdOption2_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "rptDailySuperlog"
DoCmd.OpenReport stDocName, acPreview

Exit_cmdOption2_Click:

Exit Sub

Err_cmdOption2_Click:
MsgBox Err.Description
Resume Exit_cmdOption2_Click
End Sub


It is already opening the report in preview mode, what do you sugest because it still doesnt show in A2007? Thanks!

You missed what I was relaying to you.

You don't put that in the On Open event. Is it not a button on a form you use to open the report?

The newer code is

DoCmd.OpenReport stDocName, acViewPreview

SOS, I see I will add the "view" and post back tomorrow.... Thanks all!

Good spot SOS. I was just thinking the OP simply copied and pasted my code.

oxicottin: Again, you don't need that in the Open event of the report. I would need to know how you open the report?

vbaInet, I know that now.... I dont know why I was trying to do it that way! I havent messed with access for a while and I got all discombooberated :p
Im sure this will work but I will post results tomorrow after the user tries it.

Thanks,
Chad

Alrighty. Let us know how it goes.

Im told the page nav still did not show up in the A2007 but works fine in my a2003. Any ideas? The only thing I did was changed the code in the button that opens the report to the code below, I didnt change anything in the reports code.
Private Sub cmdOption2_Click()
On Error GoTo Err_cmdOption2_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "rptDailySuperlog"
DoCmd.OpenReport stDocName, acViewPreview

Exit_cmdOption2_Click:
Exit Sub

Err_cmdOption2_Click:
MsgBox Err.Description
Resume Exit_cmdOption2_Click
End Sub

May be do I need to change something in the reports properties?

My guess your client didn't use the file you sent him/her, or you probably forgot to send the file with the amendment :)

Zip, upload and post and I'll have a quick look. I run both versions.

Well, I made the changes personaly because im the only one who knows how to simi do this stuff and its only one .mdb database on our server and we each enter info but never at the same time. If I were to zip it up I would have alot of deleting personal info and infomation so do you have any other ideas? If not then give me some time to delete stuff....

Thanks,
Chad

Here is the form that opens the DB and the report with 14 pages of data for the report.

Thanks,
Chad

They're there. Your pop up/modal settings hide them. See attached.

Well how can I get it to show at the bottom of the pop up? when I open it in 2003 it shows full screen and the nav is at the bottom of the page. I wanted it to show the same way in A2007. I know nothing about A2007.... :confused:

Thanks,
Chad

Don't use a pop-up!

My boss likes it full screen so is there a work around? Plus, it opens on top of the frmswitchboard...

Your boss can zoom into the report or minimize the ribbon before the report is run. Or you set the dimensions of the report.

My boss likes it full screen so is there a work around? Plus, it opens on top of the frmswitchboard...

NOTE: 2007 GUI is a lot different. It does not behave the same way as the previous versions do.

What does using Pop-up have to do with making it a report full screen? I make reports full screen and never open a report as pop-up.

I only use pop-up forms for very special forms that need the users attention before doing anything else. IMHO, making all forms pop-up makes your database a lot less user friendly and a lot less productive.

IMHO, making all forms pop-up makes your database a lot less user friendly and a lot less productive.

And I agree wholeheartedly with that statement. If you want something to show over the top of something, just hide that something and then show it again when you close the thing you wanted to show over the top.

HiTechCoach, How do you make it full screen in 2007 without using popup? If this cant be done then I will have some figuring to do...:(

Thanks,
Chad

Will this example work in A2007? I hid the menu on start up using Private Sub Form_Load()
'*********************************************
'* Disables/Enables the menu bar *
'*********************************************
'Application.CommandBars("Menu bar").Enabled = False '*****Disables Menu Bar******
Application.CommandBars("Menu bar").Enabled = True '*****Enables Menu Bar*******

DoCmd.MoveSize , 800 'Moves switchboard down on screen
End Suband added Me.Visible = False 'Hides the switchboard to the switchbord and Private Sub Report_Close()

Forms![frmSwitchboard].Visible = True 'Shows the frmSwitchboard again

End Sub to the report and set the report to no on the pop up.

If this forum ran a Test Centre I would have been more than happy to test it out for you :D

You can't be developing for a version of Access without having a copy running on your machine. Ask your boss to get you a copy ;) As explained by HiTechCoach the UI in 2007 is completely different from all other versions. 2007 doesn't use Menu bars so your code won't work, well it will work in the Add-Ins tab :)

Sorry just thought you would look at the code I posted. My bad!

Sorry just thought you would look at the code I posted. My bad!

Is there some reason you do not install the free Access 2007 runtime and test it?

I had a copy of office 2007 on my home PC and uninstalled it due to I hated it, it to me was confusing and to much. When you just start to learn something someone changes it and you have to start all over, I do not want to relearn what I know now because I struggled doing what I have done so far. I must say that this forum along with UA and MS discussion group has helped me a lot and I couldn’t have done it without you! (Thank You) I will just fix the pop up and be done with it.

Thanks,
Chad

Oh and my boss is cheap! so if I wanted to learn it I would have to do it at home "Off the clock" :eek:

Chad,

unfortunately it is not a question of will you learn the new way of 2007, but a matter of when. It is the future.

I had a copy of office 2007 on my home PC and uninstalled it due to I hated it, it to me was confusing and to much. Never shy away from difficulties. If you overcome them, the you would know how to handle them in the future and you will have a clearer understanding.

When you just start to learn something someone changes it and you have to start all over, I do not want to relearn what I know now because I struggled doing what I have done so far.You've got to keep up with the times ;) If you want to learn 2007 then you have to think laterally when it comes to the UI. The db concept hasn't changed much. The way you call a function/procedure is the same, the way you apply methods is the same. Like with any new version of Access there will be added methods, properties and functions. This is where Intellisense and the help files come in handy.

I must say that this forum along with UA and MS discussion group has helped me a lot and I couldn’t have done it without you! (Thank You) I will just fix the pop up and be done with it.That's the way forward :D

Oh and my boss is cheap! so if I wanted to learn it I would have to do it at home "Off the clock" :eek:Again, personal development is for your own benefit in the long run so it still is a plus.