data don't seem to save + others

[Jenny]

Hello,
I have a few questions here!!!first of all...
pls send me an email with these answer
1)I have linked onw form to another.. i want to be able
to when I open the new form the existing form closes, how
do i do that..

2) I have realised that with my database when I enter
data via teh form and close that form to go to another
form to update the information the I have entered i can't
seem to find the records that i have entered (even after
clicking save) unless i close the whole database and open
it again. what is the problem

3) this is like doing a questionaire,,, i have questions
whereby the answeres are YES, NO, and N/A only
i want to be able to do it is such way that i can get a
percentage at as the end result..ie
quest 1 = yes
quest 2= yes
Quest 3= yes
quest 4=no
total % of yes = 75%
or alternatively
quest 1 = N/a (because n/a should have a 0 value)
quest 2= yes
Quest 3= yes
quest 4=no
quest 5=yes
total % of yes = 75%

Your help would be greatly appreciated...
pls email me the help (e-mail address removed)
regards,
Jenny

 

[John Vinson]

Hello,
I have a few questions here!!!first of all...
pls send me an email with these answer

That's considered an impolite request. If it's worth my time as an
unpaid volunteer to connect to the newsgroup to answer, it should be
worth yours to come to the newsgroup for the answer; and someone else
might have the same problem. Nonetheless, copied to email; please
reply to the newsgroup, or to my EMail with a commitment to negotiate
a consulting contract.

1)I have linked onw form to another.. i want to be able
to when I open the new form the existing form closes, how
do i do that..

Put VBA code or a Macro in the Close event of the first form to open
the second one.

2) I have realised that with my database when I enter
data via teh form and close that form to go to another
form to update the information the I have entered i can't
seem to find the records that i have entered (even after
clicking save) unless i close the whole database and open
it again. what is the problem

<confusion> Why two forms for one table? A Form can be used to enter
*or to edit* data. But... you may have the second form already open,
and need to Requery it.

3) this is like doing a questionaire,,, i have questions
whereby the answeres are YES, NO, and N/A only
i want to be able to do it is such way that i can get a
percentage at as the end result..ie
quest 1 = yes
quest 2= yes
Quest 3= yes
quest 4=no
total % of yes = 75%
or alternatively
quest 1 = N/a (because n/a should have a 0 value)
quest 2= yes
Quest 3= yes
quest 4=no
quest 5=yes
total % of yes = 75%

A Totals query on the table calculating the Average of the expression:

IIF([Answer] = "yes", 1, 0)

should do the trick.