Form Filter Problem

  • Thread starter Thread starter Michael Kintner
  • Start date Start date
M

Michael Kintner

How can I take a filtered form, selected all the records from that filtered
form and paste into excel via pressing a Visual Basic button. I've tried a
couple of things and not working correctly.

Can anybody help?

Thank you,
Mike
 
Figured it out, for those of you that could not reply!. (smile)

DoCmd.RunCommand acCmdSelectAllRecords
DoCmd.RunCommand acCmdCopy

Set oApp = CreateObject("Excel.Application")
oApp.Visible = True
oApp.Workbooks.Add
oApp.ActiveSheet.Paste
 

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

Excel Export Filtered Form Data To Excel 0
QAT & Filter By Form 1
Access Access 2010: Activating controls in a form after filter by form 0
Macro to copy value in field and insert it into filter 2
filter on a form only works once 5
How to apply the form filter on the report? 3
Filtered Access Form to Export 1
Form filters 2

Back
Top