Results 1 to 3 of 3
  1. #1
    accessmatt is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    199

    Adding a filter through an input box to ExportWithFormatting

    Hello,

    Is there a way to add an input box to filter my ExportWithFormatting http://msdn.microsoft.com/en-us/libr...ffice.15).aspx ?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Can use an input box to populate a variable in VBA. I am not seeing Input Box available with macro.

    What info do you want the input box to collect that would be used in the export operation?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    accessmatt is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    199
    Thanks June. I want to use the input box like a parameter for my query...i.e. records matching this condition. I actually figured out that it's easy enough to must modify my query and then hook up ExportWithFormatting on that new query.


    Quote Originally Posted by June7 View Post
    Can use an input box to populate a variable in VBA. I am not seeing Input Box available with macro.

    What info do you want the input box to collect that would be used in the export operation?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Adding Filter Using Macro
    By TxTcher in forum Forms
    Replies: 1
    Last Post: 02-05-2013, 02:16 AM
  2. ExportWithFormatting Error
    By voro in forum Import/Export Data
    Replies: 3
    Last Post: 10-29-2012, 09:29 AM
  3. Filter table in form by user input
    By swavemeisterg in forum Forms
    Replies: 1
    Last Post: 06-11-2012, 02:54 PM
  4. MS Access Date filter basedon User Input
    By shanmugamgsn in forum Access
    Replies: 1
    Last Post: 12-12-2011, 04:15 PM
  5. Replies: 32
    Last Post: 06-20-2011, 07:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums