General discussion

Locked

Office 97 Access Release 2 and Y2K and P

By Chalo ·
A consultant loaded Office Professional 97 Release 2 as part of a Y2K upgrade. Now the print fuction for Access only allows three digits when one selects print by page. We break up print jobs by specifying page ranges and now, we can not specify apage number greater than 999 in Access 97 release 2. This is affecting productivity waiting for the whole job to print on one printer because these are pick sheets used for bottle picking.

First, is it true we need to be on Access 97 Release 2 tobe Y2K compliant (we have experienced bugs on release 2?) Also, does anyone know the best way to fix the three digit page limit?

Thanks

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Office 97 Access Release 2 and Y2K and P

by ozinok In reply to Office 97 Access Release ...

I have a workaround for the page problem. You can create a macro that will do the printing for you. The macro will need 2 actions: 1) SelectObject and 2) PrintOut.

The 3 arguments for SelectObject should be:
Object Type.............: Report (or Form, etc.)
Object Name............: the name of your report (or form, etc.)
In Database Window.: Yes (if not currently open) No (otherwise)

The 6 arguments for PrintOut should be:
Print Range....: Pages
Page From.....: startingpage number
Page To.........: ending page number
Print Quality...: your choice
Copies............: your choice
Collate Copies: your choice

Modify and run this macro anytime you need to print pages above 1000. This doesn't actually fix the problem in the dialog box, but it works.

As far as Y2K, I don't know the answer. We were forced to upgrade also.

Hope this helps!

Collapse -

Office 97 Access Release 2 and Y2K and P

by Chalo In reply to Office 97 Access Release ...

The question was auto-closed by TechRepublic

Collapse -

Office 97 Access Release 2 and Y2K and P

by dixon_fe In reply to Office 97 Access Release ...

Office 97 SR-2 did correct known issues in the area of Y2K concerns. It assisted with date parsing and other known date flaws. But, it is not the only thing to consider. After all, without setting your date to a long date style in the Regional Settings in your Control Panel, it will still read as 00 vice 2000. As for why your Access will not print about three digit numbers, you have me stumped. I just printed pages 12125 to 12167 without flaw.

Collapse -

Office 97 Access Release 2 and Y2K and P

by Chalo In reply to Office 97 Access Release ...

The question was auto-closed by TechRepublic

Collapse -

Office 97 Access Release 2 and Y2K and P

by rrberndt In reply to Office 97 Access Release ...

Is SR-2 needed for Access 97? I don't know.

What's the best way to fix the three-digit page limit? When we ran into this problem, Microsoft suggested a solution involving a macro along the lines of ozinok@netscape.net's reply. While this permits you to print pages numbered above 1000, it also requires you to update the From and To page numbers in the macro.

I found an alternative at www.zdjournals.com/ima, in their Message Forum. In a post from Friday April 16 1999 at 16:55:31, ChrisKoyl suggested the following code to print from a form directly to a report:

"Just thought I would share this because I thought it was very useful. If you need to print from a form directly to a report you can create a button and use this code:
Private Sub Command36_Click()
OnError GoTo Err_Command36_Click

Dim stDocName As String
Dim MyForm As Form
Set MyForm = Screen.ActiveForm

stDocName = "File Information Report"
DoCmd.OpenReport stDocName, acNormal, , MyForm.Filter

Exit_Command36_Click:
Exi

Collapse -

Office 97 Access Release 2 and Y2K and P

by Chalo In reply to Office 97 Access Release ...

The question was auto-closed by TechRepublic

Collapse -

Office 97 Access Release 2 and Y2K and P

by lnk52075 In reply to Office 97 Access Release ...

First of all, the information I have says yes, you need SR2 for Y2K.
The print range problem only applies to NT. Access 97 on Win 9x does not suffer this limitation. It may not be the solution you want, but moving Access to Windows 98 fixes the problem and is not terribly expensive.
Good luck.
LK

Collapse -

Office 97 Access Release 2 and Y2K and P

by Chalo In reply to Office 97 Access Release ...

The question was auto-closed by TechRepublic

Collapse -

Office 97 Access Release 2 and Y2K and P

by Chalo In reply to Office 97 Access Release ...

This question was auto closed due to inactivity

Back to Windows Forum
9 total posts (Page 1 of 1)  

Operating Systems Forums