Search results

Chergh, my auditor know his query language, but asks me to make it more readable. In other words, he wants to read the query in seperate lines, not as one line. At work we have a loansystem where we can make sql queries graphically. Upon clicking a button it shows the sql, not as one line, but...

Wayne, could you get me started with your answer? Could you help me out writing a routine? In my database i have reports that make use of MSysObjects, but is more to show what queries i have and what tables i use, not the sql itself. Thanks for helping me out.

Ted, I am sorry, but this is not what I mean. I know the code is there, but my external auditor wants to write a report for an audit on access. If I copy the code I must manually copy it into word and after every comma he wants a new line, so I must give an enter after every comma. That's it...

I want to know if the following is possible: suppose if made a query. When i turn to sql view it says (simplified): select name, address, phone from tbladdresses, tbllookup where bla, bla, bla Now i want to copy it into unbound txtbox1 and push a button. The second txtbox should look like...

Tried this on the dutch forum but nobody could help me. I have about 40 reports which I want to be printed and exported to rtf in a directory I choose. I have an unbound field in which the directory name is listed (here I want to output all the results). I have the following macro code (as an...