I have successfully added "all" to a combo box using a union query with access 2000 i.e SELECT "*" FROM EMPLOYEES UNION (SELECT [LASTNAME] FROM EMPLOYEES
;
Then I can select from a query using the Like "*" operator. This all works fine within access but when I try to do the same on a linked notes database I get the following error
ODBC--call failed.
[Lotus][ODBC Lotus Notes]Data type mismatch of corresponding columns in UNION operation.
Does anyone know a way around this - I am using rowsource Table/query to generate the results.
I have several combo boxes an need to be able to drill down depending on the results of the provious combo box results.
I really need to be able to select all!!!
Any help would be greatly appreciated as my head is on the block with this one.
;Then I can select from a query using the Like "*" operator. This all works fine within access but when I try to do the same on a linked notes database I get the following error
ODBC--call failed.
[Lotus][ODBC Lotus Notes]Data type mismatch of corresponding columns in UNION operation.
Does anyone know a way around this - I am using rowsource Table/query to generate the results.
I have several combo boxes an need to be able to drill down depending on the results of the provious combo box results.
I really need to be able to select all!!!
Any help would be greatly appreciated as my head is on the block with this one.
