How to export all data to excel?

[s128]

Hi everyone,



I've created 3 forms with lots of tables (3 forms are linked together).
Are there any ways to export all these forms and tables to Excel with everything still available??
(all data, VB, query, searching)

Any help would be appreciated.

Thank you in advance.

[June7]

No, can't export form objects to Excel and have them work as forms. Data is exported.

[s128]

June7, thank you for your reply.

so, only data could be exported. is it possible to create new form in excel?
can that new form work the same function as the form in access?

[alansidman]

CrossPosted: http://www.excelforum.com/access-tab...-to-excel.html

[June7]

I have never built forms in Excel. I don't know how they would work to save data to sheets, probably some complicated code. Why do you want this?

[alansidman]

Here is the simplest way to enter data in a form for building a table in Excel.
http://www.youtube.com/watch?v=Xq3RIjsIAos
If you want a more robust form, you will have to use VBA. Here is a basic tutorial on how to do that

http://www.techrepublic.com/blog/mso...heck-boxes/203