I am not very experienced with VBA and I could use some help
I need to figure out how to code the following situation:
I have a publication that is published every 56days. There is a cutoff date to get changes into the publisher to make the next cycle. The cutoff date is 27 days before the publication date .
I have a form with the following dates in txt boxes:
I have one txt box on the form that is bound to the field [FlipEffDateStart]
All the other dates on the form are figured using the [FlipEffDateStart] field.
The current Publication effective date is calculated by [FlipEffDateStart] –56
The current Publication cutoff date is calculated by [FlipEffDateStart] –83
The Next Publication effective date is the field [FlipEffDateStart]
The Next Publication cutoff date is calculated by [FlipEffDateStart] –27
The Next x2 Publication date is calculated by [FlipEffDateStart] + 56
The Next x2 Publication Cutoff date is calculated by [FlipEffDateStart] +83
What I want is for the dates to automatically update when the next publication date is reached.
I also need a message to show on the screen updating the users how much time is left before the next cutoff date. EX.(“22 days left before cutoff”).
When there are 3 days to the cutoff I want the text to turn red
When the cutoff date is reached, but the next publication date has not been reached yet, I need a message that says “the cutoff for this cycle has passed. Changes sent in now will not make this publication cycle.”
When the next publication effective date is reached, I need to reset the next publication effective date to date + 56 and update the message to tell how much time is left before the next cutoff date.
I also have a table with the following fields:
FlipEffDateStart
FlipCutoffDate
NextFlipEffDate
NextFlipCutoffDate
FlipCutoffDate
FlipEffDateStart
Right now, I am just using the FlipEffDateStart field of this table. I'm sure this should be easy, but I can' t seem to figure it out.
Thanks for any help.
I need to figure out how to code the following situation:
I have a publication that is published every 56days. There is a cutoff date to get changes into the publisher to make the next cycle. The cutoff date is 27 days before the publication date .
I have a form with the following dates in txt boxes:
I have one txt box on the form that is bound to the field [FlipEffDateStart]
All the other dates on the form are figured using the [FlipEffDateStart] field.
The current Publication effective date is calculated by [FlipEffDateStart] –56
The current Publication cutoff date is calculated by [FlipEffDateStart] –83
The Next Publication effective date is the field [FlipEffDateStart]
The Next Publication cutoff date is calculated by [FlipEffDateStart] –27
The Next x2 Publication date is calculated by [FlipEffDateStart] + 56
The Next x2 Publication Cutoff date is calculated by [FlipEffDateStart] +83
What I want is for the dates to automatically update when the next publication date is reached.
I also need a message to show on the screen updating the users how much time is left before the next cutoff date. EX.(“22 days left before cutoff”).
When there are 3 days to the cutoff I want the text to turn red
When the cutoff date is reached, but the next publication date has not been reached yet, I need a message that says “the cutoff for this cycle has passed. Changes sent in now will not make this publication cycle.”
When the next publication effective date is reached, I need to reset the next publication effective date to date + 56 and update the message to tell how much time is left before the next cutoff date.
I also have a table with the following fields:
FlipEffDateStart
FlipCutoffDate
NextFlipEffDate
NextFlipCutoffDate
FlipCutoffDate
FlipEffDateStart
Right now, I am just using the FlipEffDateStart field of this table. I'm sure this should be easy, but I can' t seem to figure it out.
Thanks for any help.