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: DanCCC
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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
  4. 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
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. DanCCC

    Decimal places in Formulas

    Hey all, I have a DistinctCount function that returns a number with two decimal places. Of course, I want no decimals since this is a count. I looked in CR help and found the Round function, and changed my formula look like this: Round (DistinctCount ({CONTACT1.CONTACT}),0) But it still...
  12. DanCCC

    "Compact and Repair" saves the day

    I was getting this message after tweaking some simple queries: Record is deleted. (Error 3167) You referred to a record that you deleted or that another user in a multiuser environment deleted. Move to another record, and then try the operation again. I was locked out of much of my data...
  13. DanCCC

    Converting string to numeric

    Hey all, New to CRW but have written quite a few Access reports. I'm getting donation data from our SQL server. The donation amount is coming out as a STRING instead of numeric. I have already put in request to the programmers to change that. In the meantime, is there a function to...

Part and Inventory Search

Back
Top