473,703 Members | 3,017 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

access won't close after conditional formatting

Hello all!

For quite some time now, I've got the following problem:

Access won't close properly when a user closes the application. An
ACCESS process stays active and that process can only be terminated by
pressing [CTRL]+[ALT]+[DEL] and then terminate the process.

I searched the entire internet and found out that there could be two
things wrong (both of them are mentioned in the bug list on the access
web: http://www.mvps.org/access/bugs/bugs0005.htm):

1. DAO recordsets are not closed (or set to nothing properly).
2. You cannot reference a boolean control in the following way:
[if me.Parent!chkSo meCheckBox then], this should be
[If me.Parent!chkSo meCheckBox = True then]

Both of these problems are NOT my problem!!!

I found out (after days of ^@#$ debugging) that a field (in a
Datasheet form) which has conditional formatting causes the problem.
If I delete the conditional formatting everything goes OK!

To be exact, the following is happening:
There is a table, tblCourse:
- pkCourse_id (primary key)
- txtCourseName (text)
- dtDate (date)
- ynFull (boolean)

There is a datasheet (sub)form which is based upon this Course table
and holds two text fields:
1. Course name, bound to txtCourseName
2. A field that has it's control source set to the following:
=getCourseStatu sString([pkCourse_id];[dtDate];[ynFull])

This function (getCourseStatu sString(arg1 as Integer, arg2 as Date,
arg3 as boolean)) returns one of the following strings, based upon the
properties of the Course.
- Ended (when the field dtDate is <= Date()).
- Full (When the ynFull field is TRUE, no more people can visit this
course)
- Partly (there are people who are visiting this crouse, but there is
still place for more people)
- None (Nobody goes to this course).

As mentioned before, this field had conditional formatting. (Applied
by doing Format->Conditional formatting). It has the following three
formatting conditions:

1. Field value is --- equal to --- "None" --> background is Red
2. Field value is --- equal to --- "Full" --> background is Green
3. Field value is --- equal to --- "Partly" --> background is Orange

I no conditions are met, the background will remain white.
Alle works just fine! BUT, if you close access, a process stays open
and can only be closed by using the Task Manager.

If you get rid of the conditional formatting everything works fine!

So, I am looking for answers here! I work with ACC2000, WIN2000,
latest servicepacks for both Win and Acc.
Any help would be appreciated, thanks in advance.

Jouke
Nov 12 '05 #1
3 5929
Hello, Jouke,

I had exactly the same problem recently. Was going to post about it, but
that was when the MSBlast virus was going around so I deferred doing so, and
then forgot about it.

I had conditional formatting in a (continuous form) subform that greyed the
background of any row not matching the date in the parent form. I used
identical conditional formatting statements for all the controls. Made it
easy for user to see all records, which they need, yet easily distinguish
the records before and after the date in question.

The weird thing was, I only had the problem when I applied the formatting to
one particular column (control) that was in the middle of the subform. I
did everything including a) renaming the control, b) renaming the field, c)
recreating the control from a duplicate of another control that worked, d)
recreating the control from scratch, and e) recreating the form and subform.
Nothing worked.

So I compromised. Instead of greying out the entire row, I just greyed out
the first 5 columns. The users are happy and I regained my sanity.

Regards,
Krisa


"Jouke Langhout" <jl*@cypres.n l> wrote in message
news:db******** *************** ***@posting.goo gle.com...
Hello all!

For quite some time now, I've got the following problem:

Access won't close properly when a user closes the application. An
ACCESS process stays active and that process can only be terminated by
pressing [CTRL]+[ALT]+[DEL] and then terminate the process.

