ms access 2000

After generating a report from a form using:
  DoCmd.OpenReport stDocName, acPreview
 I am being asked to send this report to excel. The problem is that in the report footer I have a signature ( i.e. Dept Signature: ______    Date: __________ ).  This is not showing when the report is exported to excel.
ShenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
can you try using this

docmd.ouputto acoutReport,stDocname,acFormatXls, "c:\myreport.xls"


post back for result
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ShenAuthor Commented:
the report also has in the page footer:

  DeptSign: _______________  Date: _____________

Is this posible to export?
0
Jeffrey CoachmanMIS LiasonCommented:
Most "Export to Excel" functionality will basically only export the "Data"

What cap posted does a better job of bringing in some "formatting"...

It is not clear what objects you are using to create your Page and Report Footers, ...
But if you just have Labels and lines floating around, these may not be exported.

These Export functions will never be perfect.
Access reports and Excel spreadsheets are two different types of Objects.

Another alternative is to export the Access data to an Excel "Template" that contains your Footer info...

I am sure cap can help you with that...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

ShenAuthor Commented:
how would you assign a template to a report generated with:
     docmd.ouputto acoutReport,stDocname,acFormatXls, "c:\myreport.xls"

I create a .xlt report but when i run docmd it does not reflect the .xlt changes

0
Jeffrey CoachmanMIS LiasonCommented:
Again, I just made the suggestion...

Capricorn1 is pretty good at working with exporting Access data to Excel templates...

I'm sure he'll be back soon...
0
Rey Obrero (Capricorn1)Commented:
upload a copy of the excel file generated by this code

docmd.ouputto acoutReport,stDocname,acFormatXls, "c:\myreport.xls"

where do you get values for footer content

DeptSign: _______________  Date: _____________

0
ShenAuthor Commented:
They are not really fields. They are just two labels fields and two lines.

 
                    DeptSign: _______________  Date: _____________

0
ShenAuthor Commented:
if i undesrtood the question, the values in the page footer of the report don't export to the excel file.
0
Rey Obrero (Capricorn1)Commented:
can you understand this

<
upload a copy of the excel file generated by this code
docmd.ouputto acoutReport,stDocname,acFormatXls, "c:\myreport.xls"
>
0
ShenAuthor Commented:
0
Rey Obrero (Capricorn1)Commented:

in the excel file created, where do you want to place

    DeptSign: _______________  Date: _____________

0
ShenAuthor Commented:
in the botton of the page
0
ShenAuthor Commented:
is there any solution to this request?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.