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 Mike Lewis 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. 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...
  16. GarryC

    Converting .TPS Files to MS-Access or XML

    Hi Guys, After much searching found topscan at http://bluesoftware.tripod.com/ts.zip Works great for me. Garry
  17. GarryC

    storing code in memo

    Hi, Anyone know how I can store code in a memo, then retrieve it and run it. I am using OLE to create a spreadsheet and send formatted data to the spreadsheet. What I want to do is store the code ina memo so I can change it easily. Is this possible? Cheers, Garry
  18. GarryC

    Excel - Not enough memory error

    HI, I am running office 97 on W2K Pro. When I try to copy an entire workbook I get an "Not enogh memory error". This occurs even if the wookbook is completly blank with no entries in any cells of any workbook. I have removed and reinstalled office 97, Set the Paging file to 1 gig...
  19. GarryC

    passing a value without using global variable

    Thanks guys, These are all great suggestions. I though about the table idea earlier but decided against it. The reason being that this is not an intensly used app and I may decide to run off the server rather than on individual work stations. I want to keep as much located in one place to...
  20. GarryC

    passing a value without using global variable

    Thanks guys. Can you also tell me this. This application is installed on a number of machines, all pointing to a common mapped drive for data. Is the global custom class, or for that matter a global variable, affected by other users running the same application installed on their machines but...

Part and Inventory Search

Back
Top