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 bkrike 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: mchoss
  • Content: Threads
  • Order by date
  1. mchoss

    Use macro variable to assign a variable value

    I have a dataset whose structure is similar to: person obs colour Dave 1 red Dave 1 green Dave 1 blue Mary 1 blue Mary 1 red Mary 2 green There could be anywhere between 1 and 13 colours for each person-obs combination i would like to transpose this to...
  2. mchoss

    Macro to change "reply to" address

    Outlook 2003 Dear all, I cannot find code that will work with outlook 2003 objects to allow me to write a macro to change the "have replies sent to" option (or the 'from' field). I want to assign the macro to a button to allow me to change the 'reply to' field at my discretion (but with a set...
  3. mchoss

    Outlook 2002 - how to change default "have replies sent to" address

    Outlook 2002 10.4219.4219 - SP2 Windows 2000 professional Version 5.0.2195 Service Pack 4 Build 2195 Hi all, Feature in question: Mail > Options > Have replies sent to Does anyone know where the registry setting that sets the default for the "have replies sent to" function in outlook - quite...
  4. mchoss

    Insert specific string into subject of message

    Outlook 2002 Hi all, I am looking for a quick and easy way of either: a - auto inserting a short string into the subject line of all new mails and replies and/or b - having a button that would perform the task (ie i need help writing a macro that would insert a short fixed string into the...
  5. mchoss

    How do i avoid having to enter WPA-PSK key when connecting?

    Win XP SP2 Using WZC to administer connections I have set up WPA-PSK security on my wireless network and can connect without issue using the key. However, having done this once, i was hoping i could have windows save this information in the network profile such that i didn't have to reenter the...
  6. mchoss

    adsl connection issues in ME - unable to set up

    Windows ME 128Mb RAM Corega EtherII PCC-T ethernet card I am trying to establish an adsl connection on a relatively old laptop running ME, and one that i cannot upgrade the OS unfortunately. The Corega ethernet card reports no errors, and Windows appears to be satisfied that it has the correct...
  7. mchoss

    Creating dummy values

    I am certain there is a simply way to do this but as yet, none of the excel functions i have looked up seem to do exactly what i am looking for: Essentially i want to create a dummy value for each string in a list according to whether it is in some subset of this list. For example ... If the...
  8. mchoss

    Crystal on Linux?

    Does anybody know if there is a version of Crystal that supports the Linux platform? Thanks in advance
  9. mchoss

    Using a component on a formless application

    VB6 Win2k I have a proprietary component i need to interact with, and i want my application to be formless. All it does it read in a command line string when called and pass this command to another application. To interact with this other app a component needs to be included in the project. If...
  10. mchoss

    Regrouping data to decrease size of dataset

    Is there a simple way using sql to achieve the following, turn: potatoes 10 carrots 7 beans 3 beef 5 lamb 4 pork 1 into: vegetables 20 meat 10 [simple example] The decode function seems limited to single values, and the group by function is not really appropriate as...
  11. mchoss

    Regrouping in excel - some equivalent to decode in sql?

    Imagine a very large dataset comprising of various items that could be grouped to make a large dataset more manageable eg, potatoes 10 carrots 7 beans 3 beef 5 lamb 4 pork 1 being turned into: vegetables 20 meat 10 - What is the best way to do this in excel? - Where can...
  12. mchoss

    Env variables - refresh ?? Command line remove?

    Win 2000 workstation 1 - I added an environment variable and my application was able to read it perfectly well. 2 - I changed the variable under system > advanced > environment variables ... and the app did not register this change, even after restarting the app. 3 - I used the SET command on...
  13. mchoss

    Env variables - refresh ?? Command line remove?

    Win 2000 workstation 1 - I added an environment variable and my application was able to read it perfectly well. 2 - I changed the variable under system > advanced > environment variables ... and the app did not register this change, even after restarting the app. 3 - I used the SET command on...
  14. mchoss

    Environment variables - refresh ?? Command line remove?

    Win 2000 workstation 1 - I added an environment variable and my application was able to read it perfectly well. 2 - I changed the variable under system > advanced > environment variables ... and the app did not register this change, even after restarting the app. 3 - I used the SET command on...
  15. mchoss

    Screen resolution change on login

    Does anyone know any free solution to having the screen resoltion change on login? I know the setting is system wide, but is there a simple way of having some script run on start up to change the resolution? Thanks in adance
  16. mchoss

    Enterprise - formatting issues

    Crystal 8.5 Enterprise 8 Win 2000 server SQL Server Has anyone ever encountered the problem whereby you format a report within Crystal perfectly well, it previews correctly, it even displays correctly through your local enterprise setup ... you then publish on a client site and many of the...
  17. mchoss

    Enterprise - formatting issues

    Crystal 8.5 Enterprise 8 Win 2000 server SQL Server Has anyone ever encountered the problem whereby you format a report within Crystal perfectly well, it previews correctly, it even displays correctly through your local enterprise setup ... you then publish on a client site and many of the...
  18. mchoss

    odbc - sql server - outer joins?

    Crystal 8.5 Enterprise 8 SQL Server 2000 Win 2000 server Does anyone know how to get outer joins to work through a SQL server ODBC connection? At present i get an error telling me they will not. Thanks in advance
  19. mchoss

    Enterprise - error detected by database dll

    Crystal 8.5 developer Crystal Enterprise 8 SQL Server 2000 Windows 2000 server I have a report with a number of left outer joins and 2 subreports. It works fine through Crystal against a database on my development machine. It also works fine through an external Enterprise web server here in the...
  20. mchoss

    Crystal Enterprise 8 - free with Developer 8.5

    Windows 2000 server SQL Server 2000 Crystal Enterprise 8 We have installed this version of enterprise on a server, and understand there to be 5 concurrent licenses available. It would appear that you can only use the 5 licenses if all 5 connections are made using the same user/password. If you...

Part and Inventory Search

Back
Top