473,701 Members | 2,403 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access automatically shuts down after filtering or sorting a form

Hi,

I have a form that take some time to load due to many comboboxes and at
least 8 subforms.
When I filter or sort the main form I get an error message and then Access
shuts down. They ask if I want to send the error report to Microsoft. Has
anybody seen this type of error message and what can I do to prevent it from
happening. Am I doing something illegal in my code? It used to work but I
have added conditional formatting to a subform but that shouldn't cause any
problem. It ONLY happens when I try to filter or sort the main recordset
using Access built-in functions. I am using Access 2002.
Any help appreciated
Richard
Nov 12 '05 #1
5 3083
Conditional formatting in a sub-form and filtering the main form caused this
problem for me, remove the formating and then see if the problem doesn't go
away. Incidentally, I'll bet that as long as you don't apply a filter to the
main form the database will work fine even with conditional formatting in
the sub-form. I have had almost exactly the same problem, only in my case
Access 2002 would not shut down until I attempted to scroll after filtering.
You are lucky, because your post contains the cause of this problem and
because mine didn't start until I switched to 2002 it took me longer to
track down.

--
Jeffrey R. Bailey
"Richard" <rw**********@c hello.se> wrote in message
news:G3sub.3792 $%W3.19990@amst wist00...
Hi,

I have a form that take some time to load due to many comboboxes and at
least 8 subforms.
When I filter or sort the main form I get an error message and then Access
shuts down. They ask if I want to send the error report to Microsoft. Has
anybody seen this type of error message and what can I do to prevent it from happening. Am I doing something illegal in my code? It used to work but I
have added conditional formatting to a subform but that shouldn't cause any problem. It ONLY happens when I try to filter or sort the main recordset
using Access built-in functions. I am using Access 2002.
Any help appreciated
Richard

Nov 12 '05 #2
Incidentally what you are doing isn't illegal and the solution I described
above is only a work around. When I had the problem I searched the news
groups and knowledge bases and never found mention of anyone else having it.
I have always assumed it to be an issue related to running multiple
development environments on my main machine. I worked around conditional
formatting by adding some check boxes to reflect the state of the records in
a different way. I couldn't do without filtering the main form in my
application.

--
Jeffrey R. Bailey
"Jeffrey R. Bailey" <mr**********@y ahoo.com> wrote in message
news:AP******** *******@twister .tampabay.rr.co m...
Conditional formatting in a sub-form and filtering the main form caused this problem for me, remove the formating and then see if the problem doesn't go away. Incidentally, I'll bet that as long as you don't apply a filter to the main form the database will work fine even with conditional formatting in
the sub-form. I have had almost exactly the same problem, only in my case
Access 2002 would not shut down until I attempted to scroll after filtering. You are lucky, because your post contains the cause of this problem and
because mine didn't start until I switched to 2002 it took me longer to
track down.

--
Jeffrey R. Bailey
"Richard" <rw**********@c hello.se> wrote in message
news:G3sub.3792 $%W3.19990@amst wist00...
Hi,

I have a form that take some time to load due to many comboboxes and at
least 8 subforms.
When I filter or sort the main form I get an error message and then Access shuts down. They ask if I want to send the error report to Microsoft. Has anybody seen this type of error message and what can I do to prevent it

from
happening. Am I doing something illegal in my code? It used to work but I have added conditional formatting to a subform but that shouldn't cause

any
problem. It ONLY happens when I try to filter or sort the main recordset
using Access built-in functions. I am using Access 2002.
Any help appreciated
Richard


Nov 12 '05 #3
I have 2 controls with conditional formatting. One based on 3 conditions and
the other one on 1 condition. I deleted all figuring I can do this in code.
But the problem persists. Not only when I try to filter but also when I try
to sort the recordset on any control. I have about 1000 records in the
recordset.

Richard
"Jeffrey R. Bailey" <mr**********@y ahoo.com> skrev i meddelandet
news:s2******** *******@twister .tampabay.rr.co m...
Incidentally what you are doing isn't illegal and the solution I described
above is only a work around. When I had the problem I searched the news
groups and knowledge bases and never found mention of anyone else having it. I have always assumed it to be an issue related to running multiple
development environments on my main machine. I worked around conditional
formatting by adding some check boxes to reflect the state of the records in a different way. I couldn't do without filtering the main form in my
application.

