Page Break in Excel

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Messgebox on top? (VFP7) I need to force a messagebox to appear on top of other whidows. The messagebox is run using execscript, which is called from an EXE com server. When running the messagebox command the box appears under other windows. How can I force it to appear on top? Tag: Page Break in Excel Tag: 219125
  - 2
    - seek(), set exact off, upper(), lower() Hi, How can I seek() in a table without taking care of the upper lower status of the seeked value? So if I seek a value "t" it should go to "Trailer" or "trailer". is this possible ? regards christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- Tag: Page Break in Excel Tag: 219114
  - 3
    - [crystal report] Export to Excel I found that the exported Excel spreadsheet's page break happened too late (about 10 rows). If the Excel spreadsheet is to follow the Crystal Report's pagination, its page layout has to be scaled to 85%. Is there extra option in Crystal Report related to this? -- .~. Might, Courage, Vision. Sincerity. http://www.linux-sxs.org / v \ /( _ )\ (Fedora Core 4) Linux 2.6.14-1.1644_FC4 ^ ^ 15:43:01 up 8 days 3:19 load average: 0.00 0.02 0.11 Tag: Page Break in Excel Tag: 219112
  - 4
    - Making a Control Sizeable .. How can I make a Control Sizable at run-time ? like I have a form with an activeX control and couple of browse windows, the client wants a way out to resize all of them during the run-time - with the mouse obviously. Any idea about how can I achieve this ? Tag: Page Break in Excel Tag: 219105
  - 5
    - dbf problem I get the following error when trying to add a field in a table by either doing a "modi stru" or the "alter table" command. "No update tables are specified. Use the tables property of the cursor object." This has happened after an abnormal shutdown. I have tried doing a tableupdate and tablerevert but that does not make a difference. Validate database command does not find anything wrong. I can alter existing fields with no problem, but can't add new ones. There are only 124 fields in the table. Has anyone encountered this before ? TIA Sujata Tag: Page Break in Excel Tag: 219093
  - 6
    - Anyone with a command reference... I need the @ get command syntax for a list. @ get x,y get func " <what goes here> List item 1; list item 2; list item 3" Please help. No help module and no command reference at any local book store. Tag: Page Break in Excel Tag: 219086
  - 7
    - Print Business Cards as Labels I have a request to add business cards to a database. The client has a hand scanner that scans the cards and brings them in as .CDB files. He wants me to be able to print out these business cards like you would print out mailing labels. I have to find a way to convert these .CDB files to JPEG. What would be the best way to enter these cards into a database and print them out or can I just put them in a folder and print the business cards as labels from the folder??? DO I have to enter them into the database as each card will have a file name that is the phone number field name like 1234567890.JPG if I come up with a way to convert them to JPG. Thinking of using general fields or pointers??? TonySper Tag: Page Break in Excel Tag: 219082
  - 8
    - select question Hello, I am using FoxPro 9.0. I am trying to acheive the following. I can not seem to get the right clauses. Can someone help me please!!! Thank you for any efforts in advance. Here is the psuedo table: Invo num LIne num Service 100 0 A 100 1 B 100 2 C 101 0 A 101 1 B Can I say group by inoice num, but only take the largest Line num? So that I can get: 100 2 C 101 1 B Emily Tag: Page Break in Excel Tag: 219075
  - 9
    - fonts in menus Hello! In VFP 9 it is possible to use fonts in menus with the new FONT parameter in the DEFINE PAD and DEFINE BAR commands. This is a great feature, but it doesn´t work. If I lokk into the VFP9 helpfile I find this text: "The FONT clause is ignored for menu titles added to the Visual FoxPro system menu _MSYSMENU. Note that the Menu Designer uses the Visual FoxPro system menu." How can I use the font feature? I thought I must use the _MSYSMENU! Thanks. Andreas Lammert Tag: Page Break in Excel Tag: 219073
  - 10
    - "File is in use" - but I have a record lock! I got this error from one of my users. In the code below I am applying manual record locks, and I would assume that it would protect the code from another user attempting a header lock but they got a "File is in use" on the gather memo... This runs in a high speed environment and I cannot rely on the default Foxpro locking mechanisms. Should I apply another test prior to writing the values back to the table, and what would that test be if rlock() was already succesful? nLock = 0 do while nLock < 100 if rlock() nLock = 0 exit else sleep(50 + int(rand() * 100)) nLock = nLock + 1 endif enddo if nLock = 0 scatter memo name oTrack * .... do stuff with the variables * got a "file is in use.." error even though rlock() had been applied. gather memo name oTrack Unlock endif Tag: Page Break in Excel Tag: 219040
  - 11
    - Rounded shapes on report not round I have a very strange situation. I have a report. I have rounded rectangle on report. I set curvature to 24. If I suspend the app and preview report, it previews with the rectangle square. If I preview the same report outside of the app, ie start VFP, open table, preview report, it looks rounded as expected. Something in the environment is causing this, but I have not yet found what. Anyone seen this before? Tag: Page Break in Excel Tag: 219034
  - 12
    - File access denied Hi, What command will close (free up) a text file that was created with "SET DEVI TO FILE" command? When try to open it by using "MODI FILE" the error "File access denied." prevent it for opening for viewing. Thanks Tag: Page Break in Excel Tag: 219021
  - 13
    - need a set of new eyes please. i am trying to match one record from the first file to one in the second. when a match i found, i need to see if any of the second file matches meet the long 'if', if they do not i want to place a .f. in the first file. i can tell why its not right, i just know it isnt working properly. Tom USE c:\testdata\lopdptfl IN 0 SHARED ORDER TAG agdept2 ALIAS lopdptfl USE c:\testdata\fulopmas IN 0 SHARED ORDER TAG agdept2 ALIAS fulopmas USE c:\testdata\checkhdr IN 0 SHARED SELECT lopdptfl GO TOP scan REPLACE ALL ACTIVE WITH .T. bkey = (PADL(city,6,"0")+PADL(dept,3,"0")) SELECT fulopmas DO WHILE .T. IF EOF() EXIT ENDIF IF (PADL(fulopmas.agency,6,"0")+PADL(fulopmas.dpt,3,"0")=(bkey) and (fulopmas.iactcode<>"T" AND fulopmas.iactcode<>"D"); OR (fulopmas.iactcode="T") AND (fulopmas.termcd < 60 AND !INLIST(fulopmas.termcd,30,31,50,20,51)) OR ((fulopmas.termcd >= 60; AND fulopmas.termcd<>98) AND fulopmas.RETWAGES <> 0) OR (fulopmas.termcd=98) OR (fulopmas.termcd=30 AND; MONTH(fulopmas.dtref)=MONTH(checkhdr.procdate) AND YEAR(fulopmas.dtref)=YEAR(checkhdr.procdate); AND fulopmas.currwg <> 0)) SKIP loop ENDIF replace lopdptfl.ACTIVE with .F. ENDDO endscan *!* select lopdptfl *!* set order to dept *!* report form c:\testdata\inactivedpts.frx to printer for lopdptfl.active=.F. noconsole *!* close data Tag: Page Break in Excel Tag: 219000
  - 14
    - A way to determine .. I am using an ActiveX control which does not provide any thing to trap RightClick - of the Mouse - is there any other way to figure out it ? the usual Click and DblClick events are in place. Tag: Page Break in Excel Tag: 218997
  - 15
    - How to set up a spell checker for FoxPro memo fields I have a FoxPro/VFP application with text entries in memo fields. How can I set up spell checking in the memo fields accessible when viewing the field? This app works in 2.6 and VFP, but if this can only be done for VFP, that's fine. Thanks. Dan Tag: Page Break in Excel Tag: 218987
  - 16
    - Dot prompt replacement program Hi, A while ago some kind person recommended a dot prompt type program. My machine has been attacked by the Borg (something do do with hives, nasty itchy things) and I lost it (along with everything else!), only use it occasionally and can't remember what it was called, can anyone assist? thanks Steve Tag: Page Break in Excel Tag: 218983
  - 17
    - sms modem string This is a multi-part message in MIME format. ------=_NextPart_000_0026_01C5FAB0.E2BAD3D0 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: quoted-printable Hi, What is the SMS(Short Message) modem string to send to GSM modem on pc = from VFP app ? Regards Hoe ------=_NextPart_000_0026_01C5FAB0.E2BAD3D0 Content-Type: text/html; charset="windows-874" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dwindows-874"> <META content=3D"MSHTML 6.00.2900.2769" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>What is the SMS(Short Message) modem = string to send=20 to GSM modem on pc from VFP app ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Hoe</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0026_01C5FAB0.E2BAD3D0-- Tag: Page Break in Excel Tag: 218979
  - 18
    - Help Me - How to convert PDF into Document with FoxPro? Hello, I have a PDF file with rich of texts and tables. I want to edit and want to reduce the pages as to reduce the cost to Paper during print. I heard from someone that there is a command in Foxpro to do the same. Is it possible in FOXPro? How to do it ? If it is not possible , Please tell me other alternative Help me! Thanks Kunal Mehta Tag: Page Break in Excel Tag: 218966
  - 19
    - [crystal report] passing parameter from VFP to CR In http://www.craigberntson.com/Articles/kb014.htm, section "parameters fields". * Get the Special Message Parameter ocParm = oRpt.ParameterFields() oParm = ocParm.Item(1) oParm.SetCurrentValue("This is the runtime special message") How was the parameter field "Item(1)" created in CR? A regular text object? Is there a way to address the field by name (something like Item["name"])? -- .~. Might, Courage, Vision. Sincerity. http://www.linux-sxs.org / v \ /( _ )\ (Fedora Core 4) Linux 2.6.14-1.1644_FC4 ^ ^ 14:11:01 up 6 days 1:47 load average: 0.03 0.03 0.00 Tag: Page Break in Excel Tag: 218964
  - 20
    - Medai Player 10 Mute? Have two wmp10 players embedded on form but need a way to mute one of them. I see by searching on the web that older media players had a mute property (as well as volume) but I cannot see any reference to mute for wmp10. Thanks in advance. Tag: Page Break in Excel Tag: 218961
  - 21
    - Alternative to ADIR() functions I am using the ADIR function to read the names of all picture files in a particular folder into an array. I then append the names in the array into a table. One of the users has more than 15000 files in their folder and get an error message when the program reaches the line of code containing the ADIR function. Does any one know an alternative way of getting file names into a table ? I have tried using RUN DIR >> X.TXT, but any file names greater than 8 characters are truncated. This doesn't happen when I actually use the DIR command in a DOS window. Commands like DIRECTORY and DISPLAY FILES, don't seem to create a file in a format that can be imported into a dbf. Although I might have to work with those if there is no other go. Any ideas ? TIA Sujata Tag: Page Break in Excel Tag: 218959
  - 22
    - Shortest route to VFP My bank exports statements in MSMoney or Quick Books format. Which format is easier to convert to VFP & how to do it... -Lew Tag: Page Break in Excel Tag: 218952
  - 23
    - Displaing results in a window I can't use a report designer because fields positions needs to change in code, so I want to display the report in a window. Doing that, the results are overlaping regardless the windows dimmension (if the report is longer than the number of lines /screen, starts overlaping.). Any imput or maybe other solution for displaing a report in a window not using the report designer (so the user can also scrool up and down, left to right )? Thanks Tag: Page Break in Excel Tag: 218950
  - 24
    - VFP Development Needed I have a VFP 6.0 app that I need development help with. From what I have been told, I'm better off going to Ukraine to get .net development help. Do you disagree? Can you help me? -- Thank You, Louis A.Sorbera CRM Systems - LabTrak www.LabTrak.net Direct 813-909-7149 eFax 425-696-1174 LabTrak...because in healthcare, it's a life that can get lost in the shuffle (tm) Tag: Page Break in Excel Tag: 218949
  - 25
    - Warning: The key defined by the KeyField property for table "alias" is not unique (Error 1495) I get the following error: Warning: The key defined by the KeyField property for table "alias" is not unique (Error 1495) The key specified for this table changed more than one row in the base table for some of the remote view rows being updated. Redefine the key using the KeyField view property Can someone direct me to documentation that might explain what this error means. The Microsoft documentation (above) is not helpful to me. -- Thank You, Louis Tag: Page Break in Excel Tag: 218944
