Jacqui (and others),
I had the same problem and concluded that you can't use a recordset as the record source for a report. The temp table works and it was not too messy. My queries were extremely complicated, combining the user input off three lists (time period, company subsidiary and...
Hymn, thanks for the DAO clarification. I have the MS web site white paper on the differences. Maybe I can work backwards. Seems bizarre that a simple concept is so complicated. The VBA for Dummies and Access Bible both recommended ADO so that I tried to stay with it. It wasn't until I saw...
I'm struggling with the same issue. The criteria will not pass to the report. I have Access 2000 but not QueryDef so may be that a library is off. I've read every FAQ I can find but none offer a solution. I can't use a Query because my selection criteria are complicated. The input comes...
We have experienced the same problem. We lose the last few words, and sometimes as much as a line or two, from the end of memo fields. I think the problem is in the conversion from Access to RTF/Word doc. I have been unable to figure out what the pattern is. I agree that it is not...
We struggle with the same issue. RTF leaves several things to be desired in Word. For example, each line is a paragraph and usually starts with several blanks or a short-length tab. Also, the vertical spacing (before and after) is quirky and tries to emulate the happenstance of where the line...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.