Search results for query: *

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

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

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

My applications deal with a 3rd party app's tables. To avoid any problems I CLOSE ALL when I wish to run that application from within my application. I have that working nicely BUT I would like the user to be able to continue in my application from where they were when they opened the 3rd...

I am very frustrated with the debugger as I step through my app upgrade code. The problem is when mousing over a variable the 'flyout' ( like a texttip) doesn't happen and I have to copy the variable into the watch window to see its value. Have I turned this off somehow and how can I restore...

I'm not sure whether I've ever known how to do this - I would appreciate any help. Coldan

I am introducing an 'Import' function into my app to satisfy a user request. The user wants to supply an xls spreadsheet - I have only ever imported a text file before so I am experimenting. I have created a temp.dbf with the 4 required fields - one of which is ideally a memo field. I have...

My app deals with files from a 3rd party app. I have a routine that renames tables (files) from the 3rd party app - there are many of them in a relational database. For years I have had a routine starting.. For lnFile = 1 To Adir(laFiles, '*.*') lclength = Atc('_',laFiles[m.lnFile,1])-1...

In my app I have a form which has a property of modal = .t. However when I get to this form in my program (prg) the command after the form is run straight away. I created a new form and copied the contents of the old form to it in the hope this would cure the behaviour but it did not. Under...

I am using a table created by a 3rd party application. One of the tables has an ole_object blob field which contains either a link to an external file or the contents of a file which may be an image, doc file, worksheet etc. I am able to find the file/path of a linked file and am now trying to...

I have a grid based on a table with a 'Selected' logical field. I have inserted a selection box in the field on the grid. I want a user to be able to click in selection box ( this is Ok and working) but if they change their mind how do I negate their previous selection and just show their...

I am printing a text file to a text box on a form in my app. With the possible use of UNC paths I want to ensure the long lines show in full in the text box without wrapping if within the contraints of my form width. I would like to change the font size depending on whether the longest line in...

I spoke about this in other threads but still have a problem to work out. I am converting all network paths to UNC as suggested previously. I am dealing with file paths - held in fields in 2 tables. The target path in table 1 may be expressed as - example 1...

I use a pageframe as a 'wizard' type dialogue and up to now I have the tabs hidden. Is it possible to show the tabs but make them inactive - I provide the navigational buttons in my app. Each tab is a Step and I'd like to reinforce that with the users Regards Coldan

My application may well be used with files on a NAS which are returned in UNC format. I have a table of previously used paths, some on a NAS. When I test the selection of a new path gained with getdir() I have tried both a SEEK on an indexed field (which was not possible because the path...

I get so many helpful comments here I tough I would ask if making the Report Menu Bar docked at top of report window possible? my code is currently oRepForm = Createobject("Form") With oRepForm .Caption = '' .WindowState = 2 && This will maximize the form .Icon ='mypw16_1.ico' .Name =...

Being self taught I am still somewhat of a beginner in my VFP knowledge hence lots of questions to tek-tips forum - and thanks to all who have helped me. I am recoding parts of my application and have got to the Reporting area. I only have 4 discrete reports however I need to provide for A4...

I've been 'cleaning' up my projects files and when I did a 'build' I got the error Allowed Do nesting or expression evaluation level exceeded. Can anybody give me any clues as to how to find out why I get this error? What to look for in what areas? I get no error file from this. Of course I...

I have a number of report forms in my app. I have a routine to show the report ( with Page n of n footer) with a few bells and whistles. I was copying the original *.fr* to my temp folder as myreport.*. then calling the common code. This used to work but does not now. As an alternative can I...

As I develop my app, I get variations of my prg files and forms etc where I have saved the old ones from time to time. To back up all these unused files EACH time is wasteful. Is there some code for a cleanup of the files so that only those actually in a project after a Build command are left...