472,779 Members | 1,993 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

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!chkSomeCheckBox then], this should be
[If me.Parent!chkSomeCheckBox = 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:
=getCourseStatusString([pkCourse_id];[dtDate];[ynFull])

This function (getCourseStatusString(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 5832
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.nl> wrote in message
news:db**************************@posting.google.c om...
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!chkSomeCheckBox then], this should be
[If me.Parent!chkSomeCheckBox = 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:
=getCourseStatusString([pkCourse_id];[dtDate];[ynFull])

This function (getCourseStatusString(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.nl> wrote in message
news:db**************************@posting.google.c om...
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
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...
4
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...
4
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...
0
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...
4
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...
5
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...
1
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...
3
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...
6
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)...
0
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

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.