Create a report "on the fly"

K

Kostas

Hi
I want to create an SQL string accourding to the user's choices in a form
(e.t. check boxes) and then use this SQL string to create a report.Is this
possible?If yes, How can I do this? What about DoCmd.OpenReport?

Thanks Kostas
 
Y

Yanick

See articles #146310 and 147143 in Microsoft knowledge base. I have done it
and it give you 100% report flexibility.
 

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

VBA - exporting serial letters to single documents 0
Word macro that can call cells out of Excel for a find and replace 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Request Form - Alert Team Member 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Syntax for assigning the querystring as the recordsource of the re 7
How to automate update on weekly reports spreadsheet 0
Program buttons to create a word document 0

Top