Search results

I know I am picking up on an old topic, but I am experiencing some issues where the above solution should've fixed the problem for me, but it is not. So I am hoping that you could perhaps help me further. I am using Access 2003 (on work computer) on Windows XP. When I use the following...

Thanks for the clarification. I wasn't aware that the feature for converting report to Excel is not available in 2007. It is surprising that they would remove such a basic feature instead of adding new ones. So is there no other alternative methods to convert a REPORT to Excel or is it just...

Yes, I tried that already, but I get the following error message. In the action failed msg window, the error number displayed is 2950. When I click on the debug button, it will take me that particular line. I am using Access 2007 on Vista.

Thanks for the reply. But I need to send a report to Excel2007 or Excel 2003 format. DoCmd.OutputTo acOutputReport, "rptNewEmailList", acFormatXLS, Filename, -1 The above command that was working in Access 2003 would actually write the report out to an Excel file and opens the file...

Thanks... I will do that. menawhile, if anybody who is an expert on 2007 see this, please respond.

Yes, the script I have is precisely doing that and it works fine in Access 2003. But when I use that script in Access 2007, I get an error. And that is the real issue here. How do you export data through a quesry in Access 2007. In Access 2003, this line works, but not in Access 2007...

I have a small piece of code that is supposed to write out a REPORT in to an Excel file in Excel format and open the document in Excel. It works fine in witht he command that is now commented out. But with a similar command for Access 2007 does not perform the smae thing. The code that I am...

I have a small piece of code that is supposed to write out a REPORT in to an Excel file in Excel format and open the document in Excel. It works fine in witht he command that is now commented out. But with a similar command for Access 2007 does not perform the smae thing. The code that I am...