Hello, Access 2013-Recurring Condition does not work with me, I convert the Macro to VBA to show you what I did '------------------------------------------------------------ ' TaskCovertto_VB_RecurringM ' '------------------------------------------------------------ Function TaskCovertto_VB_RecurringM() On Error GoTo TaskCovertto_VB_RecurringM_Err
With CodeContextObject If (.RecurringCombo = 1) Then Forms!TaskF!DueDate = Forms!TaskF!DueDate + 1 ' Daily End If If (.RecurringCombo = 2) Then Forms!TaskF!DueDate = Forms!TaskF!DueDate + 7 ' Weekly End If If (.RecurringCombo = 3) Then Forms!TaskF!DueDate = Forms!TaskF!DueDate + 14 ' BiWeeks, means 2 weeks End If If (.RecurringCombo = 4) Then Forms!TaskF!DueDate = Forms!TaskF!DueDate + 30 ' Monthly End If If (.RecurringCombo = 5) Then Forms!TaskF!DueDate = Forms!TaskF!DueDate + 90 ' Quarterly End If If (.RecurringCombo = 6) Then Forms!TaskF!DueDate = Forms!TaskF!DueDate + 360 ' Annually End If End With
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 207.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.