Answer Questions
Beto APP_GLOBAL
I found this object ( ) in a project file and also there were a couple of posts in the NG mentioning it briefly. I remember one of the experts said that he had never heard of it. It reminds me of a very useful object in VdBase: _app. It is a global object and you can attach anything to it to be used in any part of the program. I usually define all my queries as children of this object. Anyway the command window in VFP does not recognize it. Help ...Show All
ZmZ sending email from VFP through MS Outlook
We have the following code for sending email to Outlook. The email gets sent, but the font size is always 36 px or 36 pt (we tried both). None of the <cr><lf> show up. The email is one big paragraph. Can anyone help Here is the code: LOCAL loApp, loEmailItem, cHex lnsize = '"' + str(gaPointsize(Slcrm.nbodysize),2,0)+ '"' cHex = '' nDec = Slcrm.nColor nPower = 8 DO WHILE nPower > 0 & ...Show All
Sishir feature not found
This is the fourth inning. I am still struggling with an exec build. No luck so far. Now there is some help in the form of the error reporting authority of the error control. Unfortunately, for some strange reason only a small fraction of runtime errors are in the log file. I cannot understand why. But what I have seen so far is very revealing. The error message is "feature is not available" and the line in the source code is idenfi ...Show All
Vinod_Saastha Parameter Query
I have a date field that has the hire date for an employee. I have built a search form & I would like to be able to have users search for the hire date within a time frame. (i.e. 04/01/04 and 04/30/04). How would I do this In Access I would be able to put the "between" clause in the criteria field in the query designer. I am a newbie to VFP & have NO CLUE how to do this. I believe the syntax is the ...Show All
Ivaylo.Bratoev data duplication
If I have a table with a certian field, and in that field, there is duplicate data, How would i pull all the records with duplcate data in one field ie HERE'S WHAT I'VE GOT lastname anything tell **** soy &&&& cundo !!!!!!!!!!!! tell **** huso ^^^^^^ hydro $$$$&& cundo @@@@@@@2 HERE'S WHAT I NEED lastname anything tell **** tell **** cundo !!!!! ...Show All
CWGibbs Vfp 9.0 Report Writer.
Hello Guys Vfp9 overall is very overwhelming for guys like me who have started very small with FoxPro 2.0 for DOS. Learning VFP 5 (on my own) with no decent books and absolutely no training available and getting all these releases and not all that time to get acquainted is really difficult. One has the choice to keep themselves to what they know and then gradually grow, but seeing all these features and not working on it is again a problem. I h ...Show All
Bipin Agrawal help!!! how to show record no - recno() in grid vfp6
hi, i have tried to search a lot but i have not been able to get code how to show the recno in the grid. in browse command i could easily show tempfld=recno() i have tried thisform.grid1.column1.controlsource = recno() - this gives error thanks, gagan sachdeva_g@yahoo.com You can show calculated fields in grid too. tempfld correspond to header.caption and recno() to controlsource. ie: Public oForm oForm = Cre ...Show All
Timothy d burgess Writing our own code for the Print Button in the Report Preview toolbar VFP 9 using report listener.
Hi, I want to call my own print dialog box in the print click of the report preview toolbar in VFP 9.0 using reportlisteners. i want to disable the base class functinality and write my own functionality in the button. -Venkat You may download complete sources for ReportPreview.App and modify it as you need : http://download.microsoft.com/download/f/c/c/fcc0a8ae-56d2-4950-a70b-0e77f4720b24/VFP9SP1_XSource.exe ...Show All
Kutlu Arasl&#305; Call application from program and trace Menus and Programs within
Hello, Can anybody help me please Am trying to call an application from another, but having a problem tracing the called program's Menus and Programs. At the beginning it started by having the Encrypted checkbox automatically selected after building project and an application (the application I will be calling) while I de-check it myself. I tried creating the project from the beginning and somehow this stopped, and I could trace again, ...Show All
Tianlei html in textbox
Hi How do I open an html file inside a textbox this doesnt work thisform.veld14.Value = c:\winvis\htmlbody.htm or can I make some kind of field inside my form to load the html page in Internet Explorer ActiveX is great for viewing HTML Docs But,If you want the html code in the text box use: ...Show All
UQAM Drew Speedie Dies in Accident
The following is a re-post fromt he FoxPro Wiki about the accident that killed one of our long-standing Visual FoxPro Forum contributors and a personal friend of mine, Drew Speedie and his son, Brent, last Friday: On Friday, September 16, 2005, Drew Speedie and his son, Brent, fell a few hundred feet to their deaths from a bridge in Yellowstone Park. The Speedie family was on vacation there. Details of this tragedy are extremely limited at this ...Show All
slcy Hyperlink to launch VFP8 executable program with parameters
Hi, My client has asked me if I it's possible to start his VFP8 exe from say, a hyperlink in Word and get it to open the relevant item on a certain screen. So I need to pass a parameter to the program with the ID of the item he needs to open. I've tried various formats such as ... c:\Program Files\Company\AppName\Program.exe -001 and "c:\Program Files\Company\AppName\Program.exe -001" but I can only get the program to start and the f ...Show All
Dr Clocker Primary key + delete....
General Design Question…. Suppose I have a table (Table1) with a primary key (PKId), if a user deletes a record then wants to add a record with the same PKId value there is a Primary key violation because the table has not yet Been packed. What is the best solution to this I have Considers the Following… 1) Indexing on PKId+!deleted() , but this would only solve the problem if he delete the record once, what happens if h ...Show All
dc2k How to perform group by and order by AFTER union?
Hi, I have a SQL statement like this: SELECT * FROM ( SELECT * FROM A UNION SELECT * FROM B) GROUP BY 1, 2 ORDER BY 1, 2 Is there any way to translate it to FoxPro 2.5 compatible Thanks. Since the GROUP BY clause in a UNION belongs to the individual tables, I think the only solution, pre-VFP 9, is to use two queries in sequence. ...Show All
SandyZ GRID REFRESH
Im having problems refreshing a grid.i have placed a table in data enviroment.then i drag and dropped all of his items creating a grid.then in a button i have a select...where..into this table.this way i put new values in the table,basically i overwrite the entire table.at that time grid becomes white,no values i tried grid.refresh nothing i tried to grid.recordsource="" select where into... grin.recordsource=mytable still nothing is there ...Show All