Macro for user defined report, filtering issue within Macro

**Mlanger575** · 03-16-2016, 09:46 AM

Hello

I'm having trouble with a macro.

Basically I have a large database with a lot of invoices, I've designed an enquiry where the user defines one of the filters required so the macro can copy & paste from the protected database to a user report.

I'm really struggling with how to get the users entry (collected via an InputBox) and shoehorn this into the filter.

Any help would be gratefully received

Thanks
Michael

**Bernie Deitrick** · 03-16-2016, 12:39 PM

To apply a filter with a user-input value, the code can be as simple as

Please Login or Register  to view this content.

But you may want to find out what unique values are actually available, given the other filtering that has been used.

**Mlanger575** · 06-15-2016, 06:24 AM

Thanks - works like magic

Macro for user defined report, filtering issue within Macro

LinkBack

Thread Tools

Rate This Thread

Display

Macro for user defined report, filtering issue within Macro

Re: Macro for user defined report, filtering issue within Macro

Re: Macro for user defined report, filtering issue within Macro

Thread Information

Users Browsing this Thread

Similar Threads

Macro problem - loops theough user defined functions not called in macro

[SOLVED] User-defined type not defined on Copy to Clipboard Macro

user defined macro to replace certain characters in a string based on user input

[SOLVED] Macro filtering issue

Filtering > macro issue

Macro with user defined inputs

How to: User Form to assign a user defined range to a macro variab

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions