Search results

What I meant was that is there a way to make the On Click Embedded Macro in to a code to paste it onto this forum so people can see what I have done wrong? Also, any suggestions on how to make the "open" and "new" function of the field work would be appreciated.

I am using MS Access 2007, and I am currently trying to implement what is already available on the "Student" template provided by microsoft. My main goal is to use the =IIf(IsNull([ID]),"(New)","Open") field in the form to open a popup form which is used to input/edit data. I have copied the...

vbaInet thank you for all your help. The form and report are both working and I can see the calculation working the way I had hoped. Without your help this would not have been possible.

Thank you for the replies, I have made the query calculation by replicating the one you made, but is there anyway to see the solution of the calculation? Also, is it possible to see the calculation in a report when I need to do some analysis?

I attached the access file so I hope this will provide some information. I also removed all non-related fields since it took up way too much space for me to upload it. Again thank you for your assistance.

Thank you vbaInet. The [FH Mother] and all other fields record 1/0 value instead of yes/no. I wanted to make the calculation recorded on the table since the value of the calculation is what is actually important which is dependent on the answers to the other 12 fields (FH Mother, FH Father, FH...

Thank you for your response VbaInet. I have inputted the formula you have provided in the query of the field that is used to record the calculation and changed the "MySum" to the field that the summation would be recorded to and "Field1, Field2 etc" as the fields used in collecting the 1/0...

Hi, I am new to Access and I am not sure if this problem fits into this topic as it might span into a few different categories. I am currently using Ms Access 2007. I have a table setup with 12 fields and form with 12 fields which is corresponding to the 12 fields on the table. The 12 fields...