Answer Questions

• Dave Le excel and foxpro

  Dear friends, when exporting datas to excel from foxpro using the copy to command, there after trying to do some calculations and formating the excel file using automatation macros how could I integrate this in foxpro, I don't know where to start. thanks for explaining me the functionality satish Satish, If your calculations do not really need macros then you might create a "template" excel file with calculations on it ready and name the region that data would go into (ie: myDataIsland). Then using automation you could create a new workbook based on that template and simply place the new data into "myDataIsland". Dear Cetin, T ...Show All

• Henrik Dahl Combo in Grid with Incremental Searching

  Hi all I know we can put a combo into a grid and seen in a previous thread a link to Marcia's example on her web site ( http://www.tightlinecomputers.com/Downloads.htm ). However, whenever I put a combo into a grid, the incremental search (based on the interactive change) never works. I can post my code, but just need to know if I'm flogging a dead horse or not. Thanks Hello Peter. Peter Dorotiak wrote: Never really thought the incremental search for Combo's was any good. In the grid, you have to set the typing delay and it is poor. If didn't work very well. I would like the validation on the combo itself so it only lets you type what is in the combo. Well, if ...Show All

• guyinkalamazoo3 Not able to run foxpro exe file (urgent)

  Hi , I have a foxpro forms and reports. when i run from desktop . it is showing 'CANNOT LOCATE THE MICROSOFT VISUAL FOXPRO LIBRARY' I got these files from client. i have installed my visual studio in 'C:\Program Files\Microsoft Visual Studio' So I have to anything in my WZSETUP file , In this file they have mentioned everything. Like source and destination. i have dbf files and forms and reports in this folders. Now i am not able to my client exe file. Kindy anyone tell me the solution Thanx and Regards Selva.R Ok, I opened the Login.Fxp file (i think that is first form of the project). So i opened i started studying the whole system. FXP is nothing but a forms right..... ...Show All

