RE: Problem with checkboxes after Service Pack 3

[Gardner]

I fogot to mention, that I am running Access 2003 The application does not
work as and ADP or an ADE file. I execute routines in the MouseHook.dll at
startup. Removing the routines seems to have no effect.

Thanks.

~Gardner

"Gardner" wrote:

> I am current experiencing problems with the checkboxes on my forms. If
> unchecked, clicking will set the checkbox. If already checked, clicking will
> have no effect. Setting a checkbox that is already checked to false still
> shows true (via vba).
>
> The forms are bound to a SQL Server back end database. Almost all of the
> checkboxes have no code attached to them. The remaining checkboxes just tab
> to another field after update. I have decompiled and recompiled.
>
> Tabbing to the checkbox and hitting the spacebar works but not clicking with
> the mouse. The problems began after Office Service Pack 3 was installed. I
> have many versions of the database that were created before the Service Pack
> and none of them have working checkboxes now (they worked before the Service
> Pack).
>
> An additional problem occurred with a listbox that had 13 columns. The form
> would not display, I could not compile. I could not save until I reduced the
> number of columns and save the database.
>
> Any help on the checkboxes would be greatly appreciated.
>
> ~Gardner

[Gardner]

[Ken Snell (MVP)]

It's a bug that has been introduced by 2003 SP3. MS is aware of it.

--

Ken Snell
<MS ACCESS MVP>

"Gardner" <Gar...@discussions.microsoft.com> wrote in message
news:706C96E0-81F6-468E...@microsoft.com...

[Gardner]

Thanks Ken.

Are they also aware of the problem with the listbox as well?

~Gardner

[Ken Snell (MVP)]

Yes.
--

Ken Snell
<MS ACCESS MVP>

"Gardner" <Gar...@discussions.microsoft.com> wrote in message

news:793C01A2-3A24-427C...@microsoft.com...

[Bradley]

On Sep 28, 9:10 pm, "Ken Snell \(MVP\)"

<kthsneisll...@ncoomcastt.renaetl> wrote:
> It's a bug that has been introduced by 2003 SP3. MS is aware of it.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>

> "Gardner" <Gard...@discussions.microsoft.com> wrote in message

Ken,

Can you provide a link to a knowledge base article or a bug database
where this bug is documented by Microsoft? Does Microsoft have a plan
to release a patch to fix this, or is there a workaround available
(other than using the space bar)?

Thanks,
Bradley

[Ken Snell (MVP)]

No link to a KB article has been released yet. I'm told that MS is very
close to publishing a KB article and "fix" for this issue.
--

Ken Snell
<MS ACCESS MVP>

"Bradley" <Bradle...@gmail.com> wrote in message
news:1191276125.0...@22g2000hsm.googlegroups.com...

> On Sep 28, 9:10 pm, "Ken Snell \(MVP\)"
> <kthsneisll...@ncoomcastt.renaetl> wrote:
>> It's a bug that has been introduced by 2003 SP3. MS is aware of it.
>

[A. van Huizen]

Ken, is this the same problem that I see now only 0 and -1 in my
listbox/comboboxes?
The ony strange thing is that I saw this before in SP2, I did something in
the table design and the problem was solved, but now I really don't know
anymore what I did, because nothing helps.

When this is the same bug then I'm 'happy'

Thanks in advance.
Arjan

"Ken Snell (MVP)" <kthsne...@ncoomcastt.renaetl> wrote in message
news:OrwflsI...@TK2MSFTNGP04.phx.gbl...

[Ken Snell (MVP)]

The bug noted by the other poster is related to using SQL Server as the
backend for the database. I'm not aware that this bug is manifested in the
displays in comboboxes or listboxes. 0 is the actual value of False (or No
or Off) in ACCESS; -1 is the actual value of True (or Yes or On).

You can change the Format property of the combobox to Yes/No, True/False, or
On/Off so that it will show the name instead of the value. This may trigger
a separate bug, related to the use of a Format property for a field that is
in a RowSource query of a combobox or listbox, that SP3 introduced, though.
This separate bug causes a blank display for the combobox or listbox. MS
also is working on that bug.

--

Ken Snell
<MS ACCESS MVP>

"A. van Huizen" <av...@raketnet.nl> wrote in message
news:HxrNi.4161$Hv4.1208@amstwist00...

[A. van Huizen]

Thanks for your fast reply.

