Search results

I think I understand and will try to write that, but using WHERE does not seem to work for BETWEEN Would I use WHERE ([Donation Date] Between [Donation Date]=Foms!YourFormName!YourControlName1 and [Donation Date]=Forms!YourFormName!YourControlName2)

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

Thanks. I knew it was easy and I was just MISSING it. I

I have to confess I do not know what you mean because I know so little about what I am doing :) I can make a combo box with the Combobox wizard which selects as follows: IndContacts.ContacID, IndContacts.[Last Name], IndContacts.[First Name]and in the Wizard, I can select the ContactID as the...

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

Thanks. Boy I wish I could learn the VBA commands better (I know how to run the update query first, but lotsa other stuff I want to do) :)

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

Gerry -- we need to get together -- I am trying to write a database for Three Trees to keep track of donors and donations from a main contacts table, same as you. I asked this question in this forum so if you look you will see other people answering the question probably better than me, but the...

Thanks I think it is getting close. The button did what I wanted, but you cannot actually preview the report (when the yes/no dialog pops up, all is locked until you select, so you cannot look at the reports to see if you want to print them :( (and they pulled up in Design View but print...

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

I want to do it this way so that I can search/sort my IndContacts table for just donors to create mailers. When I use the IndDonations table to create a donor list, I get multible listings for the same donor (and therefore multiple mailing lablels, copies of the report, etc.) I am sure there...

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