Query Recordset sent to Excel

[gr]

Hi all,

I am sending a recordset to Excel. The recordset is from a
query output.
It works fine except that I have some fiels which are
items
choosen from comboboxes. So when the recordset is sent to
Excel, instead of displaying the values from the query, it
is displaying numbers. I think this has to do with the
Bound Columns or something of the combo box properties..

how to make excel display the "real" values?

Ex.
My query in access
Smith Sales Doc1 Finished GMD
Ravanni PIBDE Doc2 In progress SER
Ramon Sales Doc3 Finished SER

The same data in Excel
1 1 Doc1 1 1
2 2 Doc2 2 2
3 1 Doc3 1 2

Thx,
gr

 

[Arvin Meyer]

Include the table which has the lookup data in the query which builds the
recordset. If you are using tables with lookup fields, you have hit upon one
of the reasons that this is bad design practice:

http://www.mvps.org/access/lookupfields.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[gr]

Thank you, I read the article... but then what is a good
practice design instead of using lookup fields?? other
alternative offering the same result without all these
disadvantages?

 

[Arvin Meyer]

Thank you, I read the article... but then what is a good
practice design instead of using lookup fields?? other
alternative offering the same result without all these
disadvantages?

Create a query. Base your recordset on the query:

Select * From qryWhatever

With a query, you can add as many tables as necessary to get the values you
want.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access