Recent content by Forsi

  1. F

    Minor Error with Code for Attaching Images to Forms

    Guys I am royally confused (know absolutely nothing about codes or where to place what). Purvis - are you saying that if the code works then let it be, but just add Me![ImageFrame].Picture = Nz(Me![ImagePath], "") or If IsNull(Me.Photo) Then Me![ImageFrame].Picture = "" Please show me...
  2. F

    Minor Error with Code for Attaching Images to Forms

    Hi Guys I could not understand how to insert the picture using the path and after having tried this example from this thread, I was able to edit a few things and it worked. Please see the attached and view - you will see where the insert pic code came from...
  3. F

    Hi Zanaeira Thanks for your assistance. I sent a response on "Minor Error with Code for...

    Hi Zanaeira Thanks for your assistance. I sent a response on "Minor Error with Code for Attaching Image to a Form". Kindly review and get back to me at your earliest convenience. Thanks
  4. F

    Minor Error with Code for Attaching Images to Forms

    Hi Zanaeira Thank you for responding. I tried what you indicated (with my ltd knowledge of codes). It worked for Remove Picture. However, as I move through each record, I see the message "Click Add/Change Picture to Add Photo" on each picture (I named the label errormsg). Also, when I get to...
  5. F

    Use a Query to Generate a Monthly Report

    Bob This is exactly what I was looking for - it worked like a charm. You are the best! Thank you very much. Forsi
  6. F

    Use a Query to Generate a Monthly Report

    Hello I would like to create a query to list the employees who take leave during each month during the year and then use that query to generate a report which shows leave by month. At the end of the June, I would like to run a query to show all employees going on leave in July. The fields are...
  7. F

    Minor Error with Code for Attaching Images to Forms

    Both ways work. My sincerest appreciation to both of you. One more question. Using this same code, how can I insert a text box message to say something to the effect: "No Image is Displayed for this Employee. Select Add/Change Picture to insert a photo"? Currently, if no image is selected, it...
  8. F

    Minor Error with Code for Attaching Images to Forms

    Hello I don't know a thing about writing VBA Codes but this forum I was able thas helped me to finally figure out how to link the pictures to a path etc on a form. Everything works fine on the form - the pictures change with each employee etc, etc. However, when I select the command button...
Back
Top Bottom