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 strongm 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. jmcd0719

    delete from a table records with some characters not needed

    delete for at('A',upper(mydbf))>0 This will delete for any place in the filename that A is located.
  2. jmcd0719

    Grid Command Change Caption

    Thanks Mike.
  3. jmcd0719

    Grid Command Change Caption

    I have a grid with a command button in one of the columns. If the record is deleted() I want the caption to read Recall and if not delete() then Delete. Unfortunately the command button shows the same caption across all records. Is this possible. Judging by previous posts with checkbox's...
  4. jmcd0719

    Excel - How to open two workbooks?

    You could open Excel twice and use the object for each to control. loExcel1=getobject(,"Excel.Application") && create Excel object loExcel2=getobject(,"Excel.Application") && create Excel object loExcel1.Workbooks.Open("Input.xls") && Open Input workbook...
  5. jmcd0719

    Killing a process in Windows 2000 Automatically

    Thanks Baltman for the link.
  6. jmcd0719

    Killing a process in Windows 2000 Automatically

    I have a program which kills open programs automatically in Windows XP Pro with the simple command of ! Taskkill /F /IM Filename.exe This ensures I close external applications that may be open. I am trying to find a similar command in Windows 2000, but haven't found one. Thanks in advance.
  7. jmcd0719

    Outlook Express - Saving message information

    Thanks Mike, Mgagnon and Wgcs for your prompt response. I am fairly sure these will be usable. If the client upgraded up to full Outlook, is there another solution? Thanks in advance.
  8. jmcd0719

    Outlook Express - Saving message information

    We receive emails from our website each day from potential customers. The email is sent to our mailbox with 10 questions answered (Last name, first name, address, etc). The format is exactly the same, it comes from the same email address with the same subject each time. What I want to do is...
  9. jmcd0719

    Excel Automation Sort

    *The documentation on sorting a table in Excel is lacking *The syntax for using the sort object is as follows public oleapp oleapp=Createobject("excel.application") *There are 12 parameters: lkey1='oleapp.Range("a1")' && Column you want to sort lorder1=1 && 1 - Ascending 2 -...
  10. jmcd0719

    Terminal Services, Static IP, Router Setup

    I am a relative newbie to Win2k Server, so I apologize profusely in advance. We have 4 PC's (All-XP Home) and a Win2k Server. Internet --> Sprint ADSL Router -->KTI Switch --> PC'S Currently, we have a static IP address from Sprint and configured the router so that all the PC's on the network...
  11. jmcd0719

    Changing icon for GETFILE()

    You can use this command to change the fox _Screen.Icon="c:\your.ico" change c:\your.ico to the icon of your choice
  12. jmcd0719

    cell focus in grid

    You can insert this code, this will change all matching records to yellow. You can play around with the RGB Color settings to get the one you need. Change the thisform.text1.value to your textbox and database.element to the matching database field...
  13. jmcd0719

    Searching a Database?

    The Tag() function will list your index names. You can loop through and create either an array or table of tag names.
  14. jmcd0719

    Calculating straight line distances

    Here are links with formulas for calculating distances. http://www.meridianworlddata.com/Distance-Calculation.asp http://www.darkshire.org/~jhkim/programming/zipcodes/math.html http://isaac.williamsport.wa.k12.md.us/~ctrout/sciproj/MATLAB/#latlon http://www.chilidog.com/zip/zipnotes.html
  15. jmcd0719

    Automation with Citrix (Excel,Word)

    The client's computer is running Citrix Program Neighborhood 6.01.967 and Windows 2000. I have to access Excel via Citrix. However, I cannot launch excel.application or set up file relations through explorer (double click on filename) due to Excel located on the Citrix server not locally...
  16. jmcd0719

    Open Files Using Explorer

    I am using Citrix Program Neighborhood Ver 6.01.967 and Windows 2000. I can open excel, word etc through the program neighborhood file, but I want to be able to open the xls and doc files by double clicking in the explorer. When I do this it asks me what file I want to use to open it. But...
  17. jmcd0719

    expanding the year field to 4 chr.

    set filter to substr(yrfield,2,2)=space(2) replace all yrfield with left(yrfield,2)+iif(val(yrfield)<3,&quot;20&quot;,&quot;19&quot;)+substr(yrfield,1,2) set filter to
  18. jmcd0719

    Print Manager Question

    Thanks for the reply. sys(1037) also replicates your code above. This changes the printer interactively but I need to change the default printer tray/printer programmically. For example I am using an external Report Writer and I need to call the program and change the printer tray to...
  19. jmcd0719

    Print Manager Question

    I need to interact with the print manager (Win 95/98) and change trays programically so that another application can print to the proper tray and or change the default printer. This is not for an foxpro application but another application I run under foxpro. Does anyone have a quickie...
  20. jmcd0719

    DO CASE....

    Check to see if you filtered your data prior to issuing your case statement.

Part and Inventory Search

Back
Top