Export resulting in Blank Spreadsheet

[Hamm]

Hi guys, hopefully you can help me.

I am trying to export a form from Access 2007 to Excel (or word) and all i get is a blank spreadsheet (or document). When I export to pdf it works fine.

Is this a setting I have checked somewhere that I cant find?



Thanks

[rpeare]

a PDF is basically a picture, word and excel typically are not.

Are you trying to export the DATA or what your screen looks like? if it's the DATA you can do that by setting up a query (the same query that runs your form) and export that. If you're attempting to basically create a screen print of your access database you'd likely have to take it into something like PAINT first to edit the picture then cut and paste that image into your final document (I don't do much image wrangling in access, it's a bad tool for the job).

[Hamm]

I am trying to export the data. I have just tried the query method and that works but i want to export only the columns showing in my form. do i have to set up a specific query for that?

[rpeare]

yes, the export will send any fields that exist in your query to the spreadsheet, so you have to omit any fields you don't want showing from your export query.

[Hamm]

Thanks rpeare. that covers it