By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,430 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
filter.

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
'no'...???

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
Form"
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:
msaccess.exe
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.