Recent content by LARiot

So how do I learn SSRS? -Nima "Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) -- Ockham's Razor

Shaunacol: Are you sure the default printer is properly selected? Is there a check mark next to it? Because when I change my default printer in Devices and Printers to xps writer it prints to that. -Nima "Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited...

This report: With this code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) End Sub Creates this error: If I blank out the code. It runs without crashing. It looks like I'm grouping it wrong. But I don't know where. -Thanks -Nima "Pluralitas non est ponenda...

So I've had this relationship with MS-Access for over a decade. It was causal at first, I'd see her a few days here and there on certain projects. Later on it became more serious as I stopped seeing other platforms and developed in Access exclusively... However the relationship has lost it's...

Maj: I'd already thought of that. No go, another M$ bug. Had to code it to change text field in table. Thanks for lookin' into it. -Nima "Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) --...

Same problem. I'm guessing it has something to do with a page break somewhere. Just can't figure it out. -Nima "Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) -- Ockham's Razor

Duane: before I forget, thanks for looking into this. -Nima "Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) -- Ockham's Razor

Ther are two images fields per record. How do you add details footer? There's a page footer and there's a report footer, how ever a details footer eludes me. Also, what do you mean specifically by render? -Nima "Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be...

Wouldn't work because sometimes there are multiple records on one page. That was the whole point of suppressing the blank space for records/rows with no image. -Nima "Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It...

Imagepath is a field/column in my table. Since the form's record source is pointing to that table, I can use it in my code. -Nima "Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) -- Ockham's Razor

Yeah, but you can't do that below the detail section where would go. They're at the bottom of the detail section right now. -Nima "Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) -- Ockham's Razor

Hi. Any help is appreciated. I'm trying to print a report with some records having images and others not. When no image, there should be no space between records. That is, shrink the detail when no image. I have the following code: Private Sub Detail_Format(Cancel As Integer, FormatCount...

BTW, thanks again for all the help, especially MajP. The result of this that the database went from 53MB (with only test data) down to 2.4 MB. Without this modification it would've hit the 2GB limit in no time. -Nima "Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be...

The picture property wouldn't work because the source control property overrides it. So I just changed the field. Here's the code if anyone else needs it: Private Sub imgHouse_DblClick(Cancel As Integer) Dim varFile As Variant varFile = OpenFile("Please select Image file for this...

I just did an update using DoCmd.RunSQL and it's working fine now. Apparently the control source (which can't be updated through code) supersedes the Picture property. Further proof that Microsoft uses voodoo and witchcraft in applications. -Nima "Pluralitas non est ponenda sine necessitate"...