Recent content by Bham45

  1. B

    Novice wondering if Access is right for this project

    Of course I'm looking at the price of the entire package--and so would the parish. Don't know what you mean about waiting for a build. I've already determined I'm not going to attempt creating a db.
  2. B

    Novice wondering if Access is right for this project

    Oh boy, I just found a program that does everything our church could possibly want and then some, "Ministry Scheduler Pro." They mention every problem I deal with currently--double scheduling and even keeping families together. I will present it to the secretary on Monday to see if they are...
  3. B

    Novice wondering if Access is right for this project

    Thanks! I joined UtterAccess so I could download. Will spend some quality time studying this to see if it's usable for my purposes.
  4. B

    Novice wondering if Access is right for this project

    Mark, don't really understand about groups. There are only 2 couples that do the same job at the same time--and I already have 1 of them listed as "The Smiths." Everyone else does something different. So Mrs. Jones might do Job 1 and Mr. Jones does Job 2, but they want to be scheduled at the...
  5. B

    Novice wondering if Access is right for this project

    What I have done is list everyone--let's say all the sacristans--on one Excel page, with a blank row dividing them by service. Dates are the column headings. I use black to fill the cell when they are not available. When all the absences are filled in, I then look at the previous month or 2 to...
  6. B

    Novice wondering if Access is right for this project

    Ooh--I was searching for a ready-made scheduler that I could mess around with, but the only ones I found were for purchase by small businesses. I'll keep looking. Thanks for the tip. I'll also check out the scheduler. There are too many people involved for me to use a paper calendar. (That is...
  7. B

    Novice wondering if Access is right for this project

    Thanks Doc and Dave: you have confirmed my suspicions about the exceptions making it not worth the attempt to do this in Access. Unfortunately, I have no authority, nor any pull suggestion-wise, to change the system. I DID suggest we be more strict as a local children's hospital is with...
  8. B

    Novice wondering if Access is right for this project

    I haven't used Access in years and my logic abilities aren't what they used to be. I've volunteered to take over a scheduling job at my church, thinking I could easily make a db to handle it. But there are so many elements and exceptions, I'm not sure that it's within my abilities to create a...
  9. B

    I've got myself in a muddle

    Let me see if I can attach a screenshot of the relationships.
  10. B

    I've got myself in a muddle

    Donor/donations database: for the most part donations come from individuals, so somewhere in my db I've got "donor" equaling the Title, First Name, and Last Name. BUT now I've got some institutions donating and since the person writing the check might change but institution won't, I think in...
  11. B

    Need help adjusting a calculated field

    Things have been working well with my charitable donations database--until I discovered a problem with a calculated field "Greeting" [Title] & (" "+[Last Name]). The "Title" field has Mr., Mrs, Mr & Mrs, Ms., Miss, Rev., Rev. Mr., etc. to choose from. There's also a field "Address as" (don't...
  12. B

    Every other report is empty

    Success once again--you're the best! But can you explain to me what the difference is between the two methods?
  13. B

    Every other report is empty

    Thought I was finally ready to make a mailing to our donors but noticed that some were coming out 2 to a page. For instance, Mr. and Mrs. Smith's donation appeared on the same page as Mr. and Mrs. Jones'. So I put in a page break after the total of their donation--and now I"m getting blank...
  14. B

    Custom date format in a report

    Thank you, thank you, thank you! :D I had tried something close but not close enough. I added another m to get the full month.
  15. B

    Custom date format in a report

    This ought to be very simple, but I've been searching online for quite some time and can't find how to add today's date to a report formatted as "August 30, 2014." I can't understand why that's not one of the options when inserting a date. Sorry if this is something that has been asked...
Top Bottom