J
jubiiab via AccessMonster.com
I need to make a Form where the user type:
SampleID: 1234
StartDate: 01-01-2010
EndDate: 01-01-2015
CheckEvery: 3
(There will be more fields but these are the most important)
On this form there should be a subForm because in the subForm it will show
all the due dates:
0 3 6 9
12 15
01-01-2010 01-03-2010 01-06-2010 01-09-2010 01-12-2010 01-03-
2012
...and it continues until it reaches the last date 01-01-2015.
In the “checkEvery†textbox the user should be able to write a number. In
this case I wrote 3 – means that the subform should write the date for every
3rd month. I don’t know how to make this subform to add dates automatically?
Is it also possible to make a checkbox for every date it shows? So you can
mark that the sampleID has been analyzed that date?
I am sorry about my English. I know it’s not good but I hope you understand
the question or please ask.
SampleID: 1234
StartDate: 01-01-2010
EndDate: 01-01-2015
CheckEvery: 3
(There will be more fields but these are the most important)
On this form there should be a subForm because in the subForm it will show
all the due dates:
0 3 6 9
12 15
01-01-2010 01-03-2010 01-06-2010 01-09-2010 01-12-2010 01-03-
2012
...and it continues until it reaches the last date 01-01-2015.
In the “checkEvery†textbox the user should be able to write a number. In
this case I wrote 3 – means that the subform should write the date for every
3rd month. I don’t know how to make this subform to add dates automatically?
Is it also possible to make a checkbox for every date it shows? So you can
mark that the sampleID has been analyzed that date?
I am sorry about my English. I know it’s not good but I hope you understand
the question or please ask.