I searched the entire internet and found out that there could be two
things wrong (both of them are mentioned in the bug list on the access
web: http://www.mvps.org/access/bugs/bugs0005.htm):

1. DAO recordsets are not closed (or set to nothing properly).
2. You cannot reference a boolean control in the following way:
[if me.Parent!chkSo meCheckBox then], this should be
[If me.Parent!chkSo meCheckBox = True then]

Both of these problems are NOT my problem!!!

I found out (after days of ^@#$ debugging) that a field (in a
Datasheet form) which has conditional formatting causes the problem.
If I delete the conditional formatting everything goes OK!

To be exact, the following is happening:
There is a table, tblCourse:
- pkCourse_id (primary key)
- txtCourseName (text)
- dtDate (date)
- ynFull (boolean)

There is a datasheet (sub)form which is based upon this Course table
and holds two text fields:
1. Course name, bound to txtCourseName
2. A field that has it's control source set to the following:
=getCourseStatu sString([pkCourse_id];[dtDate];[ynFull])

This function (getCourseStatu sString(arg1 as Integer, arg2 as Date,
arg3 as boolean)) returns one of the following strings, based upon the
properties of the Course.
- Ended (when the field dtDate is <= Date()).
- Full (When the ynFull field is TRUE, no more people can visit this
course)
- Partly (there are people who are visiting this crouse, but there is
still place for more people)
- None (Nobody goes to this course).

As mentioned before, this field had conditional formatting. (Applied
by doing Format->Conditional formatting). It has the following three
formatting conditions:

1. Field value is --- equal to --- "None" --> background is Red
2. Field value is --- equal to --- "Full" --> background is Green
3. Field value is --- equal to --- "Partly" --> background is Orange

I no conditions are met, the background will remain white.
Alle works just fine! BUT, if you close access, a process stays open
and can only be closed by using the Task Manager.

If you get rid of the conditional formatting everything works fine!

So, I am looking for answers here! I work with ACC2000, WIN2000,
latest servicepacks for both Win and Acc.
Any help would be appreciated, thanks in advance.

Jouke

Nov 12 '05 #2
Hello Krisa,

First of all, thanks for your quick answer.
If I read your post correctly, you solved your problem by formatting
multiple columns instead of one (a column somewhere in the middle).

My formatted column is the most left column in a Datasheet (sub)form,
so I could try to format the other columns as well, in the hope that
the problem will be solved by doing so.
I think the position of the column in the form doesn't have anything
to do with the problem, because a column somwhere in the middle of
your form is giving you a hard time and a most left column in my form
is making me crazy. I can give it a try ofcourse.

The thing I forgot to mention is that the problem ONLY occurs in a
runtime environment. The problem is that all the users HAVE a Access
runtime environment, so I HAVE to solve this problem AND FAST!!

Thanks again for your answer, and I will try your solution to solve
this irritating problem.

Jouke.
Nov 12 '05 #3
Hello Jouke,

Sorry I wasn't clearer. No, I did not try formatting multiple columns
instead of one. I started out with all the columns formatted, and then
discovered, by removing the formatting from the columns one by one, that it
was a particular column that was causing the problem. It did not matter
where the column was.

So, instead of formatting all the columns, I simply formatted the ones to
the left of the problem one. While not as ideal as having all the columns
formatted, the users say they can still easily distinguish "target" from
"non-target" records.

I hope this makes it clearer for you.

Regards,
Krisa

"Jouke Langhout" <jl*@cypres.n l> wrote in message
news:db******** *************** ***@posting.goo gle.com...
Hello Krisa,

First of all, thanks for your quick answer.
If I read your post correctly, you solved your problem by formatting
multiple columns instead of one (a column somewhere in the middle).

My formatted column is the most left column in a Datasheet (sub)form,
so I could try to format the other columns as well, in the hope that
the problem will be solved by doing so.
I think the position of the column in the form doesn't have anything
to do with the problem, because a column somwhere in the middle of
your form is giving you a hard time and a most left column in my form
is making me crazy. I can give it a try ofcourse.

The thing I forgot to mention is that the problem ONLY occurs in a
runtime environment. The problem is that all the users HAVE a Access
runtime environment, so I HAVE to solve this problem AND FAST!!

Thanks again for your answer, and I will try your solution to solve
this irritating problem.

Jouke.

Nov 12 '05 #4

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

Similar topics

5
3084
by: Richard | last post by:
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...
4
6876
by: brAccess | last post by:
I recently installed Access 2003 and immediately noticed problems with applications that work fine in 2000 and XP. I use conditional formatting on continuous forms for a number of reasons. When these forms are opened in 2003, Access seems to go into a continuous loop. Has anyone else experienced this problem? Does anyone know of a solution short of not using conditional formatting in continuous forms? Here is an example:
4
2137
by: Wayne Aprato | last post by:
I have a simple database which was originally written in Access 97. When converted to Access 2000 file format it ran flawlessly in Access 2002. I've just tried to run it in Access 2003 and I am seeing the following behaviour: Some of the fields on the continuous main form which is a list of jobs with their related details "flicker". While this is going on the form seems to function as it should and isn't locked up. If I click and hold...
0
689
by: M. Farrenkopf | last post by:
I am in the process of converting a Jet database to ADP using SQL Server 2000. Most of this conversation has been smooth, but now I'm running across a problem that has me stumped. Access 2000 SP3 on Windows 2000 Professional. I'm not in charge of the SQL server, so I don't know its OS (presumably irrelevant). Presumably, it's been updated with its latest service packs. With this conversion, I'm moving everything on the VB side from...
4
3132
by: Bradley | last post by:
I have an A2000 database in which I have a continuous form with a tick box. There is also a text box with a conditional format that is based on the expression , if it's true then change the background colour. In A2000 it works great, but in A2003 the background doesn't always change and when it does it only changes when the record looses the focus. Any way around this? Is it a bug? Or have they "improved" it?
5
8963
by: Andrew Chanter | last post by:
Does anyone know a way you can use conditional formatting to create a banded style view as is commonly seen on the internet. (In othe words the first record appears on a gray background, the 2nd on white, the third on gray etc etc.) I could write an expression based on the odd/even status of the primary key but this wont work when sorting and filtering is applied. Any suggestions gratefully received.
1
4231
by: dddsssdddsss | last post by:
A comment and a question To anyone who is using conditional formatting, beware that in Access 2007 the color pallette is not the same as the color pallette in Access 2003. So if you have a particular color you were using as a standard throughout your application, the only way to continue using that color is to code the color. Anyone else notice how forms in Access 2007 display the conditional formatting much slower than in Access...
3
10490
by: smuir | last post by:
I am working with a basic access form for a payroll system and need to modify it such that if an employee worked overtime, then their overtime payrate and hours show up on the report below their regular payrate and hours. Ex: 40.00 hours @ $77.00/hr 5.00 hours @ $102.00/hr If an employee's overtime hours = 0, then the overtime payrate and hours fields should not be visible on the report. Ex: 40.00 hours @ $77.00/hr
6
3648
by: GAC | last post by:
I've used conditional formatting on ACCESS reports but have come up with a problem using it for a FIELD that has a value of either YES or blank/null. The default formatting (used when condition(s) are not met) is always used EVEN WHEN I specify Condition 1 to change the formatting when the field is YES. What am I missing....doesn't conditional formatting work on fields defined as TEXT with values of YES or Blank(Null)?
0
8744
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8659
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
9240
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
8996
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
8952
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7846
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
6585
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...
2
2426
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2055
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.