access export to excel with a check box

[rust]

I need to export the results of an ACCESS query to an EXCEL spreadsheet.
Right Now I'm saving the results of the query to a temporary table and using

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tTempTest", "C:\Test.xls", True

Works OK accept there is an ACCESS YES/NO Field that the user wants the EXCEL work sheet to have a check box for that Field not a text box with True/False.

Actually I will only be sending False.

How do I do that?

 

[SkipVought]

Rust,

I do not like PUSHING data. Id rather PULL data into Excel either on demand, or on the Workbook Open event.





Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[rust]

Well thanks for the thought,
but the deal is the ACCESS Application is outputting an EXCEL file which will be emailed to users.
They will change specific Falses (or No's) to True (or Yes) and then email it back.

At this point I do not want to restrict my situation to a check box - I will accept any suggestion for something the user can do (select from list) that all they do is select true for the items that they will not consider false.

Some how typing in True is too difficult for some people
(OK there may be a lot).

 

[PHV]

Take a look here: thread707-801028

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[rust]

Thanks - just for the others that might have stumbled on this - though it may be interesting how to get access to put controls on excel. For the time being I figured I will tell the client a drop down validation box is just as good and simple to do - see PHV's link - at a less rushed time maybe we should explore it.