this is very strange
in [Help]
|
From: Filips Benoit on 23 Dec 2009 03:52 Have SP3 but not recently installed ! I'll check the link for that bug. F "fredg" <fgutkind(a)example.invalid> wrote in message news:1m3k7egcp23sj.1webcoof9o54r$.dlg(a)40tude.net... > On Tue, 22 Dec 2009 19:09:01 +0100, Filips Benoit wrote: > >> Dear All, >> >> I copyed 3 access2003 databases to my laptop, all 3 having 1 form that's >> exactly the same. >> In that form 1 combobox ( the same in all 3 databases) doesn't show the >> values. Nothing just a blank list ! >> It only occures on my laptop, never seen it on another computer ! >> >> Combo's Name = AnalyseMonsterLocatieID >> Combo's ControlSource = AnalyseMonsterLocatieID >> Combo's RowSource = a select sql-statement 5 fields ( >> 0cm;5cm;0cm;0cm;0cm) >> from 1 table >> >> I saved the select sql-statement as a query and then used the query but >> had >> the same problem a blank list. >> Opening the query shows 452 records ! >> >> If I make a new combo based on that query I have the same problem ! >> >> Strage but true I can pick 1 row in that blank list and the after >> update-code runs normaly !! >> >> What could be wrong here ??? >> >> Filip > > Have you recently installed Access 2003 Service Pack 3 on the laptop? > Could be the Service Pack 3 bug. > See this link for details on the hotfix. > > http://support.microsoft.com/kb/945674 > -- > Fred > Please respond only to this newsgroup. > I do not reply to personal e-mail
From: Filips Benoit on 23 Dec 2009 03:54 No, it was my first check ! "Phil" <phil(a)stantonfamily.co.uk> wrote in message news:hJKdnWf9zILI16zWnZ2dnUVZ8rmdnZ2d(a)brightview.co.uk... > On 22/12/2009 19:00:46, fredg wrote: >> On Tue, 22 Dec 2009 19:09:01 +0100, Filips Benoit wrote: >> >>> Dear All, >>> >>> I copyed 3 access2003 databases to my laptop, all 3 having 1 form that's >>> exactly the same. >>> In that form 1 combobox ( the same in all 3 databases) doesn't show the >>> values. Nothing just a blank list ! >>> It only occures on my laptop, never seen it on another computer ! >>> >>> Combo's Name = AnalyseMonsterLocatieID >>> Combo's ControlSource = AnalyseMonsterLocatieID >>> Combo's RowSource = a select sql-statement 5 fields ( >>> 0cm;5cm;0cm;0cm;0cm) >>> from 1 table >>> >>> I saved the select sql-statement as a query and then used the query but >>> had >>> the same problem a blank list. >>> Opening the query shows 452 records ! >>> >>> If I make a new combo based on that query I have the same problem ! >>> >>> Strage but true I can pick 1 row in that blank list and the after >>> update-code runs normaly !! >>> >>> What could be wrong here ??? >>> >>> Filip >> >> Have you recently installed Access 2003 Service Pack 3 on the laptop? >> Could be the Service Pack 3 bug. >> See this link for details on the hotfix. >> >> http://support.microsoft.com/kb/945674 > > Its a daft thought, I have done it once myself. > You havn't set a white font on a white background or something similar? > > Phil
From: Filips Benoit on 23 Dec 2009 04:08
IT WAS the Service Pack 3 bug. That field had '>' in as format in the fieldproperties, removing it solved the problem !! THANKS� "fredg" <fgutkind(a)example.invalid> wrote in message news:1m3k7egcp23sj.1webcoof9o54r$.dlg(a)40tude.net... > On Tue, 22 Dec 2009 19:09:01 +0100, Filips Benoit wrote: > >> Dear All, >> >> I copyed 3 access2003 databases to my laptop, all 3 having 1 form that's >> exactly the same. >> In that form 1 combobox ( the same in all 3 databases) doesn't show the >> values. Nothing just a blank list ! >> It only occures on my laptop, never seen it on another computer ! >> >> Combo's Name = AnalyseMonsterLocatieID >> Combo's ControlSource = AnalyseMonsterLocatieID >> Combo's RowSource = a select sql-statement 5 fields ( >> 0cm;5cm;0cm;0cm;0cm) >> from 1 table >> >> I saved the select sql-statement as a query and then used the query but >> had >> the same problem a blank list. >> Opening the query shows 452 records ! >> >> If I make a new combo based on that query I have the same problem ! >> >> Strage but true I can pick 1 row in that blank list and the after >> update-code runs normaly !! >> >> What could be wrong here ??? >> >> Filip > > Have you recently installed Access 2003 Service Pack 3 on the laptop? > Could be the Service Pack 3 bug. > See this link for details on the hotfix. > > http://support.microsoft.com/kb/945674 > -- > Fred > Please respond only to this newsgroup. > I do not reply to personal e-mail |