Can't do data entry

[cheyenne2002]

I have a problem with a subform. It will not allow me to do data entry into it.

I have a fund raising database. A table with donors, one with pledges, and one for the payments of the pledges.

I'm using the form with tabs to show the different data. The donor info is okay, the pledge info is okay and will let me add pledges to each individual donor as needed. However, when I tried to add a payment for one of the pledges I just received the form will not allow me to enter anything.

Any suggestions as to what my problem is. I'm sure it is something right in front of my face that I can not see.

Thanks for helping.
Sharon

 

[fneily]

Check your relationships and see:
Harnessing the Power of Updatable Queries

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_harness.asp

 

[randy700]

You won't be able to update if your query includes aggregate functions. If they are only in the query for display purposes on the form, do the calculations on the form instead.



Randy

 

[cheyenne2002]

fneily,
I did add the table to the relationship window, but still no data entry.

Randy,
The subform on the tab is from a table and not a query.

I have a feeling that I'm trying to do this wrong.

I'm new to Access and not sure I am doing this right.
Sharon

 

[cheyenne2002]

Randy, you are right. I am using a query to create this subform.

How do I tell if I have an aggregate function in my query?

I used the Design View to create the query, but I will list the SQL below so you can see what I'm trying to do.

SELECT Donations.DonorID, Donations.DateOfDonation, Donations.AmountOfDonation, Donations.ExpectedDate, Donations.OtherDonationDetails, Donations.ActualSolicitor, Donations.CampaignName, Payments.ID, Payments.Created, Payments.[Donation Type], Payments.Expected, Payments.Received, Payments.DonorID, Payments.Donor, Payments.CampaignName, Payments.Campaign, Payments.[Payment Date], Payments.[Expected Date], Payments.Solicitor, Payments.CheckNumber, Payments.CheckDate, Payments.[Receipted Amount], Payments.[NPC Member No], Payments.CampaignTeam, Payments.[2005CDMailed], Payments.[2006CDMailed]
FROM Campaign RIGHT JOIN (Donations LEFT JOIN Payments ON (Donations.DonorID = Payments.DonorID) AND (Donations.CampaignName = Payments.CampaignName)) ON Campaign.CampaignID = Donations.CampaignName;


Any ideas of what I did wrong?
Sharon

 

[fneily]

I didn't mean to "add the table to the relationship window". By the way, that is where YOU create relationships, not Access.
Do you have the appropriate primary keys on the forms?

 

[cheyenne2002]

I didn't, but I just added them and it did not change anything. I think I used the Form Wizard to create the form. Would that make a difference?

I can add records to the pledge form, but its source is the pledge table and not a query.

The reason I used a query is so that I could match up the payments with the open pledge. I did not put a paid field in the pledge because some donors make several payments on a pledge and do not pay it all at once. I need to be able to show a payment schedule when needed......

This is frustrating.
Sharon

 

[fneily]

Run your query by itself. Then try to update the field you want. I bet it'll say no way. Did you read the reference I gave you? Notice your query has a right join then left join?

 

[cheyenne2002]

fneily,
I did try the query by itself and you are right. No go on the data entry.

I printed out the link you gave me. I'm confused. On the second page it defines Left Outer Join and Right Outer Join.
LOJ states (I think) that it will include all the records on the left and only those that match from the right.

When I look at the design view and double click on the relationship line, I can choose what I want to have.

Example from a dummy database (not mine)

The query has a Registration Table physically on the left of the grid and the Attendees on the right. If I double click on the relationship line I can select to have it show all the records of the Registration and only those that match from Attendees. When I did this and then went into the SQL view, it said RIGHT JOIN.......how can it say that when the Registration is on the left and I told it that I wanted all the Registration records.

Or does this have nothing to do with the Right/Left wording of the joins.... Like I said I'm totally confused and frustrated.

I think I'll call it a day and start up again on Monday.
Sharon