A ashraful New member Local time Today, 09:31 Joined Dec 6, 2017 Messages 9 Apr 5, 2018 #1 Hello Everyone, I want a Red Flag will appear in the Report below when Current Date crosses the Reminder Date. Plz help.
Hello Everyone, I want a Red Flag will appear in the Report below when Current Date crosses the Reminder Date. Plz help.
pbaldy Wino Moderator Staff member Local time , 19:31 Joined Aug 30, 2003 Messages 36,186 Apr 5, 2018 #2 Your image isn't appearing; you need to attach it here.
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 10:31 Joined May 7, 2009 Messages 19,703 Apr 5, 2018 #4 hi there, see sample if this is what you need Attachments flag.zip flag.zip 30.6 KB · Views: 116
A ashraful New member Local time Today, 09:31 Joined Dec 6, 2017 Messages 9 Apr 5, 2018 #5 there'll be little change in the condition. If current date crosses the Reminder Date and Current date is less than Due Date. Last edited: Apr 5, 2018
there'll be little change in the condition. If current date crosses the Reminder Date and Current date is less than Due Date.
A ashraful New member Local time Today, 09:31 Joined Dec 6, 2017 Messages 9 Apr 5, 2018 #6 there'll be little change in the condition. If current date crosses the Reminder Date and Current date is less than Due Date.
there'll be little change in the condition. If current date crosses the Reminder Date and Current date is less than Due Date.
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 10:31 Joined May 7, 2009 Messages 19,703 Apr 5, 2018 #7 add it to the criteria in VBA: Me.imgFlag.PictureData = Switch(Me.Reminder_Date <= Date And Date < Me.[Due Date], Me.Image2.PictureData, True, Me.Image1.PictureData)
add it to the criteria in VBA: Me.imgFlag.PictureData = Switch(Me.Reminder_Date <= Date And Date < Me.[Due Date], Me.Image2.PictureData, True, Me.Image1.PictureData)
A ashraful New member Local time Today, 09:31 Joined Dec 6, 2017 Messages 9 Apr 5, 2018 #8 Thanks. It is ok now.
