On 19 dec, 13:55, Rick Brandt <rickbran...[ at ]hotmail.com> wrote:
[Quoted Text] > On Fri, 19 Dec 2008 04:49:34 -0800, Doekoe wrote:
> > We use MS Access for our Account Managers, we work with a front.mdb and
> > a back.mdb. At some point in time (say two weeks ago) a listbox shows
> > all records however one column (field) is not filled. The source for
> > this listbox is a query. When I run the query, it shows all records and
> > all data in all columns.
>
> > The same for a dropdown box, this will show all records but this
> > specific column shows no data although there is data.
>
> > I deleted all records from the table and entered a new record. All
> > fields are filled in the table and also in the query, however opening
> > the listbox shows all fields except the one. There is some strange
> > connection between the controls (listbox and dropdownbox) and this field
> > in the query or table. However I can not figured it out.
>
> > Hope someone recognize the problem and can give some help.
>
> > Thanks in advance,
>
> > Dirk
>
> Are you using Access 2003 and did you recently apply Service Pack 3? If
> so, this is a bug caused by that service pack and there is a hotfix that
> you must now install.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -
Hi Rick,
Thanks for you reply, works fine.
Dirk
|