--
Jeffrey R. Bailey
"Jeffrey R. Bailey" <mr**********@y ahoo.com> wrote in message
news:AP******** *******@twister .tampabay.rr.co m...
Conditional formatting in a sub-form and filtering the main form caused this
problem for me, remove the formating and then see if the problem doesn't

go
away. Incidentally, I'll bet that as long as you don't apply a filter to

the
main form the database will work fine even with conditional formatting in
the sub-form. I have had almost exactly the same problem, only in my case Access 2002 would not shut down until I attempted to scroll after

filtering.
You are lucky, because your post contains the cause of this problem and
because mine didn't start until I switched to 2002 it took me longer to
track down.

--
Jeffrey R. Bailey
"Richard" <rw**********@c hello.se> wrote in message
news:G3sub.3792 $%W3.19990@amst wist00...
Hi,

I have a form that take some time to load due to many comboboxes and at least 8 subforms.
When I filter or sort the main form I get an error message and then Access shuts down. They ask if I want to send the error report to Microsoft. Has anybody seen this type of error message and what can I do to prevent it from
happening. Am I doing something illegal in my code? It used to work
but I have added conditional formatting to a subform but that shouldn't
cause any
problem. It ONLY happens when I try to filter or sort the main

recordset using Access built-in functions. I am using Access 2002.
Any help appreciated
Richard



Nov 12 '05 #4
I was afraid that we were chasing similar symptoms but not the same problem.
Though I discovered how to work around the problem I have the work around
did not lead to any understanding.

To troubleshoot I tried compacting and compiling the database and that
didn't work. I then began removing items (i.e. code(in small blocks, and
only code triggered during startup, or on current), controls, the sub-form,
re-writing queries, etc) from the form until it started to function
normally. Eventually this led to my focusing on the sub-form with
conditional formatting. I discovered that if I removed the sub-form the
main form was Ok. Then it was a matter of isolating the problem on the
sub-form. In order to do this, I re-created the sub-form from scratch, but
without the conditional formatting and that turned out to be the trigger for
my problem. This always struck me as odd, because I was doing no development
on the sub-form. Hopefully, similar steps will eventually lead to your
isolating this problem.

When I describe it like above it seems like a several minute troubleshoot,
but it wasn't. My problem only manifested itself intermittently, and I
could get around it by restoring from an old copy (when I am programming I
make a full back up every hour of my work). I had the luxury of being able
to look at this problem off and on for a month (it only happened on my
machine). I have checked my incident database and the fix that worked for me
was applied on 10-23-03 and since the change the problem has not reappeared.

Sorry I could not offer more help.

--
Jeffrey R. Bailey
"Richard" <rw**********@c hello.se> wrote in message
news:g2Gub.3871 $%W3.20170@amst wist00...
I have 2 controls with conditional formatting. One based on 3 conditions and the other one on 1 condition. I deleted all figuring I can do this in code. But the problem persists. Not only when I try to filter but also when I try to sort the recordset on any control. I have about 1000 records in the
recordset.

Richard
"Jeffrey R. Bailey" <mr**********@y ahoo.com> skrev i meddelandet
news:s2******** *******@twister .tampabay.rr.co m...
Incidentally what you are doing isn't illegal and the solution I described
above is only a work around. When I had the problem I searched the news
groups and knowledge bases and never found mention of anyone else having it.
I have always assumed it to be an issue related to running multiple
development environments on my main machine. I worked around conditional formatting by adding some check boxes to reflect the state of the records in
a different way. I couldn't do without filtering the main form in my
application.

--
Jeffrey R. Bailey
"Jeffrey R. Bailey" <mr**********@y ahoo.com> wrote in message
news:AP******** *******@twister .tampabay.rr.co m...
Conditional formatting in a sub-form and filtering the main form caused this
problem for me, remove the formating and then see if the problem
doesn't go
away. Incidentally, I'll bet that as long as you don't apply a filter
to the
main form the database will work fine even with conditional formatting in the sub-form. I have had almost exactly the same problem, only in my case Access 2002 would not shut down until I attempted to scroll after

