Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cheyenne2002
  • Content: Threads
  • Order by date
  1. cheyenne2002

    Searching for part of a field

    Is there a way to do a query that will pull out records if just one word is in the field. I have a field that contains the names of the committees a person is part of (Education, Membership). I want to pull out only those that are part of the Education, but the field contains both words...
  2. cheyenne2002

    Fax Program suggestions

    Does anyone have a suggestion for a good fax program that will run on a server? Something not too expensive. Sharon
  3. cheyenne2002

    Directory subfolder

    This is a strange question. I hope there is a way to accomplish this. My boss wants to get a listing of all the folders we have on our P: drive (from the server) and all the subfolders so that we can see what type of hireracy we have have set up. I'm hoping there is a way to do this so I...
  4. cheyenne2002

    Mail Merge problem

    I have a table with a few fields that are Yes/No which makes them True/False in the eyes of Access. When I try to use some of these fields in a mail merge I'm getting FALSE where I thought I would get nothing and TRUE where I thought I would be getting a check mark, because that is what I did...
  5. cheyenne2002

    Word Art color change?

    Does anyone know if you can change the color of the shadow in one of the word art fonts in Powerpoint? If so, how. I can't figure out how to change the shadow image of the word. I can change the foreground word okay, but not the one in the back. Thanks Sharon
  6. cheyenne2002

    sort boss' tasks by category

    I have been made delagate to the boss' tasks in Outlook. We are assigning categories to each task. Is there a way to sort by category? Thanks for the help. Sharon
  7. cheyenne2002

    Balance Due Problem

    I'm trying to create an invoice where I can add up the total donations. No problem there, so far, I think. I have the following the the subinvoice footer. =Sum([AmountOfDonation]) My problem is when I try to show a balance due. What I need to do is take the answer from the above formula...
  8. cheyenne2002

    & does not show up

    When I try to create a heading in a report the & symbol does not print. Anyone have any clue why not? Sharon
  9. cheyenne2002

    Pulling dates query

    I have an existing database (so I can't start over) and it contains a field where the members birthday was input. It is a text field and the dates are enter 9/28/1955. I need to create a query that will allow me to pull out all the September birthdays when I run the query in August so they can...
  10. cheyenne2002

    if field is null??

    If a field is null when the report prints out can I have it put in a canned statement (i.e. "If you want to become a member, give us a call.") Just an idea I was toying with Thanks Sharon
  11. cheyenne2002

    Invoice Issues

    I'm trying to create a report that will be an invoice. I am creating invoices for pledges (donations). My donors may have given us a pledge of 5,000 but they might wish to pay in increments. So I created a record for each date that they are planing on paying. I need to be able to have all...
  12. cheyenne2002

    Changing one record changes all of them

    I have a form with a combo box on it. I use it for solicitors of donations. When I click on it and choose a name it changes All the records for that donor (from previous years) to that solicitor. Can you tell me what I am doing wrong? Thanks Sharon
  13. cheyenne2002

    Form shows key field

    One of my tables has a field in it that looks up into another table to get the info. (i.e. Campaign Name). When I created a form to use for data entry into that table instead of showing me the name of the campaign I see the number that associates that field with the record in the Campaign...
  14. cheyenne2002

    Can't do data entry

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

    Repeating a group header on page 2

    When you use the group feature and group "with first detail" how can I tell the program to repeat the last header if the group goes on to a second page. Page header will not give me what I am looking for. Thank you Sharon
  16. cheyenne2002

    vlookup with an if statement

    Is it possible to do a vlookup with an if statement. My spreadsheet looks like this: Name 2003 2004 2005 John "formula" "formula" "formula" My source looks like this: Name Year Amount John 2003 45 John 2005 354 Mary 2004...
  17. cheyenne2002

    Mail Merge problem

    I need to do a mail merge with (Word) and my database. My database is a list of donations and the payments made toward those donations. I have a history of the payments and donations from 2003 thru 2006. In my letter (Word) I need to put a history of giving over the past few years. I'm...
  18. cheyenne2002

    autonumber jumped from 902 to 34737892

    I have a field which is an auto number because it is a PK. I just realized it has jumped from record 902 to 34,737,892! Is there a simple way to get it back at least to a number in the 1,000's. I'm just afraid that as I add more records that PK auto number will get way to big. Any...
  19. cheyenne2002

    Modifying Sample database ?

    I'm attempting to modify the Events database to track fundraising. My thoughts are that my attendees are my donors and the events are the campaigns. My question is, I have data from previous years that is currently in the GiftWorks program (ugh) and I want to export that data and somehow...
  20. cheyenne2002

    Linked table ?

    I am trying to create a donations database. I would like to link my existing member table and non-member table to this database, because I will be contacting members and non-members to donate to this years annual drive. My question: If I create a field in both of these linked tables that...

Part and Inventory Search

Back
Top