Recent content by Thel888

  1. T

    Display message when control has no image.

    Finally! I found a very practical solution and I will share it with you: Create two picture boxes with the same size (height and width) and the following property settings: Box 1: Name: PhotoClient Visible: Yes Image Type: Shared Image: (none) Size Mode: Zoom Image Alignment: Centered Box 2...
  2. T

    Display message when control has no image.

    Would be able to access this hidden system table and check if it is empty via VBA?
  3. T

    Display message when control has no image.

    I will try this option too.
  4. T

    Display message when control has no image.

    It gave error 438: The object does not accept the property or method.
  5. T

    Display message when control has no image.

    Now there was no error after compilation, I was putting the expression before the name of the image control! But click and nothing happens.
  6. T

    Display message when control has no image.

    In mine, either the expression "Is Nothing" or "IsNothing" is giving an expression error. Is it some reference that needs to be enabled?
  7. T

    Display message when control has no image.

    It's an interesting option, but how to implement it if Access doesn't understand that there isn't an image inside the control?
  8. T

    Display message when control has no image.

    If I can't find a solution, I'll do this or create a table just to store a blank image and point the image control to it. But anyway it's a shame the VBA developers didn't think of this more clearly, because there really is a chance that you try to delete an image and the control doesn't have one.
  9. T

    Display message when control has no image.

    If I don't find a solution, I'm seriously considering it. Or create a table to hold a blank image and point the control at it.
  10. T

    Display message when control has no image.

    Tested: it didn't work.
  11. T

    Display message when control has no image.

    Hello! I tested "IsNothing" and "= Nothing", but it doesn't work, it gives an error. I believe it's because these options are native to Visual Basic but not VBA. In Office 2016 64-bit, you have three options for adding an image to an image control in the Image Type property: Embedded, Linked...
  12. T

    Display message when control has no image.

    Hello again friends! Forgive me for the delay in responding. In Office 2016 64-bit, you have three options for adding an image to an image control in the Image Type property: Embedded, Linked, and Shared. The first two I tested, but they have a disadvantage: if you move or delete the image from...
  13. T

    Display message when control has no image.

    I'm using the "Picture" property of the image control, for the "shared" image, so that it is stored in the form itself, because the number of entries is small, less than 100, and therefore I don't want to save photos in subfolders. How would the code with the Controlsource property look like? I...
  14. T

    Display message when control has no image.

    Hello friends! I have an image type control called "photo", with no image, and a delete button on a form. I would like when I click on the delete button to display a message like "There is no photo to be deleted!". I already tried all these codes, one at a time, but when I click on the delete...
  15. T

    Solved Fill in form fields based on a combo box.

    Thank you for your attention. It was my fault for writing a large and unnecessary code, the solution was much simpler and is registered there in the answer. Gratitude!
Top Bottom