Exporting form to excel

**jeskit** · 03-09-2012, 12:04 PM

Hi,

I am trying to export a form into excel using the line of code below however it keeps saying it cannot find the form "Test" which is open.

Please Login or Register  to view this content.

Does anyone know why it says it cannot find the form?

Thank you in advance

Jeskit

**alansidman** · 03-09-2012, 01:20 PM

Are you trying to take a form design from Access and put it into Excel?

If you did this, what would be the purpose?

**jeskit** · 03-12-2012, 11:42 AM

Hi, On the form I am trying to export there are two textboxes with data and its the data I am trying to export

**alansidman** · 03-12-2012, 03:22 PM

Why not create a query with the criteria for what is in the form and then export that? Queries are designed by MS to be exported.

**jeskit** · 03-14-2012, 05:47 AM

Hi

Ok I tired creating a query using the value in the textbox and it seems to work.

Thanks for the idea and your help.

Re: Exporting form to excel