Search results for query: *

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

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'...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)...

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

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)...