Use a Flag in Report (1 Viewer)

A

ashraful

New member

Local time

Tomorrow, 03:02

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.

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 13:02

Joined

Aug 30, 2003

Messages

36,124

• Apr 5, 2018

• #2

Your image isn't appearing; you need to attach it here.

 

A

ashraful

New member

Local time

Tomorrow, 03:02

Joined

Dec 6, 2017

Messages

9

• Apr 5, 2018

• #3

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 04:02

Joined

May 7, 2009

Messages

19,229

• Apr 5, 2018

• #4

hi there, see sample if this is what you need

 

Attachments

• flag.zip

  30.6 KB · Views: 94

A

ashraful

New member

Local time

Tomorrow, 03:02

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

A

ashraful

New member

Local time

Tomorrow, 03:02

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.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 04:02

Joined

May 7, 2009

Messages

19,229

• 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)

 

A

ashraful

New member

Local time

Tomorrow, 03:02

Joined

Dec 6, 2017

Messages

9

• Apr 5, 2018

• #8

Thanks. It is ok now.