Recent content by suzzieo

I have created a form in my database that I will partially fill out. Then I'd like to email it to another person, have them complete the information and return it to me. Is there a way to email the receipeint the form as a Microsoft Word form, have them fill it in and email back to me. I am...

I can't remember how to add a total to a report. I have 2 fields on the report - name and amount paid. There are 40 names with dollar amounts. All I want to do is get a total of the all the amount paid. I know it's simple but I can't remember the correct syntex. Please help. From what I...

I have a form that has 2 subforms in it. I have 400 records in the database. Example - Main form includes patient name and address One subform includes name of training session attended and date. The patient can attend more than one session, so my relationship is one (patient) to many...

thank all of you for responding to helping me calculate age - however! I set up the calculation in my query using Age: DateDiff("yyyy", [DOB], Date()) + (Date() < DateSerial(Year(Date()), Month([DOB]), Day([DOB]))) and it works beautifully but how do I get that calculated age to appear on...

thank all of you for responding to helping me calculate age - however! I set up the calculation in my query using Age: DateDiff("yyyy", [DOB], Date()) + (Date() < DateSerial(Year(Date()), Month([DOB]), Day([DOB]))) and it works beautifully but how do I get that calculated age to appear on...

I have 2 fields in my table; "Birthdate" and "Age". I will be entering the birthdate but I want the age automatically calculated from the birthdate field. Can someone help me with the correct code? Thank you so much!!

can't open anything in my database I just tried to open a couple of my databases. I was able to open them but when I tried to click on tables, forms or anything, I got the message - "OLEAUT32.DLL is out of date. This program requires a newer version." I am using Access 2000. Any idea what...