dbDisplayLookupList problem

[Bob Hansen]

Hi there,

I've got a little problem with the ConnStr parameter for the dbDisplayLookupList property.

Situation:

I have 2 database; one with employee data, one with order details.
in the orderdetail I have a table: Orders, where the EmployeeId (employee-number) must be filled in.

What I like to do is use the DisplayLookUpList show the full name instead of the Number.

I know this should be possible with the ConnStr parameter, but I can't find any syntax(not in manual of FAQ) how this string is build. (tried DSN=..).

Any help would be appreciated.

Kind regards,

Bob Hansen

[Frank]

Bob,
Your problem is most likely in the delimiters... checkout -

http://www.kingkwong.com/htmldoc/dbDisplayLookupList.shtm

it uses mdb as connstr, but dsn is the same.


Frank


------------
Bob Hansen at 11/6/99 9:12:24 AM

Hi there,

I've got a little problem with the ConnStr parameter for the dbDisplayLookupList property.

Situation:

I have 2 database; one with employee data, one with order details.
in the orderdetail I have a table: Orders, where the EmployeeId (employee-number) must be filled in.

What I like to do is use the DisplayLookUpList show the full name instead of the Number.

I know this should be possible with the ConnStr parameter, but I can't find any syntax(not in manual of FAQ) how this string is build. (tried DSN=..).

Any help would be appreciated.

Kind regards,

Bob Hansen

[Bob Hansen]

Hi Frank,

Checked my delimeters, but they where the same as on the page you reffered.

I use the following code:

Mydb.dbDisplayLookUpList="(;|)WerkNemerId|dsn= persoon|SELECT PersoonId, Voornaam & ' ' & Achternaam As Naam FROM Personen"

I get the following Error message:

------------------------------
ADODB.Recordset fout '800a0e78'

De door de toepassing gevraagde bewerking is niet toegestaan als het object gesloten is.
------------------------------

The error is in Dutch, but it says that the action is not allowed because the object is closed.
I even tried to change the DSN to a MDB but the same error message showed.

I'm using Access2000 so MDB wouldn't work in the first place.
(b.t.w. will there be an update for access2000?)

If I use the dblookuplist property from any table in the current connection the output is o.k.

Kind regards,

Bob Hansen

------------
Frank at 11/6/99 11:31:11 AM

Bob,
Your problem is most likely in the delimiters... checkout -

http://www.kingkwong.com/htmldoc/dbDisplayLookupList.shtm

it uses mdb as connstr, but dsn is the same.


Frank


------------

Hi Frank,

Found the problem.

I Miss-spelled the Fieldname in the second database, no ASPDB problem, DSN=xxx works o.k.

Thanx for your quick response the other day.

Keep up the good work

Kind regards,

Bob Hansen


------------
Bob Hansen at 11/8/99 2:06:57 AM

Hi Frank,

Checked my delimeters, but they where the same as on the page you reffered.

I use the following code:

Mydb.dbDisplayLookUpList="(;|)WerkNemerId|dsn= persoon|SELECT PersoonId, Voornaam & ' ' & Achternaam As Naam FROM Personen"

I get the following Error message:

------------------------------
ADODB.Recordset fout '800a0e78'

De door de toepassing gevraagde bewerking is niet toegestaan als het object gesloten is.
------------------------------

The error is in Dutch, but it says that the action is not allowed because the object is closed.
I even tried to change the DSN to a MDB but the same error message showed.

I'm using Access2000 so MDB wouldn't work in the first place.
(b.t.w. will there be an update for access2000?)

If I use the dblookuplist property from any table in the current connection the output is o.k.

Kind regards,

Bob Hansen

------------
Frank at 11/6/99 11:31:11 AM

Bob,
Your problem is most likely in the delimiters... checkout -

http://www.kingkwong.com/htmldoc/dbDisplayLookupList.shtm

it uses mdb as connstr, but dsn is the same.


Frank


------------

[Frank]

No problem, that is the most common problem... FAT fingers... happen to the best. Keep it going !!!

FK



------------
at 11/8/99 8:25:15 AM

Hi Frank,

Found the problem.

I Miss-spelled the Fieldname in the second database, no ASPDB problem, DSN=xxx works o.k.

Thanx for your quick response the other day.

Keep up the good work

Kind regards,

Bob Hansen


------------
Bob Hansen at 11/8/99 2:06:57 AM

Hi Frank,

Checked my delimeters, but they where the same as on the page you reffered.

I use the following code:

Mydb.dbDisplayLookUpList="(;|)WerkNemerId|dsn= persoon|SELECT PersoonId, Voornaam & ' ' & Achternaam As Naam FROM Personen"

I get the following Error message:

------------------------------
ADODB.Recordset fout '800a0e78'

De door de toepassing gevraagde bewerking is niet toegestaan als het object gesloten is.
------------------------------

The error is in Dutch, but it says that the action is not allowed because the object is closed.
I even tried to change the DSN to a MDB but the same error message showed.

I'm using Access2000 so MDB wouldn't work in the first place.
(b.t.w. will there be an update for access2000?)

If I use the dblookuplist property from any table in the current connection the output is o.k.

Kind regards,

Bob Hansen

------------
Frank at 11/6/99 11:31:11 AM

Bob,
Your problem is most likely in the delimiters... checkout -

http://www.kingkwong.com/htmldoc/dbDisplayLookupList.shtm

it uses mdb as connstr, but dsn is the same.


Frank


------------