Exporting Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form created w/ over 280 records. I want to export a single record
into Excel exactly how I have the layout in my form. How do I do that?
Suggestions would be greatly appreciated.
 
Lisha

Forms, in Access, are screen displays of data. Excel stores data in cells.
I don't see how these are compatible.

If you'd like to send the data that's displayed in your form/screen, you
could do that by exporting the query that your form uses -- this would
export all data your form would display. You might need to limit it to the
specific record your form is displaying. You can do this in a query by
using the parameter/Criteria.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting to PDF 2
Export to excel doesn't take over calculations 3
Export the Form content to Excel 2
Access Automatically Send a notification email once a record is added 0
Access Access variable string for export 0
Separate Form 0
Filter Query - export spreadshet 1
Special view of form for users 1

Back
Top