G
Guest
1. In a form I would like to put an autofill field that will insert the date
the form was filled in. But when it is emailed to me and I open it, I do not
want the date to change to the day I opened the form(as it would if I used
insert/date time/ and clicked update automatically)
2. without using excel, can I create a field in a form that will give me an
age in years? I need to know the difference in years between the day the form
was filled out and the birthdate listed in a field in the form. I would like
this to automatically populate (like form filled out: June 27, 2007;
birthdate list in another field is 6/27/2000; age field automatically
populates to 7). This would involve 3 fields: today's date; birthdate; and
age fields....if this is possible what would that formula be?
3. I used the forms toolbar to insert check boxes into the form- but when I
practiced filling out the form I cannot get the check box to fill as I click
on it- in fact I cannot click on the check box- I can only click 1 space
before it or 1 space after it.
I am in the process of reading Computer Companion 'please fill out this
form' to see if my questions are answered- but a quick read thru did not seem
to address the particular requests I have
thanks!
the form was filled in. But when it is emailed to me and I open it, I do not
want the date to change to the day I opened the form(as it would if I used
insert/date time/ and clicked update automatically)
2. without using excel, can I create a field in a form that will give me an
age in years? I need to know the difference in years between the day the form
was filled out and the birthdate listed in a field in the form. I would like
this to automatically populate (like form filled out: June 27, 2007;
birthdate list in another field is 6/27/2000; age field automatically
populates to 7). This would involve 3 fields: today's date; birthdate; and
age fields....if this is possible what would that formula be?
3. I used the forms toolbar to insert check boxes into the form- but when I
practiced filling out the form I cannot get the check box to fill as I click
on it- in fact I cannot click on the check box- I can only click 1 space
before it or 1 space after it.
I am in the process of reading Computer Companion 'please fill out this
form' to see if my questions are answered- but a quick read thru did not seem
to address the particular requests I have
thanks!