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 GarryC

  1. GarryC

    Comms port already open

    Hi Mike, Found my problem thanks. Active sync running in the background for a long gone palm pilot and keeping the port available. Thanks.
  2. GarryC

    Comms port already open

    Hi, I am going around the twist here. Using the following I get a 'port already open' when I try to open the port. On the very next line I get a message saying 'operation is valid only when the port is open' If I try to close the port form the command line with PortOpen=.F. I get 'type...
  3. GarryC

    how do I associate file type to executable

    Thanks Bourbaki, that worked for me. The file is a self extracting .exe used to update an existing program on remote users computers. It needs to be emailed to them. The SAF extension is my own that I create by renameing the file. The reason for this is that our firewall and outlook 2002 both...
  4. GarryC

    how do I associate file type to executable

    Hi, I want to associate .saf extension to executable. In W2K I just associate the file to application type but I cant work out how to do this in 98 as there does not appear to be an appropriate MIME type. Can anybody help me out? Cheers, Garry.
  5. GarryC

    Tool to manage Outlook98 PST files?

    The only way I know to reduce .pst size is archive using manual or auto archive. Need to set auto archive under tools menu and then set properties on each folder you want to archive. If its 97 I think you have to do each folder individually, in xp you can apply changes to all folders at once.
  6. GarryC

    how do I print a text file

    Hi, I have used textmerge to create a file and append to it during the course of the application. when I finish the app I print a report and the textmerge file is a descriptive summary of the process. How can I print the textmerge document? I tried TYPE - TO PRINT but I get path not found...
  7. GarryC

    apply style to excel spreadsheet column

    Thanks AirCon. That worked.
  8. GarryC

    apply style to excel spreadsheet column

    Sorry, Back Again. Unfortunatley most of my users are still on Office 97. Still cant get the code to work oSheet.Columns("A:Q").EntireColumn.AutoFit --Works OK oSheet.Columns("A:B").Select --Works OK osheet.Cells("A1:B100").NumberFormat =...
  9. GarryC

    apply style to excel spreadsheet column

    Thanks Brian, Actually need to both so I will have a go at html as well.
  10. GarryC

    apply style to excel spreadsheet column

    Hi, Can anyone tell me how I apply a style to an excell column. ie currency to column A, percentage to column B etc.
  11. GarryC

    compile of memo string

    Thanks guys. Reports were included in exe. I love the 'execscript'. I only just upgraded from V6 to V8 and didn't realize it existed. Many thanks.
  12. GarryC

    compile of memo string

    Hi, I am storing code in a memo file. When I bring it into the running exe and compile it I still get the original .FXP file running. I checked the program file and it has the new code and the prg and fxp have same date and time. What am I doing wrong? Why isnt the new fxp recognised? I get...
  13. GarryC

    can I use 2 cursors in an sql select?

    OOPS! Feal like a bit of a idiot. Commented out code to test and accidently commented out the select that created the right side 'c_query' cursor. So 'not a table' was correct, the cursor wasn't there. Works fine now. I have used this same cursor 'in' as 'out' for years and works a treat...
  14. GarryC

    can I use 2 cursors in an sql select?

    Not quite sure if this is the answer I am looking for. I will try to clarify my question. I have a cursor 'c_query' from a previous SQL SELECT TO CURSOR c_query. I also have a cursor 'sel_div' that was created using CREATE CURSOR and then records appended from an array. Both have records...
  15. GarryC

    can I use 2 cursors in an sql select?

    Hi guys, I am using cusor 'c_query' against which I run a SELECT joined to a table, and output to the original cursor. I have a long list of these which are all run based on conditions. This works fine if the cursor is joined to a table but in the following case 'div_sel' is also a cursor...

Part and Inventory Search

Back
Top