Results 1 to 14 of 14
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Onekama, Michigan, USA
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Display image at current record (A97)

    Would like to display an image at the current record of my continuous form subform. On the Form Load event is the following:
    Forms!frmArchive!sfrmArchiveRecords![Image1].Visible = False.
    In the On Current event of the subform is: Me![Image1].Visible = True. When initially opening the form there are no images displayed. When moving to another record, all records display an image. Is what I am trying to achieve possible?

    Thanks
    Ron

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Display image at current record (A97)

    Do you have a specific reason for setting the Visible property to False in the On Load event? What happens if you omit that line from the On Load event?

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Onekama, Michigan, USA
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Display image at current record (A97)

    If I remove the that line from the On Load event, when the form opens, all records have the image. The purpose of the image (a small arrow) is to act as a record selector or marker for the current record.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Display image at current record (A97)

    In a continuous form, a control is either visible in ALL records or invisible in ALL records. It is not possible to make it visible in just a single record. So you'll have to think of something else - why not use the built-in record selector? It displays a triangle in the active record.

  5. #5
    Star Lounger
    Join Date
    Apr 2002
    Location
    Onekama, Michigan, USA
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Display image at current record (A97)

    The built in record selectors will work just fine. Is there a way to prevent the user from doing a Ctrl A and then pressing the Delete key? That was what I was trying to avoid.

    Thanks,
    Ron

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Display image at current record (A97)

    You'd have to create an event handler for the Before Delete Confirm or On Delete events, I think.

  7. #7
    Star Lounger
    Join Date
    Apr 2002
    Location
    Onekama, Michigan, USA
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Display image at current record (A97)

    I will look into that. Thank you.

    Ron

  8. #8
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Display image at current record (A97)

    The attached demo shows how you can achieve the goal of your original post, but not by using an image. Instead there is a text box with conditional formatting which makes it appear whenever it is the current record.
    I use something like this when I want something more obvious than the built-in record selectors.
    Attached Files Attached Files
    Regards
    John



  9. #9
    Star Lounger
    Join Date
    Apr 2002
    Location
    Onekama, Michigan, USA
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Display image at current record (A97)

    Thank you for the information. That is what I was looking for. What keyboard combination creates the pointer figure? The other issue I my have is incorporating it into Access 97 because that version does not have conditional formatting.

    Thank you
    Ron

  10. #10
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Display image at current record (A97)

    Sorry I did not notice that you were using 97. You are right that this will not work there, as conditional formatting is not available.
    There was something similar, but even more convoluted, that worked in 97, but I would need to hunt it up. From memory, all it would do would be give a rectangular block of color.

    To get the arrow, I inserted it into Word using Insert Symbol, then copied into Access.
    Regards
    John



  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Display image at current record (A97)

    See "Highlight a single row" on Liquorman, Inc.: Access Tips, Links, & Downloads, and also the attachment to <post:=227,142>post 227,142</post:> for Access 97 methods.

  12. #12
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Display image at current record (A97)

    Check out Mark Liquorman's site, e has something similar that colours the whole of the pointed record.

  13. #13
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Display image at current record (A97)

    Here is a version of what I posted before that works in 97. Using the idea that the Hans and Patt have pointed us to.
    Attached Files Attached Files
    Regards
    John



  14. #14
    Star Lounger
    Join Date
    Apr 2002
    Location
    Onekama, Michigan, USA
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Display image at current record (A97)

    Thanks everyone for all the help. That is just what I was looking for.

    Ron

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •