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 Wanet Telecoms Ltd 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. cousinconley

    Best Fortress LI660VA Blinking Display and No Power

    I have an old Best Fortress UPS. When I plug the unit into the electical outlet, the digital display and sensor lights blink repeatedly for roughly 30 seconds then it shuts off. There is nothing legible on the display. It starts with all 0's then every pixel illuminates. I left it plugged in...
  2. cousinconley

    Selecting next to maximum record

    Heres the scenario...I have a table with effective dated records. This means employee 123 can have multiple records all identified by a date. Example: employee 123 gets a pay raise on 01-29-2006. Employee 123 then gets another raise 08-30-2006. Later employee 123 gets yet another raise...
  3. cousinconley

    CR 10 - watermark interferes with box

    I have detail data that I have drawn a box around. I have set my watermark on Page Header B with "Underlay Following Sections" checked in Page Header B. I made sure the graphics are set to background not forground. When I run my report the watermark functions correctly except for the lines...
  4. cousinconley

    Crystal 8.5 grouping puzzle with 8 attributes

    Ok, I have a record. Each record has 8 attributes that are either true or false. A record can have multiple attributes that are true. So, how do I group by the true attributes and have a record print multiple times...once under each attribute grouping? This is what I have so far: SELECT 'Y'...
  5. cousinconley

    Crystal Reports 8.5 first day of year function

    I am trying to figure out how to do a datediff calculation using a persons birthdate and first day of the year. I do not want to hardcode 01/01/2006. If I hardcoded I would have to update the report formula every year. This is what I have so far: numbervar Age:=...
  6. cousinconley

    Microsoft Word 2000 page numbering starting on 4th page

    I am creating a document in MS Word 2000. I would like the page numbering to begin with 1 on the 4th page. The pages prior to the 4th page are just front matter. I would like the front matter to be numbered using Roman numerals. So the 1st thru 3rd pages would be I, II, III and the 4th page...
  7. cousinconley

    False duplicate key error

    I am inserting records from a temp table (PS_PROJ_RES_TMP) to a main table (PS_PROJ_RESOURCE) in MS SQL Server 2000. I am consistantly getting the message: The insert failed: Server: Msg 2601, Level 14, State 3, Line 1 Cannot insert duplicate key row in object 'PS_PROJ_RESOURCE' with unique...
  8. cousinconley

    autonumbering existing records through SQL update

    I have an existing table with records. A new field was added through a table alter. This field is a new id field to uniquely identify records. Someone previously had created this table but used a couple of text fields for keys. I added a numberic field where all the values in it currently...
  9. cousinconley

    Populating a form field based on another field value

    I have a Microsoft Access 2000 database and form. The form writes to a Transaction table. The form has a drop down list that pulls an employee number from an Employee table. I have a field for employee name I would like to populate based on the employee number. Here is what I am trying to...
  10. cousinconley

    Sending email message from dos batch file

    If its possible, what is the command line syntax for sending an email message from DOS? We run an Outlook 2000 server for email. What I am trying to do is setup a batch like: IF NOT ERRORLEVEL 0 'Email dl-Administrator' Any assistance is appreciated. Thanks, Richard
  11. cousinconley

    I need an IBM DB2 ODBC Driver

    Where can I find or purchase an IBM DB2 ODBC Driver? I have created a Microsoft SQL Server DTS package to retrieve data from a small DB2 database table into a SQL Server table. We have installed one copy of an IBM DB2 DBMS and when done it installs your ODBC and configurator. Rather than...
  12. cousinconley

    Canon Scangear 'IP address outside the subnet cannot be specified'

    I am using a program that works with our Canon Imagerunner 3300. The program I am using is called Nettools Scangear 1.3. When I go to enter the IP address of the printer, 10.2.10.54, I get a message saying "IP address outside the subnet cannot be specified". Yet, I can ping that IP from the...
  13. cousinconley

    GLORY CPS 9700 System

    Does anyone have technical experience with Glory CPS9700 Casino (Y/N)? Thanks, Richard
  14. cousinconley

    Micros 9700 HMS ODBC?

    Is there an ODBC or other way to SQL into the Micros 9700 HMS? I would like to extract information or even update if possible via SQL. All the adds for Micros say its SQL compliant but have found very little info on this subject. Thanks, Richard
  15. cousinconley

    MICR Printing HP 4300 ... Just a printer and MICR toner?

    Many companies sell an HP4300 MICR printers for around $3000 plus. I am wondering if this is just an HP4300 with a MICR toner or is there more to it than that? Please help. Richard
  16. cousinconley

    Getting "Invalid Arguement" while importing a table into Access

    I am trying to import a table from our accounting system into Access 2000. I do this everyday from the same data file in our accounting system for reporting purpose. Today I tried it, as my daily routine, and am getting an "Invalid Arguement" while in the importing process. Any...
  17. cousinconley

    How do I set my macro to run every 15 minutes?

    I have a macro in Access, say macro1, that copies data and sends it to an Excel file. I have a second macro, say macro2, that runs macro1 repeadily. What command do I use to have macro2 run macro1 every 15 minutes?
  18. cousinconley

    Dynamic Data Exchange (DDE) to send info to Access 2000 Reference

    I need a good reference book on DDE to send data from an application to an MS Access 2000 database. I am working with MAS200 accounting system and it has a script tool to write a DDE script to send info to a MS Office application (ie Word, Excel, Access). Any suggestions?
  19. cousinconley

    MAS Customizer, MS Access, DDE script

    Anyone know of a good reference book on DDE script? I am creating a script in Customizer to send data from a data entry form to MS Access 2000. Thanks........
  20. cousinconley

    Trouble totaling a formula field

    Can someone tell me why I cannot run a total on the following formula: stringvar PUNCHIN:={TC1_TimecardMastefile.TimePunchedIn}; stringvar PUNCHOUT:={TC1_TimecardMastefile.TimePunchedOut}; IF GroupName ({@SHIFT})="7AM TO 3PM" AND PUNCHOUT > "15.00" THEN VAL(PUNCHIN) -...

Part and Inventory Search

Back
Top