filtering.
You are lucky, because your post contains the cause of this problem
and because mine didn't start until I switched to 2002 it took me longer to track down.

--
Jeffrey R. Bailey
"Richard" <rw**********@c hello.se> wrote in message
news:G3sub.3792 $%W3.19990@amst wist00...
> Hi,
>
> I have a form that take some time to load due to many comboboxes and

at > least 8 subforms.
> When I filter or sort the main form I get an error message and then

Access
> shuts down. They ask if I want to send the error report to
Microsoft. Has
> anybody seen this type of error message and what can I do to prevent

it from
> happening. Am I doing something illegal in my code? It used to work but
I
> have added conditional formatting to a subform but that shouldn't

cause any
> problem. It ONLY happens when I try to filter or sort the main recordset > using Access built-in functions. I am using Access 2002.
>
>
> Any help appreciated
>
>
> Richard
>
>
>



Nov 12 '05 #5
The troubleshoot process is the last solution, it's just that I rather not
go into that type of tedious work if I can avoid it. I guess I have to
anyway.

Thanks for all your help,

Richard
"Jeffrey R. Bailey" <mr**********@y ahoo.com> skrev i meddelandet
news:sD******** *********@twist er.tampabay.rr. com...
I was afraid that we were chasing similar symptoms but not the same problem. Though I discovered how to work around the problem I have the work around
did not lead to any understanding.

To troubleshoot I tried compacting and compiling the database and that
didn't work. I then began removing items (i.e. code(in small blocks, and
only code triggered during startup, or on current), controls, the sub-form, re-writing queries, etc) from the form until it started to function
normally. Eventually this led to my focusing on the sub-form with
conditional formatting. I discovered that if I removed the sub-form the
main form was Ok. Then it was a matter of isolating the problem on the
sub-form. In order to do this, I re-created the sub-form from scratch, but without the conditional formatting and that turned out to be the trigger for my problem. This always struck me as odd, because I was doing no development on the sub-form. Hopefully, similar steps will eventually lead to your
isolating this problem.

When I describe it like above it seems like a several minute troubleshoot,
but it wasn't. My problem only manifested itself intermittently, and I
could get around it by restoring from an old copy (when I am programming I
make a full back up every hour of my work). I had the luxury of being able to look at this problem off and on for a month (it only happened on my
machine). I have checked my incident database and the fix that worked for me was applied on 10-23-03 and since the change the problem has not reappeared.
Sorry I could not offer more help.

--
Jeffrey R. Bailey
"Richard" <rw**********@c hello.se> wrote in message
news:g2Gub.3871 $%W3.20170@amst wist00...
I have 2 controls with conditional formatting. One based on 3 conditions and
the other one on 1 condition. I deleted all figuring I can do this in

code.
But the problem persists. Not only when I try to filter but also when I

try
to sort the recordset on any control. I have about 1000 records in the
recordset.

Richard
"Jeffrey R. Bailey" <mr**********@y ahoo.com> skrev i meddelandet
news:s2******** *******@twister .tampabay.rr.co m...
Incidentally what you are doing isn't illegal and the solution I described above is only a work around. When I had the problem I searched the news groups and knowledge bases and never found mention of anyone else having
it.
I have always assumed it to be an issue related to running multiple
development environments on my main machine. I worked around conditional formatting by adding some check boxes to reflect the state of the records
in
a different way. I couldn't do without filtering the main form in my
application.

--
Jeffrey R. Bailey
"Jeffrey R. Bailey" <mr**********@y ahoo.com> wrote in message
news:AP******** *******@twister .tampabay.rr.co m...
> Conditional formatting in a sub-form and filtering the main form caused this
> problem for me, remove the formating and then see if the problem doesn't go
> away. Incidentally, I'll bet that as long as you don't apply a
filter to the
> main form the database will work fine even with conditional
formatting in
> the sub-form. I have had almost exactly the same problem, only in
my case
> Access 2002 would not shut down until I attempted to scroll after
filtering.
> You are lucky, because your post contains the cause of this problem and > because mine didn't start until I switched to 2002 it took me longer to > track down.
>
> --
> Jeffrey R. Bailey
> "Richard" <rw**********@c hello.se> wrote in message
> news:G3sub.3792 $%W3.19990@amst wist00...
> > Hi,
> >
> > I have a form that take some time to load due to many comboboxes
and at
> > least 8 subforms.
> > When I filter or sort the main form I get an error message and
then Access
> > shuts down. They ask if I want to send the error report to

