this is very strange

#1

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

#2

"Filips Benoit" <benoit.filips (AT) telenet (DOT) be> wrote

Quote:

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

Do you have something in ControlSource and RowSource? Because I don't

believe you can have both.

#3

On Tue, 22 Dec 2009 19:09:01 +0100, Filips Benoit wrote:

Quote:

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

#4

On 22/12/2009 19:00:46, fredg wrote:

Quote:

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

#5

Why not, but still when i make a new UNBOUND combo having the same RowSourse
and showing alle columns ( 5cm;5cm;5cm;5cm;5cm)
I can see the values in columns (0,2,3,4) not in column 1 the only one that
was visible in the original combo !!!

"paii, Ron" <none (AT) no (DOT) com> wrote

Quote:

"Filips Benoit" <benoit.filips (AT) telenet (DOT) be> wrote in message
news:B_7Ym.104140$II.47133 (AT) newsfe22 (DOT) ams2...
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

Do you have something in ControlSource and RowSource? Because I don't
believe you can have both.

#6

Have SP3 but not recently installed !
I'll check the link for that bug.

F

"fredg" <fgutkind (AT) example (DOT) invalid> wrote

Quote:

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

#7

No, it was my first check !

"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote

Quote:

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

#8

IT WAS the Service Pack 3 bug.
That field had '>' in as format in the fieldproperties, removing it solved
the problem !!

THANKS³

"fredg" <fgutkind (AT) example (DOT) invalid> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

this is very strange

comp.databases.ms-access comp.databases.ms-access

this is very strange - 12-22-2009 , 12:09 PM

Re: this is very strange - 12-22-2009 , 12:44 PM

Re: this is very strange - 12-22-2009 , 01:00 PM

Re: this is very strange - 12-22-2009 , 04:38 PM

Re: this is very strange - 12-23-2009 , 02:49 AM

Re: this is very strange - 12-23-2009 , 02:52 AM

Re: this is very strange - 12-23-2009 , 02:54 AM

Re: this is very strange - 12-23-2009 , 03:08 AM