
Invalid Page Fault When Function Called
My problem is that Access 7.0 crashes with "invalid page fault in module
MSJT3032.DLL" whenever I call a certain function from a certain form. The
function works fine in other forms in similar situations.
The function in question is called when a combo box on the form is updated
to restrict the records appearing in the form. The function calculates the
last day of the week for a value chosen from the combo box (for example
"This Week", "Last Week",etc.). A filter is then applied to the form to
choose only those records equal to the date returned from the function.
There are a few other things you should know: 1) The application doesn't
crash until the filter is applied, 2) the 'WHERE' clause created for the
filter seems to be of proper syntax, and 3) If I take the function out and
replace with another process the application doesn't crash.
I am confident that the date being passed to the function is of date
format. I also have replaced my old MSJT3032.DLL with the one available
from the Microsoft site. Does anyone have any ideas of what I should try
next?