- Next
  - 1
    - Mangled font in Foxpro I use the Terminal font in size 14 to get a nice and readable fixed pitch font sometimes, on some pc's the font gets screwed up , but it's only apparent in VFP. Using the terminal font in notepad for example it still displays correctly. anyone else has seen this problem or know how to fix it?. This is not a TrueType font and is not visible in the Control Panel with the other fonts. Tag: Page Break in Excel Tag: 218942
  - 2
    - Quick question Please remind em ( I am without Command Reference ) how to manually code an @ Get for a in form pull down list. example ... store 1 to tchoice @ 10,10 get tchoice func "option 1;option2;option3" (when the use gets to this field, a drop down list appears) Thanks for your help. Jon Tag: Page Break in Excel Tag: 218941
  - 3
    - filtered records not shown correctly in a grid aftger grid has got focus Hi there, when calling the customers list function in my foxpro application I get all records from my MySQL database (customer's table) via ODBC. Then I call a form which has a grid controlling id an name fields of the customer table. A text field is used to filter records by name. If you enter something in that field, I am doing a SET FILTER to OCCURS(UPPER(thisform.searchword), UPPER(customer.name)) > 0 GO top in customer thisform.grid_wa.refresh() Everything works fine until the grid gets the focus after entering the search information. After getting the focus only one (instead of three found) record is shown, it is alwas the first one in the list. If I do a "thisform.grid_wa.setfocus()" instead of the refresh, nothing at all is shown. Doing a SET FILTER to OCCURS("Miller", UPPER(customer.name)) > 0 instead of using the thisform.serachword variable works without problem so I guess there is something wrong with the SET FILTER and using variables? I am using VFP8 on W2k english. Thanks in advance Andi Tag: Page Break in Excel Tag: 218933
  - 4
    - Press Windows Key twice from within VFP using API I would like to send keys to the system to press the windows keys twice from within VFP. This should be able to be done using something similiar to: DEFINE VK_LWIN = 0 && H5B ? DEFINE KEYEVENTF_KEYUP = 2097152 && H2 DECLARE keybd_event IN Win32API ; SHORT bVk, SHORT bScan, INTEGER dwFlags, INTEGER deExtraInfo keybd_event(VK_LWIN,0,KEYEVENTF_KEYUP,0) keybd_event(VK_LWIN,0,KEYEVENTF_KEYUP,0)Has anyone done this before? Am I on the right track? I know VK_LWIN should be H5B (well, I'm pretty sure anyway). TIA, Tracy Tag: Page Break in Excel Tag: 218925
  - 5
    - VFP 9 - Chain reports? Can someone give me an idea as to what this really means? Maybe I should just state what it is that I'm trying to do, and see if VFP 9 will allow me to do it. I have several reports that make up a "final" report that we send to our customers. I've purchased FRX2ANY for VFP, and right now I run each report individually, outputting each to a separate PDF file. I then append each one where needed using Acrobat. Will the report "chaining" allow me to set it up so all reports "run", then are output to a PDF? Basically turning what now can be as many as 30 individual runs, into one? Thanks! Shawn Tag: Page Break in Excel Tag: 218923
  - 6
    - Task manager Memory usage Dear all, I've got a small utility running which processes 1000s of records and a number of tables. This is kinda a scheduled task. Its been optimized over and over again... However, i've noticed taht the process runs faster when the application is right on top. I.e. the applicationo is the main app (which has focus). If how ever i give focus to another app, by opening note pad, or an email, or IE, then my VFP app process the information slower (i confirmed this by checking the number of records processed). Also, i found that the memory consumption in Task Manager goes up when my VPF app is on top, and when my VFP app is NOT visible then it goes down (hence slows). How can I hack this, and give priority to my VFP app, or give it more resources? Or is this something that the Windows OS will decide? (right now, it seems so). Tag: Page Break in Excel Tag: 218912
  - 7
    - I have a problem to solve... Presumming we have a table in visual foxpro, which has two fields, named: no1 of numeric type,which contains a number of maximum 2 digits, no2 identical with the first filed. The demand is to find out the minimum set of digits with the following property: from every row from the table, at least one of the two fields is contained in the set.... For example : first row: | 1 | 2 | second row: | 1 | 3 | ........ | 2 | 5 | ........ | 2 | 6 | for this example, the minimum set is: { 1, 2 } Another example : | 3 | 2 | | 5 | 6 | | 1 | 2 | | 2 | 3 | | 1 | 6 | | 2 | 5 | | 1 | 8 | for the example above, the minimum set is : ( 1,2,6, } or { 2,6,8 } or { 1,2,5 } Can someone solve this problem in visual foxpro? -- infstud ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Page Break in Excel Tag: 218911
  - 8
    - VFP 6.0 & ODBC As a part of a test, I try to access VFP Tables through ODBC. Here is what I do: o I create a System DSN using "Microsoft Visual ForPro Driver" 2.00.8167.00, VFPODBC.DLL o Set the Data Source Name as "mailw" o Set the Database Type as Visual FoxPro database (.DBC) o and the path as: "c:\MyApps\Mailw2000\mailw2000.dbc" Trying: SQLConnect("mailw") I get -1 (failure) If instead, I create the same as above, using "Free table directory" instead of .DBC and set the pasth to: "c:\MyApps\Mailw2000" SQLConnect("mailw") returns a conection handler. But truing to select data from existing table in the directory, I get -1 again. h=SQLConnect("mailw") ? SQLExec(h, 'Select * from Names') Can someone help me? I tried with Oracle and MySQL, through ODBC and I get no errors. What do I do wrong with VFP ? Demetrios, Greece Tag: Page Break in Excel Tag: 218908
  - 9
    - Highliting Rows in a Grid .. I want to highlight Certain rows in a grid based on when a specific condition becomes true ? but am unable to achieve this. an urgent response from anybody will be appreciated. Tag: Page Break in Excel Tag: 218901
  - 10
    - bbListView control .. What is this error, I have placed an ActiveX control bbListView - Shareware Version - control on a foxpro form after its 3rd or 4th execution I have started receiving this error message. I have tried to overcome this by re-applying the control on my PC but even this bears no fruit. Error 1440: OLE exception error: Exception code c0000005. OLE object may be corrupt Tag: Page Break in Excel Tag: 218893
  - 11
    - Grid for Multiple Item Selection .. Can we use a Grid to select multiple rows ? to drag them out of the Grid like in an List Control. OR Can we add Column Headers to a List Control to make it look like a Grid ? Tag: Page Break in Excel Tag: 218892
  - 12
    - header backcolor I need to change the header backcolor's in my grid. I am assigning the color like this form1.grid1.columns(1).header1.backcolor=rgb(255,0,0) or whatever the color When I refresh the grid, it is still grey. I am only changing a couple of the column header colors to indicate certain things for the users. Can anyone help me with this? Scott Tag: Page Break in Excel Tag: 218877
  - 13
    - Twain compatable scanner and VFP 8 or 9 I am looking to incorporate a method into my software package for scanning documents. I am currently using VFP 8, but plan on upgrading within a year to VFP 9. Does anyone have sugesstions, for code or research locations, to program for a Twain compatable scanner? This needs to be generic enough to allow my customers to by the scanners at thier local office supply store. (cannot be specific to a scanner). Thanks in advance Dan Tallent Tag: Page Break in Excel Tag: 218875
  - 14
    - samples in foxpro how are you supposed to use the samples of foxpro when there are no pjx files Tag: Page Break in Excel Tag: 218862
  - 15
    - what's wrong with this "copy to" line OK, I can't figure this out. sometimes this line works and sometimes it won;t, and from the same program. Can someone tell me what's wrong with it? I'm using VFP7 and VFP9 and I get the error "invalid path or filename" but the path is correct. COPY TO "C:\WORK\ADHOC\SURFER\M2\INU141" TYPE DELIMITED WITH "" WITH CHARACTER "|" If I shorten it down and put it in "C:\work" then it works fine. Please help! Thanks! Buster Tag: Page Break in Excel Tag: 218849
  - 16
    - foxpro flashes when opening Whenever i open VFP8.0 it starts to flash a lot...and then it opens. is there a service pack or another fix for this? I reinstalled the app, and it seems to do it more than before. thanks, Marty Tag: Page Break in Excel Tag: 218847
  - 17
    - report no print out Dear All, I have a label form in runtime it is ok, but after compiled the program, the report form label only print out a plain print out, have anyone know what is the problem? thanks in advance ah wa Tag: Page Break in Excel Tag: 218845
  - 18
    - Error in Installshield Express 5.00 Hi, I am using VFP9.00 with the Installshield Express 5.00 When I am trying to build my application I am getting an error : Merging modules... ISEXP : error -4075: File not found. An error occurred merging Module '_VC_System_CRT_.00E218F2_5361_11D3_A51F_00A0C9231BA1:0' for Feature 'AlwaysInstall'. Any ideas please? Thanks, Derek Tag: Page Break in Excel Tag: 218837
  - 19
    - Show both traditional and simplified chinese characters in VFP In a form both character set must be displayed. I had tried several changes in Control Panel -regional configuration and language but I could show them in a VFP form. On the other way, Can I programmatically change this regional configuration? Thanks. Alejandro Fernandez Tag: Page Break in Excel Tag: 218832
  - 20
    - Data from an xls to a dbf. i have been presented a sheet that contains information i need to impot into a dbf. i have no clue hoe to do it and keep the data straight in the table. append from? import from? this is something i have never done. should i save it to an sdf or txt first then bring it in to the table? Tag: Page Break in Excel Tag: 218823
  - 21
    - OK, it's December Where's SP1? Tag: Page Break in Excel Tag: 218819
  - 22
    - LoadXML, RespectNesting I'm hoping someone can set me straight with the XMLAdapter, and its LoadXML function. If the XML document I am reading in is nested, how can I retrieve the data with the relationsihps preserved? Issuing the "ToCursor" function for each XMLTable simply creates a cursor for each table, but the relationships are not preserved. Tag: Page Break in Excel Tag: 218815
  - 23
    - Runtime distribution - Microsoft's position This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C5F663.432DFE10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have an application that uses the Fox 2.5 runtime. There has been a = request to provide the application to a Chinese customer so they can = support a product my company has sold to them. I know that the runtime = is freely distributable, but does that include China? =20 I am in the process of converting this same application to VFP 9.0. = Does the answer to the above question apply to this converted = application as well? Would you be able to point me at the document(s) that site this = information? Thanks for your time Steve ------=_NextPart_000_0006_01C5F663.432DFE10 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2769" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3D"Comic Sans MS" size=3D2>I have an application that = uses the Fox=20 2.5 runtime.  There has been a request to provide the application = to a=20 Chinese customer so they can support a product my company has sold = to=20 them.  I know that the runtime is freely distributable, but does = that=20 include China?  </FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>I am in the process of = converting this=20 same application to VFP 9.0.  Does the answer to the above question = apply=20 to this converted application as well?</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>Would you be able to = point me at the=20 document(s) that site this information?</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>Thanks for your = time</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" = size=3D2>Steve</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C5F663.432DFE10-- Tag: Page Break in Excel Tag: 218813
  - 24
    - Can't shutdown I have a VFP8 application that runs just as an icon in system tray. If the user picks the menu choice to shutdown program they can shutdown windows ok. But if the program is left running shutting down windows goes a little weird. After you press start then select shutdown, programs start shutting including this vfp8 app. No errors display but windows doesn't close. Checking task manager shows the vfp8 app isn't running any more. Press start then select shutdown a 2nd time and windows shuts down. I've trimmed down the on shutdown code to just on shutdown and clear events. Any suggestions? LH Tag: Page Break in Excel Tag: 218805
  - 25
    - Strange Form Behavior I have a process that a user goes through maybe 30 times a day. The steps are always the same. During the process the sequence goes through 4-5 forms being displayed and allowing keyboard entry before a report prints from each form. This happens at literally hundreds of locations with no problems and no issues. However, on all of the machines at one single location a strange thing happens. When the user goes to a form and the form displays, all of the fields will be accessible but the cursor dissappears. Clicking in any field on the form the user can type but the cursor is not visible. The strangest thing is that no matter what key the user presses on the keyboard, the (ctrl+F1) key is the result (a 'y' with the two umlauts on top of it) in all fields. Now, the titlebar of the form itself actually appears disabled, but the form is not disabled. The REALLY strange this is that if the user presses the windows key on the keyboard (which activates the startmenu in windows) and then clicks with the mouse on the titlebar of the form in Visual FoxPro, everything returns to normal and the titlebar is now dark, the keys work correctly in all fields, and the cursor is active. Once this problem occurs, it happens everytime until I delete the resource file and restart our app (or so it appears). All of the systems are new systems. Windows XP. 6 workstations. I have checked the power settings, desktop themes, resource files, other Visual FoxPro apps and their files, replaced the keyboard, etc. It will only happen at this site and then it is reproduced nonstop. Any ideas? Why does switching tasks to/from windows startmenu fix it? The form is the same form that has run for years (and called in the same sequence) by hundreds of users. Thanks in advance Tag: Page Break in Excel Tag: 218791

Hi All,

I have tried many different approaches to getting Excel to Page Break
automatically when I instruct it to, it seems to ignore the command
completely, anyone have any ideas.

oExcel.ActiveWindow.SelectedSheets.HPageBreaks.Add(oExcel.ActiveCell)

oRange = oBook.Sheets(1).Range("A"+cStartRow+":A"+cEndRow)
oBook.Sheets(1).HPageBreaks.Add(oRange)

Thanks in advance
Tanya

RE: Page Break in Excel by MichelRoy

MichelRoy
Thu Dec 08 15:38:01 CST 2005

the syntax, from a recorded macro

Rows("10:10").Select
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell

"Tanya Legault" wrote:

> Hi All,
>
> I have tried many different approaches to getting Excel to Page Break
> automatically when I instruct it to, it seems to ignore the command
> completely, anyone have any ideas.
>
> oExcel.ActiveWindow.SelectedSheets.HPageBreaks.Add(oExcel.ActiveCell)
>
> oRange = oBook.Sheets(1).Range("A"+cStartRow+":A"+cEndRow)
> oBook.Sheets(1).HPageBreaks.Add(oRange)
>
>
> Thanks in advance
> Tanya
>
>
>

RE: Page Break in Excel by MichelRoy

MichelRoy
Thu Dec 08 15:56:04 CST 2005

now in a more civilized language

oXl = CREATEOBJECT("Excel.Application")
oXL.Workbooks.add
oSheet = oXl.ActiveSheet
oSheet.Cells(2,2) = "HELLO How are you doing?"
oSheet.Cells(10,2) = "ALLO comment ca va?"
oSheet.Rows("7:7").Select
oSheet.HPageBreaks.Add(oSheet.Cells(7,1))

oxl.visible = .t.

"Tanya Legault" wrote:

> Hi All,
>
> I have tried many different approaches to getting Excel to Page Break
> automatically when I instruct it to, it seems to ignore the command
> completely, anyone have any ideas.
>
> oExcel.ActiveWindow.SelectedSheets.HPageBreaks.Add(oExcel.ActiveCell)
>
> oRange = oBook.Sheets(1).Range("A"+cStartRow+":A"+cEndRow)
> oBook.Sheets(1).HPageBreaks.Add(oRange)
>
>
> Thanks in advance
> Tanya
>
>
>