Normally I saw in the listbox 'Yes' and 'No', now I see -1 and 0. I didn't
change something and this db works already since 1 year for a client. And I
see it in every front-end on existing databases since this week. So I think
that it is related to SP3 too.

The format of the Yes/No field in the table is set to Yes/No or True/False.
When I change this, it still doesn't matter.
Also when I make the prefered format in the table design empty.

When I make a simple new database with one table, one field and I display
this in a listbox on a form I see only 0 and -1.

It looks like a bug, because I'm not aware that I can change this format
somewhere besides in the table design.

I hope that you can reproduce the same as I see.
Thanks in advance.
Arjan.

"Ken Snell (MVP)" <kthsne...@ncoomcastt.renaetl> wrote in message

news:%23ePRzt1...@TK2MSFTNGP02.phx.gbl...

[Kaytrim...@gmail.com]

Has there been a fix yet for this issue? This service pack was
installed last night via SMS and we can't do our data entry now.

Michael

On Oct 1, 7:28 pm, "Ken Snell \(MVP\)"

<kthsneisll...@ncoomcastt.renaetl> wrote:
> No link to a KB article has been released yet. I'm told that MS is very
> close to publishing a KB article and "fix" for this issue.
> --
>
> Ken Snell
> <MS ACCESS MVP>
>

> "Bradley" <Bradley.H...@gmail.com> wrote in message

[Ken Snell (MVP)]

No link to a KB article has been released yet. I'm told that MS is very
close to publishing a KB article and "fix" for this issue.
--

Ken Snell
<MS ACCESS MVP>

<Kaytrim...@gmail.com> wrote in message
news:1192125799.8...@50g2000hsm.googlegroups.com...

[David]

Hi Ken,
Any idea yet when the fix will be available? We either have to roll back to
SP2 (not easy) or sit on piles of reports awaiting data entry (not
productive). Any suggestions on how to let MS know this is a huge problem for
us? Your help is greatly appreciated.
David

[Ken Snell (MVP)]

I wish I had some news for you, but nothing has been announced by MS yet. I
would have thought it would have occurred by now, so something else must be
holding up the process. I'll ping MS and see.
--

Ken Snell
<MS ACCESS MVP>

"David" <Da...@discussions.microsoft.com> wrote in message
news:CB0F92AE-50CB-424D...@microsoft.com...

[Dave]

Hi Ken,

Any updates? I'm having the same issues as are the rest in this post. My
user's patience levels are reaching critical mass. Hoping there is some news.

Thanks,

Dave

[Ken Snell (MVP)]

My last communication with MS is that the publication of information is in
the "queue of work", but no date for release has been set.

--

Ken Snell
<MS ACCESS MVP>

"Dave" <Da...@discussions.microsoft.com> wrote in message
news:A38AEF29-0548-4A09...@microsoft.com...

[Ken Snell (MVP)]

"Combo box controls and list box controls display no value or
incorrect values in Access 2003 after you install Office 2003 Service
Pack 3." And a few more problems SP3 introduced.

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007 - 945674

http://support.microsoft.com/kb/945674
--

Ken Snell
<MS ACCESS MVP>

"Ken Snell (MVP)" <kthsne...@ncoomcastt.renaetl> wrote in message

news:%23rM1tZw...@TK2MSFTNGP06.phx.gbl...

[Kaytrim...@gmail.com]

Thanks for the update Ken.

Michael

On Dec 27 2007, 7:27 pm, "Ken Snell \(MVP\)"

<kthsneisll...@ncoomcastt.renaetl> wrote:
> "Combo box controls and list box controls display no value or
> incorrect values in Access 2003 after you install Office 2003 Service
> Pack 3." And a few more problems SP3 introduced.
>
> Description of the Access 2003 post-Service Pack 3 hotfix package:
> December 18, 2007 - 945674
>
> http://support.microsoft.com/kb/945674
> --
>
> Ken Snell
> <MS ACCESS MVP>
>

> "Ken Snell (MVP)" <kthsneisll...@ncoomcastt.renaetl> wrote in messagenews:%23rM1tZw...@TK2MSFTNGP06.phx.gbl...

>
> > My last communication with MS is that the publication of information is in
> > the "queue of work", but no date for release has been set.
>
> > --
>
> > Ken Snell
> > <MS ACCESS MVP>
>

> > "Dave" <D...@discussions.microsoft.com> wrote in message