data don't seem to save + others

  • Thread starter Thread starter Jenny
  • Start date Start date
J

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
 
Hello,
I have a few questions here!!!first of all...
pls send me an email with these answer
Click to expand...

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..
Click to expand...

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
Click to expand...

<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%
Click to expand...

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

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

should do the trick.
 
Back
Top