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!

Recent content by tomkonec

  1. tomkonec

    SCO 5.0.7V licence query

    This is resolved now. I found that I simply needed to delete the temporary license (507VTMP01 from the licence manager leaving the vaild licences in place and this stopped the message.
  2. tomkonec

    SCO 5.0.7V licence query

    Using a fresh install of Open Server 5.0.7V I'm getting the following message at login: WARNING: The temporary license (507VTMP01) for this operating system will expire in less than 4 days. Please license your system as soon as possible so that bluefish will continue operating normally...
  3. tomkonec

    Remove print driver in Windows 7

    I am using Windows 7 and a HP Officejet J6410 printer connected via a USB cable. When I plug in the printer it tries to install the driver however fails. This appears to be because there are three different printer drivers for the J6410 in my copy of Windows and it tries to install the driver...
  4. tomkonec

    Manually remove a program from Program and Features

    Yes I have tried to reinstall the same version however I get the same problem as when I try to install a later version of the program. I think I just need to get rid of it from the registry somehow however cannot find where. Tried Registry Mechanic however it does not remove it
  5. tomkonec

    Manually remove a program from Program and Features

    I have an orphaned entry in Vista Program and Features (i.e. like Add/Remove Programs) and would like to get rid of it. It will not uninstall as the original MSI file is no longer available. I have tried looking for the entry in the registry however cannot find it. It is not in the same place...
  6. tomkonec

    Need to change from text to numeric

    That is superb. Thanks! And just for future reference for anyone looking at this post I made one tweak to get it perfect.. formula 3 cstr(tonumber(split({yourfield},".")[1])"#") & "." & cstr(tonumber(split({yourfield},".")[2]),"0#")
  7. tomkonec

    Need to change from text to numeric

    This formula is getting nearer --------------- formula1 tonumber(split({yourfield},".")[1]) formula2 tonumber(split({yourfield},".")[2]) --------------- However what I would really like to do is to be able to sort by the numbers with always having two digits after the dot, i.e 1.1 change to...
  8. tomkonec

    Need to change from text to numeric

    Hello I would like to sort a report by a a kind of numeric sorting via a field that is alpha in the database. Currently the field, if sorted using generic sorting shows: 1.1 1.10 1.11 1.12 1.2 1.21 1.22 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2.0 however I would like it to be sorted as follows: 1.1 1.2...
  9. tomkonec

    Repeating some rows dependant on field value

    I have the following challenge using Crystal EXAMPLE DATABASE FIELDS: Product Section No Price ----------------------------------- 6977AQR 1.10 1.16 6978ARW 1.10/2.10 0.78 6978AWD 2.2 /2.10 1.19 6979AWQ 2.10 0.98 The slash...
  10. tomkonec

    Access Oracle 9i database via Windows apps

    Thanks for advice. Do you have a link so that I download the correct device for Windows XP?
  11. tomkonec

    Access Oracle 9i database via Windows apps

    I would like to establish an ODBC connection between a Windows PC (which has no Oracle software installed) and an Oracle database in order that I can carry out queries using Microsoft Query, Crystal Reports and any other Windows based SQL query tools. The Oracle database is administered by a...
  12. tomkonec

    Insert Picture (image) turns black and white (mono)

    Solved it. Problem with the JPEG that my graphics man sorted.
  13. tomkonec

    Insert Picture (image) turns black and white (mono)

    Using Crystal Reports 10.0.0.533 When I insert a JPEG image into the header section of a Crystal Report, the colour image turns mono. I can't work out why. Any ideas?
  14. tomkonec

    Change Excel data source

    I would like to change the data source of an Excel spreadsheet to look to a different Microsoft SQL server location. I have been given this macro however it does not seem to do anything when I run it: ------------------------------------------ Sub tom() Dim qt As QueryTable Dim sNew As String...
  15. tomkonec

    SQL statement needs correcting

    I have successfully executed the following SQL statement in a Transoft U/SQL environment (on SCO Open Server using C-ISAM). ---------------------------------------------------- select sop_price_list.price_list, sop_price_list.product_code, sop_price_list.price...

Part and Inventory Search

Back
Top