Recent content by Glennzo

Thanks ghudson. Appreciate the help. I've basically gotten this far. It's the underlying code that eludes me. How does one cancel a change to an option group? Glennzo...

Hey folks, I'm using an option group in my program and would like to use a msgbox for confirmation when the user clicks on any one of the option buttons. I'd like to have it function so that if the user clicks OK in the msgbox the change is completed but if the user clicks cancel the change is...

I'm using the query to filter out the 70 pledging members from a table of about 200 members. That way, only the pledging members are displayed on the form. Given my relative lack of Access experience, I assume that this is the way to do it. I have a working model of this church database that I...

Here's the SQL. Hope this isn't a repeat post. Was using Netscape and it didn't seem to work... SELECT tblDirectory.MemberId, tblDirectory.LastName, tblDirectory.FirstName, tblDirectory.Address, tblDirectory.Address2, tblDirectory.City, tblDirectory.State, tblDirectory.ZipCode...

I did create a join, one to many, between the 2 tables. How about that non-updatable table? When one creates a table, is there a parameter that makes in updatable or non-updatable? Glennzo...

Hello again all. Is there any particular reason why, when I add a new table to an existing query, and add fields to the query from said table, I cannot edit the new or previously existing fields when I run the query? Thanks for your time and consideration. Glennzo

Yahoo! You folks are the greatest! I have to leave for work in a few minutes so I'll give these suggestions a go tonight. I'll add a third table for the weeks and make the necessary relations. A question though. I've been playing around with a similar scenario, created tables with...

This is how I see these two tables: tblDonors: DonorId - AutoNumber - Primary Key DonorName tblDonations: DonationId - AutoNumber - Primary Key DonorId - Number - Linked to DonorID in tblDonors DonationAmountWeek1 DonationAmountWeek2 DonationAmountWeek3 .......... DonationAmountWeek52 In...

Maybe someone can help get me started with a new project. I need to track names and addresses in a database. Also need to track donations for each person in the address database on a weekly basis. I'd like to relate the donation(s) to the date so that if I want to see what was donated during any...

I'm tracking weekly pledge amounts for church members. I plan on entering the amounts that each member gave on a weekly basis along with the initial pledge and pledge type. Will also need to have totals on a monthly basis, individually and overall. Initial pledge is the amount that they pledge...

Thanks for the reply Bob. I'll create a table with the following fields: PledgeId - AutoNumber MemberID - Number ( Link this one to MemberId in the Members table? ) PledgeType - Number PledgeAmount - Currency TotalPledge - Currency ( do I need this in the table or should I do the calculations...

Hi everyone. I am going to create a database that will track weekly pledges for about 70 active members. I already have a 'membership' table that contains names and addresses, etc. We need to track items such as pledge type (weekly, monthly, etc ) and amount. I also need to calculate totals for...

Columns in reports Ok, found the answer to my question. I stumbled across Microsoft Knowledge Base Article 153052 and it held the solution. If you're interested, have a look at it. It would probably be better than any long winded description I could offer here. Thanks a bunch for all the help...

Wow! Why didn't I think of that? You may just be right Neil. A tabular report might be just what the doctor ordered. If it wasn't for the fact that I'm playing around with Linux at the moment I'd be trying your idea out. Stay tuned...

It looks as though I'll have to look at reports with sub-reports to solve my dilemma. One thought might be to export the data to Word and just add the labels by hand. We've already tried that. It will suffice, but it definitely makes everything a lot less dynamic.