Search results

I have a form that selects Contacts from the contacts table to enter donations in the Donations table. Because there are companies and individuals in contacts (fistname, lastname and companyname fields) I set up the box to select as follows SELECT Contacts.ContactId, IIf([companyname] Is...

I would like to print out my Family Data Form to use as an Intake Sheet for Families. They fill out the same information in the same order as on the Form for entry of the data into the system. When I try to print the form all I get is a Header bar with nothing else. If I set to print data it...

I have two tables Contacts Donations They are joined by the ContactID in the Contacts table (an autoGenerated Priomary Key) One Contact can have Many Donations during the year. I need to be able to figure out who has donated IN TOTAL for the year between Ranges of Numbers. So for example, I...

How do you Populate a field on a form based on a field in another form ? I have a form to enter new donations for donors and one of the fields for describing donations is [catagory] and one selection choice is "Gift In Kind". The table for Catagory is Donations. I have another Table named GIK...

I am creating a donor database that has a main "Contacts" table which contains all the basic contact information (First Name, Last Name, Company Name, Address, City, State, Zip Phone) with an Autonumber ContactID as the primary key field. The related table is Donations where we track all...

Counting problem in a report. Edit: Woops, I already answered the first question, (dopey me) I should probably repost this one but I also need to know: I have a report with headers for ProgramID (the program the Family Attends); FamilyID Header (names of Families) and then in the Detail, I...

I would like the user to be able to generate Donation Receipts by Date Range and between $x and $y. I have a query to generate the information that then goes into the receipts Report. What I want is to also generate Mailing Labels for the SAME set of parameters without the user having to enter...

I want a User to be able to edit records in the Contacts database by selecting the ContactID, FirstNAme, LastNAme from a combo box and when that happens, it pulls up the information for that and the ComboBox come from the same and table come from and it does nto seem to work. I cannot seem to...

I have a query written to Update a IndContacts.donor field (Yes/No Box) to Yes which I would like to cause to run Before a Query which generates all information about Donors keyed off that field (Donor). When I look at the SQL Statement it starts Select IndContacts.ContactID, etc..... Where...

I can change the format of each record, but i want it so the person just enters the e-mail in a form for each new contact and it IS an e-mail address that can be clicked on to generate an e-mail (eventally I will use the e-mail to send out our newsletters and save postage).

I am NEW at this, but I have a command button on a form that is set to docmd.openreport("All UnReceipted Donations") acPreview I am trying to use the MsgBox but am having trouble with formatting it and with causing it to effect a result. I want to use a yes/no MSG pop up windows with a...

First all the background to get to the Questions: I am working on a database for a charity that I am on the Board of, Three Trees, to track families that participate in our programs and donors that provide us with support. I have a Main Table (IndContacts) where I store all contact information...