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 wOOdy-Soft 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: stancer
  • Content: Threads
  • Order by date
  1. stancer

    XP and Office 2000

    I just got a new computer with XP Pro, Service Pack 2, and was wondering if I can install Office 2000 without issues. Are there any problems I'm likely to encounter? Thanks in advance!
  2. stancer

    Count array values

    Platform: CR 9 on WIN2K reading an Access database. Question: I've created a standard report and want to display a count of values for one field in the footer. The field (PREMISES in table 1 CRIME) can contain any string value, i.e., ALLEY, STREET, PARKING LOT, etc. The string values are not...
  3. stancer

    Is a photo placeholder possible

    Two questions... I've created a form with a one cell table on the left portion of the page containing fill-in text boxes, and a frame to the right of the table where a mugshot photo is placed. As it stands now, the form must be unlocked in order to replace the photo, then locked again to fill in...
  4. stancer

    Odd error on opening report...

    I have a report which I develop and then share with other users in the same department. I design the report and then ship it to the other users via e-mail. Upon receiving the report, the database is verified prior to print previewing or refreshing the report. It's then when things get a bit...
  5. stancer

    Monthly Hot Fix installation...

    Quick question that I can't seem to find the answer to on the CrystalDecisions web site: Does anyone know if admin rights are required to install a hot fix? I'm operating on Win2K, SP3. Thanks in advance! :-)
  6. stancer

    Shading a group based on record criteria

    I have an Crystal Report (v8.5) reading an Access 2000 database, table name = tbl_DSPTIME. The table contains data pertaining to fire emergency calls, which we use to determine if we are meeting standards on-scene times. Each EVENT may contain one or more records depending on the number of units...
  7. stancer

    Extract month and day from date field...

    I have an Access database containing a Birthdate field, a DateTime field formatted as mm/dd/yyyy. I want to extract the day and month portion of the Birthdate field and add them to the current year, e.g., if a person was born on 03/13/1952, I would want a date of 03/13/2003 or 03/13/2004, etc...
  8. stancer

    Concatenating Multiple String Fields

    I have an Access 2000 database that I am reporting on via an ODBC connection. In the report I want to concatenate 6 string fields comprising the description of a person: Sex | Race | Height | Weight | Hair | Eyes where 1 or more of the fields have no data. I started by using a formula like...

Part and Inventory Search

Back
Top