471,851 Members | 1,251 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,851 software developers and data experts.

Bug: print preview in form datasheet with server filter on crashes access (ADP A2002 SP3)

I've discovered:

Using "File > Print Preview" in a form's datasheet view with a server Filter
crashes access after previewing...

....that is, unless ServerFilterByForm has been turned off after applying the

See the steps to recreate bug below for details.

I'm looking for a workaround. Possibly some way to trap the print preview
event prior to execution and (temporarily?) reset ServerFilterByForm to

Please don't say "don't use print or print preview with datasheets". I'm
(semi) intent upon allow my users to print out a list of whatever they can
compose on their screen.
Thanks for any help,
Malcolm Cook - me*@stowers-institute.org
Database Applications Manager - Bioinformatics
Stowers Institute for Medical Research - Kansas City, MO USA

Steps to recreate bug:

While using Access version 2002 SP 3

While running access 2002 SP3
Create a new ADP against Northwind database
Use the form wizard to create a new datasheet form against the Cataegories
table (or any table, probably)
Edit the form properties to set "Server Filter By Form" = yes
Open the form and notice the window title is "Categories: Server Filter By
Compose a search and "Apply Server Filter"
OPTIONAL: Use the form wizard to set "Server Filter By Form" = no
Select "File > Print Preview"
Hit 'escape' to dismiss the preview
Whoa! If you did NOT take the optional step above, you are returned to the
form as though it were collecting a new server filter as indicated by the
window title being "Categories: Server Filter By Form". However, the
problem is worse becuase access then crashes.

If you DID take the optional step (oh, wise one) then you are returned to
the filtered selection of records.
Error signature
AppName: msaccess.exe AppVer: 10.0.6501.0 ModName:
ModVer: 10.0.6501.0 Offset: 0000769e

Exception Information
Code: 0x000009a0 Flags: 0x00000000
Record: 0x00000000c0000005 Address: 0x0000000000000000

System Information
Windows NT 5.1 Build: 2600
CPU Vendor Code: 01860094 - 30025EC0 - 00000001

CPU Version: 00000F24 CPU Feature Code: 3FEBFBFF
CPU AMD Feature Code: 00BCE804

Nov 12 '05 #1
0 2096

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Wim van Rosmalen | last post: by
3 posts views Thread by sea | last post: by
2 posts views Thread by Bruce | last post: by
8 posts views Thread by Tony Toews [MVP] | last post: by
reply views Thread by NeoPa | last post: by
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.