Search results

I can get a total between paarameter Donation Amounts with the following Query (SQL): SELECT Contacts.LastName, Contacts.FirstName, Contacts.ContactId, Sum(Donations.[Donation Amount]) AS [SumOfDonation Amount] FROM Contacts INNER JOIN Donations ON Contacts.ContactId = Donations.ContactID GROUP...

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...

Yes it is. All I wanted to happen was have the SubForm open IF the Catagory field on the main form is set to Gift In Kind and I want the subform's Receipt Number field to be populated with the same receipt number (this is the link between the two tables - Donation table and GIKTable) so when...

yes, I think that is what I need

After creating new and importing and deleting I think I have the DB small emough to attach with just the new donations and GIKTable subform.

No. I got it down to 632K. Maybe it is all teh COde written behind everything I deleted?

The file is too big and I cannot figure out how to get it smaller. I have deleted all tables and forms and reports and Queries other than those needed for the two forms at issue, and I have copacted and repaired, but it is still 865K Zipped which is too big.

I must be an Idiot -- it says cannot attach a .db file, only JPEGS, TXT, etc. I can e-mail it to you.

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...

"A Jeffery Jordan Already Exists. Continue Update ?" Yes No No -- gives a message "No Current Record" and Form is Erased !!!!!!!! Yeeeee Haaaaa ! Thank You !!!!!!!!!!:D :D :D I set up one for first and last name on the After Update for LastName and another for CompanyName after update...

I have added the References. When I try to run it now, I get an error pop up box that says "RunTime Error '3251': Operation is not supported for this type of object." DeBug takes me to the line rst.FindFirst "[LastName] & [FirstName] Like '*" & strContact & "*'" I think there is something...

I drive less but am leaving too. I changed the form textbox names and Now it gets down to rst.FindFirst and gives the same message. I cannot beleive you are working so hard to help me and I appreciate it.

I appreciate your help -- had the 3.6 so I added it and now I get past line one :) but get the same error message highlighting the txt.lastname :(

When I try to run it I get an error "Compile Error - User Defined Type not defined and the DeBugger takes me to the Fisrt Line Dim dbs as DataBase with the dbs as Database highlighted. :) Ye Ha ! Also, on the spaces, the Contacts Table field for LastName and FirstName had no spaces. The...

That is a good point except many companies have multiple contacts with the same phone and we do not have phone numbers for all our donor (I know we should) - but no one kept track until now -- that is why I am trying to do a database for them. Thanks to all for your help (and the interesting...

First, the Contacts table includes not just donors. It includes families we serve and people who get newsletters and professionals who refer families to us. I have a donation form that only lets the user select from the existing contacts and if not on the list, there is a button to pull up a...

How about some help with this :) EDIT: I was trying to figure out something and posted this while you guys were posting above -- I am not smart enough (or experienced enough) to write the code to do what you suggest. Below is what I was trying to do. I have a query that starts with the...

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...

Thanks Pat. Every time I learn some more basic stuff like this, I get chills :) I did buy an Access Bible (about 3 inches thick) but it does not tell me as much as I need to know about virtual basic and sql. With help from people like you answering stupid questions, someday I will be able to...