• vtortola Better incremental search.

  Hi all; I am looking for an example of how to do a better incremental search than just using a combo box. I need the search to: - Allow back space. - Not be limited time (The user shoudn't type fast in order to search) - Show the entry being picked as I type. Any one can give me a direction, or an example Thanks. I created a Quicken-type combo years ago. It's in the session notes on my website. http://www.tomorrowssolutionsllc.com/session_materials.htm Look in the Developing Applications for Everyone session. Tamar Have you looked in the samples that ship with VFP I believe there's an incremental search combobox in there. ...Show All

• Brian Kramer Display marked records for deletion using SELECT statement

  Hi to all, I have a table T where all of the records are marked for deletion everytime the table is uploaded with new records. When issuing the BROWSE command the records are displayed but with SELECT command no records are displayed. I want the records to be displayed using the SELECT command. Is this possible and how Actually I have a web page in asp connected to the table T. And i want the records to be displayed there. Thanks ODBC: Deleted = yes OLEDB (preferred): set deleted off <% cSQLSelect = "select cust_id,company,contact," & _ "iif(deleted(),'Deleted',space(len('Deleted'))) as DelStat from customer" ...Show All

• tody4 SCAN statement help

  can anyone see anything wrong with this SCAN statement The compiler says theres a Nesting error b/c (im guessing) that it sees ENDSCAN but doesn't recognize the SCAN statement like it should. SCAN WHILE VarSono $ sotran.sono AND ln_counter < 50 ; FOR sotran.qtyord <> 0 ; AND sotran.qtyshp = 0 ; AND NOT RTRIM(sotran.item) == "INSURANCE" ; AND NOT LEFT(sotran.item, 5) = "SHIP_" ; AND NOT sotran.sostat = "X" This is just a command line. Look at the block itself. Generally beautify indentation helps you to sort out where nesting error is. If you still suspect this is it then: Comment the line all together and put scan alone (with a test data of cours ...Show All

• jiangtao.liu Where can I get CodeMine 7.1 or later

  Hello all, I am looking for CodeMine 7.1 or later. Where Can I get it Is it free Or can I get for free That is not a technical question. Go to CodeMine directly for sales info. http://www.codemine.com/ click on the Ordering Information link. ...Show All

• Petchey Urgent please: how to filter, copy and paste rows with Excel?

  I have this Macro that really does exactly what I need, but I don't know how to convert it in my VFP program using DOM. I want to filter the rows with "*" in my column "D" and then copy and paste the rows to ANOTHER workbook. Here is the Macro: Range("A1").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.AutoFilter Field:=4, Criteria1:="~*" Selection.EntireColumn.Hidden = False Selection.Copy Workbooks.Add Template:= "c:\templates\mytemplate.xlt" Windows("MyExcelWorkbook").Activate ActiveSheet.Paste thank you in advance! Karl After instantiating Excel to oExcel, and the cu ...Show All

• TJT what do you do if a dll is corrupt?

  What do you do if an application fails and an error message is that an "entry point for a procedure is not found." You then go find the appropriate DLL file and try to register it and the registration fails and the message is that it does not appear to be a valid DLL file at all. I am talking about DNSAPI.DLL in this case but it appears to be a frequent problem and I want to know what one can do about it. What is the protocol That dll appears to be in 3 different incarnations in my computer, on two different partitions, the latest version is from May 2005. They all failed. Any advice will be much appreciated. Thanks. Alexx, >"entry point for a procedure is not found." Usually means you've sp ...Show All

• grunger Form Calling Report - Can Form Variables print on report?

  I have a form where users input a due date and comments into two fields. The users then click on a "Run Report" button that issues "REPORT FORM REPORTS/PD_LETTER TO PRINTER for next_due < THISFORM.p_date.value" command to print the report. Is there any way I can use the values the user entered in the form fields in the report that is generated. The form is a past due letter and I want to print Due Date and comment field from the form on it. On the report I created Variables that have the same names as the fields on the form, but this did not help. I suspect that I'm making this much more difficult then needed... Any ideas Derek You don't need any variables for that. You can directly use form fields in your report as you do in a ...Show All

• Jeff Putz Set printer to NAME

  Hi; I am using "Set printer to NAME getprinter()" to select a printer. I also have tried "Set printer to name \\somePC\someprinter" In both cases an error is produced. "Error accessing print spooler" The network is a win2003 server with both XP pro and Win98 stations. The printer is on a win98 station. I was wondering if I should use "set printer to \\somePc\somePrinter" without the NAME clause Thanks. Here's what I have found: "Name" requires that the network printer will be added as a printer on the local machine. set printer to \\machine\printer however doesn't require one to be installed. Nowhere in the V ...Show All

• AlexReg Display marked records for deletion using SELECT statement

  Hi to all, I have a table T where all of the records are marked for deletion everytime the table is uploaded with new records. When issuing the BROWSE command the records are displayed but with SELECT command no records are displayed. I want the records to be displayed using the SELECT command. Is this possible and how Actually I have a web page in asp connected to the table T. And i want the records to be displayed there. Thanks <% cSQLSelect = "select cust_id,company,contact," & _ "iif(deleted(),'Deleted',space(len('Deleted'))) as DelStat from customer" dbpath = Server.MapPath("data") set oConnection = Server.CreateObject( "adodb.connecti ...Show All

• mekab How to change assigned class libraries.

  Hi; I have often backed up my working folder to seperate sub folders like 'backup' etc. I have just noticed that in my project the class lib for some of the classes is the class lib in the backup folders. I am not sure how this happened. Is there a way to reassign all existing classes and objects so they use the one in my development folder Thx. Alenko, It's entirely possible too though that your forms and classes contain references to these backup classes. After you make adequate additional backups of everything. You can USE TheForm.SCX and repair the ClassLoc field with a REPLACE ClassLoc with strtran( ClassLoc, "\backup", "" ). Issue a COMPILE FORM The ...Show All

• Leonard Lee Sequential Transaction Number

  I'm working on a form that needs to have a sequential transaction number. I have a Database/Table (named Trans) in place that has a single record that holds the next transaction number. I'm not sure what the best way is to have the next transaction number appear in a field on my form. Right now I have a field named T_TRANSNUM that has it's data property set to w_trans.t_transnum. t_transnum is the name of the database field where I want the transaction number stored when the form is saved. In the INIT method of T_TRANSNUM I have the following: STORE 0 TO T_VALUE SELECT TRANS GOTO 1 STORE trans.trans_num to T_VALUE REPLACE trans.trans_num with T_VALUE + 1 this.value = T_value What is happening is that the value is displayed in the form, but ...Show All

• venp primary key?

  How do u auto increment a primary key in vfp thanx for da help You just INSERT into the table and it happens automatically. For example here's a chunk of code that creates a database of my Windows Media Player music library. close databases all create database c:\temp\musiclib create table c:\temp\band ( iBand i autoinc, cBand c(60) ) create table c:\temp\album ( iAlbum i autoinc, iBand i, cTitle c(80), dAdded d, cGuid c(38), iYear i ) create table c:\temp\songs ( iSong i autoinc, iAlbum i, cTitle c(128), iLength i ) set safety off lcRootPath = "C:\Documents and Settings\David\My Documents\My Music\" lnBands = adir( laBands, lcRootPath + "*.*&quo ...Show All