Microsoft. Has
> > anybody seen this type of error message and what can I do to

prevent it
> from
> > happening. Am I doing something illegal in my code? It used to
work but
I
> > have added conditional formatting to a subform but that shouldn't

cause
> any
> > problem. It ONLY happens when I try to filter or sort the main

recordset
> > using Access built-in functions. I am using Access 2002.
> >
> >
> > Any help appreciated
> >
> >
> > Richard
> >
> >
> >
>
>
>



Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2590
by: Gordon Sanderson | last post by:
I have been working with for two days on a database with no problems(changing forms and adding code to the forms and a module). Shut down last night was fine, with no errors generated. This morning, I opened the database and I started getting the dialog "MSACCESS.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created." with an OK button. Access shuts down. If I...
22
3805
by: TC | last post by:
I have an Access database application with a lot of custom row functions written in VBA. In other words, a lot of queries contain calculated fields which use functions defined in the modules. I am now thinking about upgrading the database from Access to SQL Server. If I do, how can I implement the custom row functions? Is Visual Basic integrated with SQL Server just as it is with Access? Or does T-SQL in SQL Server offer the...
2
3771
by: Nick | last post by:
What I want to do is have 2 pull down lists, for example a state pull down list and a city pull down list. What I would like to have done is when you select a state from the state pull down list then the city pull down list will populate with all the cities from that selected state. I know that is a lot of data but that is just an example. Or something like when you are looking up cars online they have a make pull down list and a model...
3
3236
by: rdemyan via AccessMonster.com | last post by:
I have a forced logoff routine in place that works well unless an Access messagebox is showing in the front-end that the routine is trying to shut down. It doesn't work use Access commands to shut down the application. Is there a way to use a Windows API to shutdown the application? I'm hoping that, like the task manager, a Windows API shutdown would work even if a modal form is displayed in the application it is trying to shutdown. ...
6
3067
by: Chris Zoper | last post by:
Hello, I have a form that shows a lot of records based on a passthrough query to a SQL Server database. I noticed that the Filter and the Sort property of the form do not properly work, often the filter and sorting are not performed. When I base the form on a query on an Access-table everything works just fine, but when I use the passthrough query nothing happens. Does anyone know how to solve this problem?
2
2559
by: rdemyan via AccessMonster.com | last post by:
I have a custom message form that I want to display when the user shuts down my app. Some clean up needs to be done during shutdown and I want to display this form and then display various messages in the label on the form as the shutdown cleanup proceeds. I have a hidden Startup form. So in the Startup form OnClose event, I am loading the message form and then changing the label caption as the code proceeds to do the cleanup of...
4
1887
by: Frank | last post by:
My program gets a WM_QUERYENDSESSION message and asks the user if it is OK to shutdown. While he's thinking about it, Windows displays a box saying the program is not responding, and if not answered shuts down my program. I need to delay that while until the user answers my program's dialog box. How does Windows check to see if an app is responding.
0
3126
by: Yarik | last post by:
Hello, Here is a sample (and very simple) code that binds an Access 2003 form to a fabricated ADO recordset: ' Create recordset... Dim rs As ADODB.Recordset: Set rs = New ADODB.Recordset ' Append one or more fields... Call rs.Fields.Append("Number", adInteger)
9
1548
by: Bob Alston | last post by:
I have an application with about 30 users, most of whom use the application on laptops that they take with them. The system is split into FE and BE. The BE on each laptop is a replica. The system automatically syncs with the server at their office location each time they start up the application and they are connected to the LAN and again when they shut down. I have experienced occasional database corruption. Having difficulty...
0
8649
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9221
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8975
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7822
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6567
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5904
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4661
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2398
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2035
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.