Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LARiot

    Breaking up with Access

    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
  2. LARiot

    Problems printing a report

    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...
  3. LARiot

    No space on no image

    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...
  4. LARiot

    Breaking up with Access

    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...
  5. LARiot

    image's control source

    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) --...
  6. LARiot

    No space on no image

    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
  7. LARiot

    No space on no image

    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
  8. LARiot

    No space on no image

    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...
  9. LARiot

    No space on no image

    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...
  10. LARiot

    Attachment data type makes table too big

    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
  11. LARiot

    No space on no image

    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
  12. LARiot

    No space on no image

    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...
  13. LARiot

    Attachment data type makes table too big

    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...
  14. LARiot

    Attachment data type makes table too big

    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...
  15. LARiot

    Changing field value after form record source change

    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"...
  16. LARiot

    Changing field value after form record source change

    That's actually where the whole problem started. I can't change the image's control source through VBA. -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
  17. LARiot

    Changing field value after form record source change

    Hi. Thanks for looking into this. Any help is appreciated. I have a form and every time the user clicks on a new tab, the record source of the table changes. However, in the VBA I cannot reference the field. It only shows the fields from the original record source. When I type it in anyway...
  18. LARiot

    Attachment data type makes table too big

    BTW, I don't see a bound image control. There's an image control and bound object frame. I using the image control. -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
  19. LARiot

    image's control source

    A record has four images associated with it. Four option buttons on top of the image in the form. When you select one button it should change the source control for that image to point to the corresponding field/column. -Nima "Pluralitas non est ponenda sine necessitate", i.e., "Plurality is...
  20. LARiot

    image's control source

    Says member or property not found. -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

Part and Inventory Search

Back
Top