Hi Skip,
Thanks. The issue is with the output from Access. There are 3 columns which require input from the users. All three use the Lists / Combo box function. Unfortunately when the excel file is generated, the 3 columns are blank and dont show the lists of values for selection.
HI Alex, Thanks for your response.IS there any standard function that can help me. I dont know much programming and wanted to use Access to clean data and provide excel sheets for the folks to udpate.
Hi,
I have a query which pulls key fields from a Table and exports to an excel file through the Output to cmmd.
In the table, i have defined a few fields with Look-up criteria and Combo / LIsts. When the Excel sheet is created the Lists are not downloaded. The purpose is to scrub the data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.