Recent content by SHK

Hi. I use transferspreadsheet to export the result of a query to an excel file. When I open the excel file, I receive the following error message: "File Error: Some Number Formats may have been lost." Does anyonce have any idea what has caused the excel error? Thanks in advance. Thanks Siew

Can Shrink does not work. I am going to look for the vb code to stop the printing of second page. At least now I know it is doable. Thanks for the suggestions.

You can create a form that contains a customer name dropdown. That way you won't need to worry about typo. Then, set the parameter on the query to forms!formname![Customer Name]. Hope this helps. SHK

Hi Mark, thanks for the reply. It is a crosstab report. There are unbound textboxes on the first page and the second page. Depending on the number of columns returned from the query, the script will hide the extra textboxes from the screen. So, the unbound textboxes on the second page will...

Hi! I have created a crosstab report that contains two pages. The second page may be blank depending on the number of records. I am wondering if there is a way to hide the second page of the report when it is blank. Or, Is there a way I can set the printer to print only the first page when the...