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 Mike Lewis 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: *

  1. DanCCC

    Excel - removing year from date values

    Dan, Worked like a charm. Probably lots of people knew the answer to this one, but you were the first. Thanks! dan
  2. DanCCC

    MS Word displays wrong date

    Hello, In MS Word 2000, when typing the name of the current month, the AutoCorrect feature goes ahead and suggests a complete date (i.e. August 30, 2004). Which is cool except when it gives yesterday's date or even two days ago. My system time and date are current. Where else would Word be...
  3. DanCCC

    Excel - removing year from date values

    Hey all, I want to publish a birthday list with all the dates in order from Jan 1 to Dec 31. My database contains entire birthdates including the year. So it sorts from oldest people to youngest. How do I extract just the day and month info (or to put it another way, discard the year info) to...
  4. DanCCC

    The Evil Undeletable Hearts

    There is no Games category in my Add/Remove Programs under WinXP. Anyone else know how to get rid of MSHearts? dan
  5. DanCCC

    The Evil Undeletable Hearts

    Aah, Games! I have been to Add/Remove Programs looking for Hearts but did not look at games. I'll go home and see if it's there. Thanks, dan
  6. DanCCC

    Can't Group Objects in Powerpoint

    Hi, Thanks for responding. But that method, if I understand you (basically using click and drag to select multiple objects), doesn't change anything. What DOES matter as I experiment further (in a completely different presentation) is that I can select and group drawing objects but not text...
  7. DanCCC

    The Evil Undeletable Hearts

    I have deleted MSHEARTS.EXE from Windows/system32 but it keeps coming back! Any ideas how to put the wooden stake through this evil program once and for all? dan
  8. DanCCC

    Can't Group Objects in Powerpoint

    Any idea why, in a normal PP presentation, I'm selecting several objects, and when I try to Group them (either by right-clicking or from the Draw menu), the Group option would be grayed out? Thanks, Dan
  9. DanCCC

    Outer Join?

    Mannga, Thanks - I am now looking at the "Visual Linking Expert" with a thing like this (I've re-named the tables to use the terms I used before): DONORS GIFTS xxx ---> xxx xxx xxx xxx xxx I right-click on this link and chose Right outer join -...
  10. DanCCC

    Outer Join?

    I'll try to be succinct here. I work in a department tracking Donors and Gifts (donations). I have a table of Donors, who are linked to a table of Gifts. Those Gifts are given to various Accounts. These Donors are assigned to Caseloads via a unique number. I represent a subset of a large...
  11. DanCCC

    Really sick Database

    Michael, Thanks for this advice. But I must admit that I don't even know what V&V refers to. I don't expect you to totally explain it to me, but can you point me in the right direction as far as on online resource? Dan
  12. DanCCC

    Really sick Database

    I wrote about this 2 weeks ago. Compact and Repair on source (linked) DB seemed to fix it. Not any more. Here's the current scoop: When trying to look at our data using simple forms, the error message "Invalid Argument" appears and #Name? appears in a bunch of the fields. We have...
  13. DanCCC

    Critical: Database Inoperable - Invalid Argument

    Hi Wayne, Well, she can see the tables fine in Table view. The query is corrupted. I had her create a new query, clicking the * to show all fields. Fine. Then she put in one criterion, Yes on a Yes/No field. "Invalid Argument" msg. came up; she clicked on it, and #Name came back...
  14. DanCCC

    Critical: Database Inoperable - Invalid Argument

    One of my users in the field has suddenly had her DB go wacky on her. It happens when she clicks on any button on a form or when trying to open a form from the database window. She can open tables. But when opening a query, she can see the information in the background, gets the "Invalid...
  15. DanCCC

    Auto-refresh Lookup Table?

    Jeremy, Wow, that's pretty cool - I might try that (but then again, given that working on this DB is not even really my job, I may just leave it simple and clunky). Thanks for sharing your knowledge. Dan
  16. DanCCC

    Auto-refresh Lookup Table?

    Bingo! It worked instantly. The gaps in my Access programming training are showing up clearly here. Thanks so much, FancyPrairie! Dan
  17. DanCCC

    Auto-refresh Lookup Table?

    Hey all, My form has a combo box referring to a LU (lookup) table. My (well-trained) users may have occasion to add a record to the LU table, so I created an "add records" button that opens a little tabular form where they can add (but not edit) a record. When they close that form...
  18. DanCCC

    Linking problems - remote users

    Hey, Yes, this is going to save me some trouble. Unfortunately the data on my local drive is old sample data, so I can write the report to give actual good data when I print it, or to give good data when my reps print it. Bummer. Anyway, thanks for jumping in. Have a good weekend all! Dan
  19. DanCCC

    Linking problems - remote users

    I'm writing reports referring to a SQL database. But for my remote users, I have to convert the data source to be a .dbf file. I have done this and changed the location to their local hard drives. There are four linked tables I have to "re-locate," and I have done that. When I...
  20. DanCCC

    Warning: Cascading Errors

    I'm producing a report listing donors alphabetically, with their name and address in the group header, and the Detail listing their contributions by date under their name. I started by creating a simple formula putting their First and Last names together, last name first, so they'd sort...

Part and Inventory Search

Back
Top