MS Data Project Issue - Check Boxes on Form

[JCCDevel]

Hello All,

I'm having an issue with a form. This issue has just started happening
to the user and I cannot recreate the problem in my test environment.
We have a form that pops up if you make a selection from another
form. The pop-up form contains 6 checkboxes. You are supposed to
select one and click on the save button. The selection then gets
posted to the database via a view. What has started happening is that
when the user clicks one box - they all populate with checkmarks.
Then he is only able to "uncheck" them one at a time, click save and
then come back into the box. I have checked the properties of all the
check boxes and none of them have any sort of "On Click" event
attributed to them. I cannot figure out what would cause this event
to occur. We are using Access 2003.

I truly appreciate any help! Happy Friday!

JCC

 

[Steven Wilmot]

attributed to them. I cannot figure out what would cause this event
to occur. We are using Access 2003.

I truly appreciate any help! Happy Friday!

JCC

Have you by any chance just installed Office 2003 SP3.

This seems to be a common problem.

The only option I know of so far is to uninstall Office 2003, then re-update
to SP2.

If you come across a permanent fi 'd be grateful if you could let me know.

Steven

Data Utilities Ltd

 

[JCCDevel]

Have you by any chance just installed Office 2003 SP3.

This seems to be a common problem.

The only option I know of so far is to uninstall Office 2003, then re-update
to SP2.

If you come across a permanent fi 'd be grateful if you could let me know.

Steven

Data Utilities Ltd

Steve,

Thanks for the advice. I just checked his machine and verified that
he is running SP2. Guess I have to keep digging!

JCC

 

[Sylvain Lafontaine]

The first thing to try would be to decompile the ADP file directly on the
user's machine before using it.

As a second suggestion, there have been many reports of problems with either
bit fields and/or the use of RecordsetClone instead of Recordset.Clone these
last years; so if you are using bit fields you could try to replace them
with tinyint or smallint and if you are making calls to RecordsetClone you
should look for this possibility in your test environment.

Personally, I would take a look at the use of RecordsetClone before taking a
look at bit fields.