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: Jerim65
  • Order by date
  1. Jerim65

    Fixing columns in a grid

    Hi Jockey(2)and Dan Just to explain my circumstances further - my efforts in VFP concern 2 utility applications accessing 3rd party app's tables and ini files. Both of my applications are 'complex' utilities written over the past 6 years with many reports and forms launched from a pageframe...
  2. Jerim65

    Fixing columns in a grid

    Hi Jockey(2) <Good luck lots of success and dont hesitate to aks for help with learning the Visual VFP.> Thanks for your kind words! With both of my utilities nearly 6 years old - after constant revisions I can't imagine changing the way they are structured right now. Maybe when I 'give up'...
  3. Jerim65

    Fixing columns in a grid

    Jockey2,Dan,Olaf and Mike Thanks for your kind efforts to help me. Firstly,whilst Jockey2 says I am wrong to use the method I showed above - I have to say that I got that code here and have modified the code extensively as I understand it. I am a 'beginner' of some 69years of age and have...
  4. Jerim65

    Fixing columns in a grid

    Hi Jockey2, When I say my grid is placed on a form programatically I mean that the whole code is in a prg file. Create form Create grid 1 Create grid 2 So as I don't have extensive knowledge I am not sure how to include your suggestions - 1. Add a newmethod in your gridclass ...
  5. Jerim65

    Fixing columns in a grid

    Thanks for the conversation everyone. Whilst I had tried to achieve my aim adding the code my REAL question hasn't been answered , viz <I have tried both Procedure Scrolled and Procedure AfterRowColChange but I don't know how to get them recognised in my grid.> Whilst I had tried and failed...
  6. Jerim65

    Fixing columns in a grid

    I am very keen to 'fix' the first three columns of a grid which will always display 4 columns - Y,M,D,and a Memo field. I have found thread184-1255205 but I am unsure how to get it to work. My grid is created programmaticly from a form. In the methods I have things like Procedure...
  7. Jerim65

    Creating Excel application

    Olaf, Thank you once again. To answer your points in reverse. <grid control on a form displaying the dbf makes> I have that facility with a number of options on buttons on the form and it works well. < handling xls as a table via oledb provider > I did ask how to implement this - is there a...
  8. Jerim65

    Creating Excel application

    Hi Olaf, Thanks once again for your great information. There are some givens - the 3rd party app requires N,N,N,Memo to operate it's own usage of the timeline tables (tt) internally. I have no say in that. My app initially only allowed creation of timelines from 3rd party app data - then it...
  9. Jerim65

    Creating Excel application

    After further experimentation - testing the re-import of an xls exported from my app. Instead of using the ShellExecute() function to open the spreadsheet after creating the new xls, I can give the user the same experience by leaving Excel open after creation...
  10. Jerim65

    Creating Excel application

    Olaf, Thanks for the link to the Foxite thread. Before I test it can you tell me how to install the OleDB provider such that It can be included in my Setup file I use to distribute my application. Obviously my simple 'black box' idea is fraught with difficulties - the process that I am...
  11. Jerim65

    Creating Excel application

    Mike, The new Excel worksheet was closed prior to opening via ShellExecute(). Viz [code] oExcel.ActiveWorkBook.SaveAs(myfile) oExcel.DisplayAlerts = .f. oExcel.ActiveWorkBook.Close oExcel.Quit [code] so that's not the problem. The 'append from' of the previously created xls file had no...
  12. Jerim65

    Creating Excel application

    Thanks Boris, However I am using ShellExecute(0,cAction ,tcfilenamepath,"","",1) in my application to open the spreadsheet. Further, I now find that a spreadsheet created this way is not correctly treated by the import code into a table that I have created. tcimportfile is the selected...
  13. Jerim65

    Creating Excel application

    I am using oExcel = Createobject("Excel.Application") in my application. An xls file is created but when trying to open it in Excel 2007 I get a warning that the file maybe corrupted etc. It does open correctly though when ignoring the warning. As I am automating the opening of the...
  14. Jerim65

    Memo field to Excel

    Mike, My first code line above is myevent = STRTRAN(event,'"',"''") which is the implementation of Karens method. According to her explanation this deals with the double quotes such as in the inches abbreviation say 89" and the " in my example above which is successfully managed. I get...
  15. Jerim65

    Memo field to Excel

    I have tried both methods. Both seem to have trouble where both doublequotes and commas are used as part of the memo field. As an example The party of "Croziers" is founded, under leadership of the bishop of Oslo, Nikolaus Arnesson. becomes 3 separate columns in the spreadsheet rendition of...
  16. Jerim65

    Memo field to Excel

    I am developing an app that 'plays' with timelines in tables. The 3rd party app using these tables has 4 fields - 3 numeric for date and one memo for details on that date. My app successfully allows importing and exporting of prepared timelines from/to csv or xls files. A user has noticed...
  17. Jerim65

    Saving state of open files at a point in code

    Thanks Olaf, I have added the ISEXCLUSIVE("somealias") returns .T. to my openings report and am investigation results. Coldan
  18. Jerim65

    Saving state of open files at a point in code

    Ilya, Thank you. To run my routine I use do openings adding your code to test it <code> PROCEDURE openings LOCAL lnOpenDBFs ** The array-parameter should be passed by reference: lnOpenDBFs = AUsed(@laOpenFiles) Function ATables(taDBFs)...
  19. Jerim65

    Forcing UPPER case in a text box input string

    Hi Guys, 1 I have used an Editbox on my form - possibly due to my 'learner' status which has been ongoing for a few years <G>. 2 A file selector function is not a possibility because this name has to be used to rename a table I create in my program and allow the user to determine how the table...
  20. Jerim65

    Saving state of open files at a point in code

    Ilya, Your function is very interesting and as a matter of my interest I have placed it in my app code. You show a parameter - how would I use this in my code? I have already got a procedure <code> N = Aused(laOpenFiles) Asort(laOpenFiles,2) For I= 1 To N Do Case Case '_A'$laOpenFiles(I,1)...

Part and Inventory Search

Back
Top