Recent content by Bob87476

The idea I had is too complicated to ask just a simple question but I have found a way to solve my problem. Thanks again for your help.

Thanks or your encouragement. I do in fact have an autonumber field as the PK for Batch Date table. I have now amended the form to sort the donations on DonationID (Desc) so the latest donations are at the top. I also have a Private Sub Detail_Click() Me.Child.Requery End Sub So if you...

Sorry. Just realized that I should have said that each "Batch of Donations" must have a unique Batch Date. Now it makes sense why you were confused.

The process is first to create a Batch Date (if not already created) then set a Batch Date for the "Batch" of entries Then enter a series of donations with that same date. Then balance the batch (all entries in that session) against the Bank Deposit. Finally after the bank has been reconciled...

Yours is the best solution that I have received. The reason I have chosen to have a separate table for Dates is because all users will not necessarily have the authority to add a new Batch Date. My plan is to limit the "Add Batch Date" process with a password. I do have a few questions about...

I am sorry that I offended you by posting in a different forum. I won't do it again. This is exactly what I asked for and you have kept the solution very simple.

Sounds great but please check the file you uploaded because it doesn't have any of the elements that you spoke of in your text.

I have a query of "Donations" in a sub form and want to use a combo box to specify all donations having a specific date. is this a job for VBA code? or is there some other way. I have uploaded the file. just open frmQryDonationsByBatchDate and hopefully it will make sense.

Thanks again it gave me a lot of help. I realize I was going down the wrong path and had not really explained clearly what I wanted. So I am uploading another example. If you open the Form frmQryDonationsByBatchDate You will see I have a qry as a subform and on the Main Form I have a...

Yes the dates are stored in the Batch Date table. Donations are counted and deposited in Batchs so each donation must have a unique Batch Date.

So I did as you suggested I Created a form based on Donor with a subform based on Donations. But I also want to be able to specify the Batch Date. When I tried to put a combo box on the form to chose the Date it did not give me the option to chose the table Date. I was using the wizard which...

I am using Access2013 and when I go to Save AS it says that it is saving it in 2007-2013 format. If I save it as 2003 format all it does is save the tables and not the forms. So I am uploading that and see what you get. While you are looking at that I will compose a post explaining what I...

Sorry Here is the upload

Thanks Mihail It worked for me to be able to select the donor but not the Batch Date so I played around with it and have uploaded my tests. I have also added another challenge. I am trying to select the Donor either by Last Name or Env Number.

The tables are related by DonorID At the top of the form I want two combo boxes where I select Donor and date and would then see in a datasheet all donations for that donor on that date I assume it is based on a query Thanks