Recent content by KDAnalyst

Thank you David. Where would this be done (within the properties of the query, the subreport, the main report...on a particular event)? Sorry for my ignorance :) Also, I'm not sure what this means (would like to understand what exactly this will do)? Is this similar to an IIF statement...

Hmmm....tried that and it still displays both. I wonder if I set the IsNull criteria to a particular control on the linked subreport rather than the entire subreport? What do you think (I'll give it a try)? Or, do you see anything wrong with the code (just tweaked it again, and it now hides...

Thanks for teaching me the simple way of doing this! You seem to be the "Access guru" on this site, so maybe you would have an answer for me on a similar challenge I'm having. Basically, I have two subreports within a main report. The linked one displays however number of related records are...

You could also try to achieve this in a query using an IIF statement, then criteria for the findings (assuming the data source for your report is a query). So, for example, create a calculated field within the query, based on [winnings]: IIF([winnings]<30,000,"Hide","Visible"). In the...

Hi there. I'm wondering if anyone out there has any experience with automating the printing of hyperlinked documents contained within an Access 2000 report (thinking this could be done on the "OnPrint" event on the detail section within the main report)? Basically, within a subreport of the...

In Access 2000, I have got a report that contains hyperlinks, referenced as "supporting documents". When the report itself prints, I would like to have the hyperlinked documents print at the same time (automatically). Is this possible? If so, how (examples would be ideal)? Thanks in advance.

I'm working with a front-end (.mde) and back-end (.mdb) Access 2000 database (group-level security using individual logons and passwords), and have some users complaining that they're certain they've entered records, but when they close and return to the database, the records do not exist. I...

Thanks for the assistance. I was able to figure it out yesterday (hadn't received any replies), but I think your suggestions would've worked better. I ended up creating 2 sub-reports as my solution (side-by-side). Next time I roll out an update, I'll revert to suggestion #2 (likely better...

I have a report with essentially 4 columns of different text fields (not a columnar report). As an example, the design looks like this... [Field1] [Field2] [Field3] [Field4] [Field5] [Field6] What I'd like to do is ensure that fields 5 and 6 don't move down based on the content of field 4...