Export main form and sub form together to excel sheet

[jamz]

Hi guys,

I'm new here. I've been searching since last month which is related to my question but unluckily no one can answer my question until I bumped into this forum and register immediately.

I hope someone can help me, please.. I'm not really familiar with MS Access but my boss asked me to export the main form (header) and sub form (details of header). This is my sample access:

Header:
No.: 123-0910 *Find button* Remarks: None
Desc.: Colored Accopas Status : OK
Rev.: 02

Details
Size Location Quantity
8mm R1 9
9mm R5 65
8cm Y7 87

I added find button because I have 500 No. so i can find "No." easily, and export to excel one by one.
I want also to export those form exactly with the same format in MS Access (in form format)



thank you so much.

If you know thread the same with mine, kindly reply with the link. Thank you again!

[June7]

If you want to export data into Excel so users can manipulate it, better export query. Even report/subreport can be a messy export. Can't imagine a form/subform export will be satisfactory.

[John_G]

I want also to export those form exactly with the same format in MS Access (in form format)

You can't export a form/subform to Excel and include the labels and layout. All you can do is export the data the form and subform are using.

More importantly, you cannot export the form/subform and have them look the same and have the same functionality in Excel as they do in Access.

[jamz]

Thank you all the replies! I get it, there's no way to export exactly the format of access to excel. another question, even I use Macro or vba?

[June7]

Well, yes code can export data, just won't have appearance of form or report.

Did you experiment with export of form or report to understand why doesn't work well?

[jamz]

I've tried, but the result is just exported the fields were distributed per column, and format is not the same with what I wanted. If I can't do that, I have plan B with my access. I hope you can still help me. So here it goes,. Instead of exporting, I want to print out the form (main form(header) and sub form(details of header) with footer (signatories only in 2nd page)). header should be fixed in 1st page while footer will show only in 2nd page but everytime I print it out, the 2nd page of details is not printing. It supposed to have a 2nd page because of course some data have more than 100 records. What would be the problem of my access? your help will be highly appreciated..thank you

[June7]

Forms are intended for screen display and reports for printing. Using one to do the other function will not produce wholly satisfactory results. I have printed only a very simple form for single record and even that was tricky because forms don't have page setup settings available to reports.

Recommend you build a report for printing.

[jamz]

thanks for that @June7, I do understand now the difference between the two. But I have question, let's say I create a report for printing, how can I easily find the particular record of what I want to make a print out. Can I create a search or button from my report? so if I want to print one record only, it won't be hard to find a record..Sorry if i'm poor in explanation but if you can't understand what I'm saying, i can elaborate more. But thank you for your replies and help

[June7]

Review http://allenbrowne.com/ser-62.html

[jamz]

Ok thank you for the link @june7, I will check and update you..