I have a strong background in VB, VB6, Access and SQL Server but am a newbie in Alpha 5.
I am tinkering with my A5 V10 and will be seeking help here if I get stuck, as it is the best way of learning.
And I am glad that we have some very good experts here who like helping newbies like me.
I have just started on my very first A5 project and set up the tables, primary keys, foreign keys, sets, and field rules.
In Tasks table, I have four dates, PlannedStart, PlannedEnd, ActualStart and ActualEnd.
The first two are required, the others optional as they may be entered only after the actual task is started.
I am validating PlannedEnd, ActualStart and ActualEnd to be on or after PlannedStart, with a suitable error message for each.
I am also validating ActualEnd to be on or after ActualStart. ActualStart and ActualEnd are valid if their length is zero.
1. However, if I enter a date in any of the three fields earlier than PlannedStart, the field remains blank without the error message popping up. What could be causing this problem?
2. I also want to be able to trap any user from editing the PlannedStart field to a date that is later than any one or more of the others. If I place a validation field rule on this field then it fires for new records too, when it is the first of the four date fields to be entered. How can I make it fire in edit mode only?
Any help will be appreciated, thank you all.
I will be shouting for more help issues while this project unfolds.
I am tinkering with my A5 V10 and will be seeking help here if I get stuck, as it is the best way of learning.
And I am glad that we have some very good experts here who like helping newbies like me.
I have just started on my very first A5 project and set up the tables, primary keys, foreign keys, sets, and field rules.
In Tasks table, I have four dates, PlannedStart, PlannedEnd, ActualStart and ActualEnd.
The first two are required, the others optional as they may be entered only after the actual task is started.
I am validating PlannedEnd, ActualStart and ActualEnd to be on or after PlannedStart, with a suitable error message for each.
I am also validating ActualEnd to be on or after ActualStart. ActualStart and ActualEnd are valid if their length is zero.
1. However, if I enter a date in any of the three fields earlier than PlannedStart, the field remains blank without the error message popping up. What could be causing this problem?
2. I also want to be able to trap any user from editing the PlannedStart field to a date that is later than any one or more of the others. If I place a validation field rule on this field then it fires for new records too, when it is the first of the four date fields to be entered. How can I make it fire in edit mode only?
Any help will be appreciated, thank you all.
I will be shouting for more help issues while this project unfolds.
Comment