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!

Register Log in
  • Congratulations derfloh 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: cdms
  • Order by date
  1. cdms

    Problem with grid scroll bars

    I have a grid that is pointing at a view. As soon as I set order on the view using an IDX index the vertical scroll bar on the grid goes funny. ie. when the top record is at the top of the grid the vertical scroll bar looks as though there are lots more records above. Weird Has anyone come...
  2. cdms

    TABLEUPDATE() PROBLEM

    thanks Mike thats great
  3. cdms

    TABLEUPDATE() PROBLEM

    How can I update a table in a data environment using tableupdate() without having to select a different workarea. eg. tableupdate(site) instead of select site tableupdate() Appreciate the help Chris
  4. cdms

    Tools Options location of stored defaults

    Stewart There is a very handy tool in VFP6 where you can copy all of your Options setting to the command window. I presume it is the same for VFP7. Make sure your command window is cleared of any commands. Open the Tools Options dialog screen. Hold down the shift key and click OK. All of your...
  5. cdms

    SQL Select – Complex Query ??

    Ramani I don’t think I explained myself well enough in my first query (Sorry). There is not a code record on the person table. There is a unique identifier field that is called person_no. On the codes table the field person_no is the "MANY". On the code table there is a field called...
  6. cdms

    SQL Select – Complex Query ??

    Hi guys Just got round to testing that code and i'm having a few problems. Below is what I am writing : SELECT * ; FROM PERSON P INNER JOIN CODE C1 INNER JOIN CODE C2 ; ON PERSON.PERSON_NO = C2.PERSON_NO ; ON PERSON.PERSON_NO = C1.PERSON_NO ; INTO CURSOR CODERESULTS ; WHERE...
  7. cdms

    SQL Select – Complex Query ??

    Thanks guys I'll give it a try Chris
  8. cdms

    SQL Select – Complex Query ??

    I am using SQL select in VFP6 and I have two tables with a “One to Many” relationship. Person.dbf & Codes.dbf I want to select all the people from the person table that have both code A1 and code A2 on the code table. The problem I have is that on the Code table these two codes would be on two...
  9. cdms

    How to create office header files in VFP

    Automation can be tricky at the best of times and what starts out as a straight forward task becomes a total nightmare. You spend hours converting office macro code to VFP only to come up with an error telling you that eg. "Variable XLUNDERLINE not found". This is where header files come in...
  10. cdms

    Problem with drag and drop

    I have been using the below code to move codes from one lstbox to a another. THIS.PARENT.LSTSELECTED.ADDITEM(THIS.LIST(THIS.LISTINDEX,1)) My problem is I now want to use 2 columns in my listboxes and be able to drag and drop both columns into another 2 column listbox. Any tips would be...
  11. cdms

    How to create office header files in VFP

    Automation can be tricky at the best of times and what starts out as a straight forward task becomes a total nightmare. You spend hours converting office macro code to VFP only to come up with an error telling you that eg. "Variable XLUNDERLINE not found". This is where header files come in...
  12. cdms

    Need help from Excel Automation experts!!

    Dave Unfortunitly header files are not included in the office package BUT as it happens I do have a vfp program that helps with this problem. As I'm sure you are aware, every office product ships with a .olb file which stores all the specific commands in that program. The following code...
  13. cdms

    Report Question

    Hi Holm A public variable should do it. Simply declare your public variable. Set the variable to the various strings in your buttons and then set a text boxs expression property in the report to your variable. Hope this helps Chris
  14. cdms

    Need help from Excel Automation experts!!

    See what you think! It's fairly simple apart from the opentext() ********* EXCEL CODE START ********* #INCLUDE EXCEL9.H #DEFINE FALSE .F. #DEFINE TRUE .T. TMPSHEET = GETOBJECT('','excel.sheet') GEXCEL = TMPSHEET.APPLICATION GEXCEL.VISIBLE = .T...
  15. cdms

    Need help from Excel Automation experts!!

    I think it is the actual word array vfp doesn't like. I keep getting the error : "array.prg does not exist"????? I am using the numeric qualifier for the above commands in the 2nd parameter but I think you can do it either way. Thanks Chris
  16. cdms

    Need help from Excel Automation experts!!

    This code is from Excel 2000 when I am opening the file. It shouldn't be too different from 2002 XLSHEET.OPENTEXT FILENAME:="C:\nickhvfp\xls.auto\SPRZ.TXT", ORIGIN:= _ XLWINDOWS, STARTROW:=1, DATATYPE:=XLDELIMITED, TEXTQUALIFIER:= _ XLDOUBLEQUOTE, CONSECUTIVEDELIMITER:=FALSE...
  17. cdms

    Need help from Excel Automation experts!!

    I am trying to open a text file in Excel 2000 - (sounds easy!) BUT I need the first two columns of the file to be declared as text (I have leading zero's that I want to keep). I am recording a macro in excel and then converting the code to VFP. As I'm sure you know, some of the Excel functions...
  18. cdms

    HTML in body of an Email

    Thanks again mgagnon Unfortunitly I am dealing with about 12 pages of html from a different file that would be sent to me regularly. I think it would be far to time consuming to convert the code every time. I have an outlook.h file that I include in the form. It has lots of useful commands...
  19. cdms

    HTML in body of an Email

    Thanks again mgagnon Unfortunitly I am dealing with about 12 pages of html from a different file that would be sent to me regularly. I think it would be far to time consuming to convert the code every time. I have an outlook.h file that I include in the form. It has lots of useful commands...
  20. cdms

    HTML in body of an Email

    I have the html code in the .htm file but when I tryed your example it literally put the html string in the body ie. it didn't convert it (outlook is set to send HTML messages). Any ideas? Thanks for the help Chris

Part and Inventory Search

Back
Top