XValues in excel chart

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
    - Inno installer Group, I'm trying to get up to speed with Inno.... my question is: where do I have inno put the .dll and .ocx files..I usually leave them in the app folder or sys folder. Do I have to register every .dll and .ocx? Thanks, Wade Tag: XValues in excel chart Tag: 240195
  - 2
    - VFP9 grid date shows century even when century off I have a grid where I need to set AllowCellSelection to .T. because one of the columns has a checkbox that users can check/uncheck. Since setting AllowCellSelection to .T., even though the other columns are set to ReadOnly (and I've tried setting When ro return .F. also), if you click inside the date column the century appears. It doesn't appear otherwise. Any ideas? Regards, Bernie Beattie Tag: XValues in excel chart Tag: 240188
  - 3
    - Dbf files in C:\Program Files in Vista I have experienced some problems for dbf files in C:\Program Files in Vista. Commands pack and zap cannot be done for some files, say product.dbf. Thatâ??s why I donâ??t put dbf files in C:\Program Files in Vista any more. Tag: XValues in excel chart Tag: 240179
  - 4
    - Preparing to install Hi to all; This might be a simple problem... Everytime I open my Form, a message will prompt "Preparing to install". Help me to solve this... I'm using Miscrosoft Visual Foxpro 8.0 with service pack 1 installed. thanks... gechelle Tag: XValues in excel chart Tag: 240177
  - 5
    - bindevent problem This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C8901F.A7DC07A0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi All vfp9, SP1 I wanted to create a simple Word doc and then let the user edit; all = this works fine I also wanted vfp to wait until user closed Word Instead of wait state or using wsh, I thought I would use bindevent and = prevent return to vfp until Word closed (or at least document closed) following Doub Hennig article = http://msdn2.microsoft.com/en-us/library/ms947678.aspx I created a link like: bindevent(_vfp.hWnd, WM_ACTIVATE, oApp, = "WindowsEvents") the bindevent works fine (it correctly gets to oApp.WindowsEvents) however, I have 2 problems 1. if I return BROADCAST_QUERY_DENY for vfp Activate in WindowsEvents = (not calling WindowProc), it does not stop vfp from coming forward 2. the 2nd time I click on vfp top bar (not in screen), it maximizes the = window (like it thinks I double clicked even if some time has passed) anyone know what I am doing wrong ? al ------=_NextPart_000_0008_01C8901F.A7DC07A0 Content-Type: text/html; charset="Windows-1252" 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-1252"> <META content=3D"MSHTML 6.00.2900.3268" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi All</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>vfp9, SP1</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I wanted to create a simple Word doc = and then let=20 the user edit; all this works fine</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I also wanted vfp to wait until user = closed=20 Word</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Instead of wait state or using wsh, I = thought I=20 would use bindevent and prevent return to vfp until Word closed (or at = least=20 document closed)</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>following Doub Hennig article = </FONT><FONT=20 face=3DArial size=3D2><A=20 href=3D"http://msdn2.microsoft.com/en-us/library/ms947678.aspx">http://ms= dn2.microsoft.com/en-us/library/ms947678.aspx</A></FONT></DIV> <DIV><FONT face=3DArial size=3D2>I created a link like:  <FONT=20 face=3D"Courier New" color=3D#0000ff size=3D2>bindevent</FONT><FONT = face=3D"Courier New"=20 size=3D2>(</FONT><FONT face=3D"Courier New" color=3D#0000ff = size=3D2>_vfp</FONT><FONT=20 face=3D"Courier New" size=3D2>.</FONT><FONT face=3D"Courier New" = color=3D#0000ff=20 size=3D2>hWnd</FONT><FONT face=3D"Courier New" size=3D2>, WM_ACTIVATE, = </FONT><FONT=20 face=3D"Courier New" color=3D#0000ff size=3D2>oApp</FONT><FONT = face=3D"Courier New"=20 size=3D2>, "WindowsEvents")</FONT></FONT></DIV> <DIV><FONT face=3DArial size=3D2>the bindevent works fine (it correctly = gets to=20 oApp.WindowsEvents)</FONT></DIV> <DIV><FONT face=3DArial size=3D2>however, I have 2 problems</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>1. if I return BROADCAST_QUERY_DENY for = vfp=20 Activate in WindowsEvents (not calling WindowProc), it does not stop vfp = from=20 coming forward</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>2. the 2nd time I click on vfp top bar = (not in=20 screen), it maximizes the window (like it thinks I double clicked even = if some=20 time has passed)</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>anyone know what I am doing wrong = ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>al</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial = size=3D2></FONT><FONT=20 face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0008_01C8901F.A7DC07A0-- Tag: XValues in excel chart Tag: 240175
  - 6
    - how closing open dbf file? Hi! I have a freetable that is open by more than one users to look at result of thier performance. I wanted this table to be updated every hour in our server but however, if somebody is keeping this freetable file open my sql query that will save and update the result into freetable cannnot overwrite the .dbf file while it is open. cannot overwrite freetable file(.dbf) I need to close this freetable before starting my sql-query to be able to update the freetable every hour... Anybody, can help me. Our server is Windows Server 2003. I have my foxpro sql-query prg running on schedule... Thanks. /patrick Tag: XValues in excel chart Tag: 240157
  - 7
    - SP1 did not solve my problems! Well, looks like Vista SP1 did not solve any of my problems with VFP apps. SET PRINTER TO name is very very slow on Vista computers over the network. For some reason, opening a form and SELECT is VERY slow using Vista workstations. I was really hoping that SP1 would solve some of these issues, but evidently MS didn't listen. Or they just don't care about VFP anymore. We just put www.openoffice.org on all of our computers! No more upgrade fees for us!!!!!! John Tag: XValues in excel chart Tag: 240149
  - 8
    - Encrypting DBFs in Windows Vista I had used Cryptor 4 to encrypt DBFs but this one doesnt work in Windows Vista. Cryptor 5 can run here but I found many messages of problems with this version. Netlib which I used before is now very expensive. What can I use now to encrypt DBFs in Vista? Thanks. Alejandro Fernandez Tag: XValues in excel chart Tag: 240143
  - 9
    - Window on top Hello all and thanks in advance for the help. I have an application that creates windows (forms) in response to external events or messages. When a new form is created, I need it to appear on top of any application currently running (both FoxPro and non-FoxPro). Is there any way to make this happen? The events that cause a window to be created are not initiated by user interface events so the user is likely to have the application minimized when an event occurs that would cause a window to be instantiated. Currently, the windows often "pop under" existing applications and I need them to pop over them. Thanks, Jeff Tag: XValues in excel chart Tag: 240134
  - 10
    - WMI Hi All, I have been trying to use WMI to create a folder and share it during my post executable procedure in my installer. Basically the idea is that if a database does not exist and the user has designated this machine a the "file server", create a folder to hold the database, share the folder and create a new database in this folder. The problem is that most of the WMI code appears to be in C, VB and Perl. All of the scripts I have based my code on have language specific commands that don't readily translate to VFP. Here is my code as it now exists (tailored for test purposes). The code is still pretty rough. Running it through the debugger, some intellisense is available but this confuses more than it helps. Any help greatly appreciated. Jan LOCAL cDBFolder, oWMI, oShare, nResult, oSecurity, oSD, colUsers, oUserName, oSID LOCAL ARRAY aSID(12) aSID(1) = CHR(1) aSID(1) = CHR(1) aSID(1) = CHR(0) aSID(1) = CHR(0) aSID(1) = CHR(0) aSID(1) = CHR(0) aSID(1) = CHR(0) aSID(1) = CHR(1) aSID(1) = CHR(0) aSID(1) = CHR(0) aSID(1) = CHR(0) aSID(1) = CHR(0) cDBFolder = "C:\ProgramData\TestShare" oWMI = getobject("winmgmts:{impersonationLevel=Impersonate,(Security)}!\\.\root\cimv2") * Get the Secrity Descriptor oClass = oWMI.Get("Win32_SecurityDescriptor") oSD = oClass.SpawnInstance_() * Prepare the security descriptor oSD.Properties_.Item("ControlFlags") = 4 oTrustee = oWMI.Get("Win32_Trustee").SpawnInstance_() oTrustee.Domain = "." oTrustee.Name = "EVERYONE" ******* * Run into trouble here as the SID appears to be a byte array. If I comment this out the procedure fails further down * The original VB code used a value of Array(1,1,0,0,0,0,0,1,0,0,0,0). As evident I have experimented somewhat oTrustee.Properties_.Item("SID") = (aSID) && CHR(1)+CHR(1)+REPLICATE(CHR(0),5)+CHR(1)+REPLICATE(CHR(0),4) oACE = oWMI.Get("Win32_ACE").SpawnInstance_() oACE.Properties_.Item("AccessMask") = 2132127 && FULL ACCESS oACE.Properties_.Item("AceFlags") = 3 && FILES & FOLDERS Inherit access mode oACE.Properties_.Item("AceType") = 0 && Allow access oACE.Properties_.Item("Trustee") = oTrustee && Everyone oSD.Properties_.Item("DACL") = oACE * Create the new share oShare = oWMI.Get("Win32_Share") oSParams = oShare.Methods_("Create").InParamaters.SpawnInstance_() oSParams.Properties_.Item("Access") = oSD oSParams.Properties_.Item("Description") = "Test System File Server" oSParams.Properties_.Item("Name") = "Test System" oSParams.Properties_.Item("Path") = cDBFolder oSParams.Properties_.Item("Type") = 0 && Disk Drive * Execute the method ie. create the share *nResult = oShare.Create(cDBFolder, "TestShare", 0, 25,"Test System File Server") oSOutput = oShare.ExecMethod_("Create", oSParams) nResult = oSOutput.ReturnValue * This stuff will only work when run as a method on the installdb form *DO case *CASE nresult = 0 * thisform.displaystatus("Database shared") *CASE nResult = 2 * thisform.displaystatus("Database could not be shared - Access denied") * return *CASE nResult = 8 * thisform.displaystatus("Database could not be shared - Unknown failure") * return *CASE nResult = 9 * thisform.displaystatus("Database could not be shared - Invalid name") * return *CASE nResult = 10 * thisform.displaystatus("Database could not be shared - Invalid Level") * return *CASE nResult = 21 * thisform.displaystatus("Database could not be shared - Invalid parameter") * RETURN *CASE nResult = 22 * thisform.displaystatus("Database could not be shared - Duplicate share") * return *CASE nResult = 23 * thisform.displaystatus("Database could not be shared - Redirected path") * return *CASE nResult = 24 * thisform.displaystatus("Database could not be shared - Unknown device or directory") * return *CASE nResult = 21 * thisform.displaystatus("Database could not be shared - Net name not found") * return *OTHERWISE * thisform.displaystatus("Database could not be shared - Unhandled exception") * return *ENDCASE *RETURN Tag: XValues in excel chart Tag: 240130
  - 11
    - Report Format Q. How on a report field, for a telephone number, do you format the data? My input mask in the database is (###)###-#### and the format is R. Respectfully, Jonathan Morningstar On another note, does anyone have knowledge of a program or app that you can point to ones Outlook and print ALL the email out in one shot? Tag: XValues in excel chart Tag: 240118
  - 12
    - Help with SQLEXEC() statement This line of code is failing on me. X is returned as -1. If I take out the WHERE statement I'm good. Can somebody tell me what I'm doing wrong here? tmppath = alltrim(POSHeader.path) tmpfile = tmppath + alltrim(POSHeader.compcode) + 'poitm' tmpfile2 = alltrim(POSHeader.compcode) + 'poitm' mt = 'SELECT * FROM &tmpfile WHERE &tmpfile2 ="EEE" ' x= SQLEXEC(gnConnHandle, mt, 'tmpPOITM') TIA. BR Tag: XValues in excel chart Tag: 240100
  - 13
    - Listboxes ControlSource VFP8 SP1 VISTA Is there a problem setting ControlSource to listboxes? The code below doesn´t work. It selects the first field in the local view vwAccActs as its source. Accesscode is the second field. ThisForm.List2.ColumnCount = 1 ThisForm.List2.RowSourceType = 2 ThisForm.List2.RowSource = 'vwAccActs' ThisForm.List2.ControlSource = 'vwAccActs.accesscode' But if the same listbox is called with anothter code (below) it works just fine. ThisForm.List2.ColumnCount = 1 ThisForm.List2.RowSourceType = 2 ThisForm.List2.RowSource = 'VwAccGrps' ThisForm.List2.ControlSource = 'VwAccGrps.accesscode' && accesscode is the second field I need a hint please. Best regards Chrisitna Tag: XValues in excel chart Tag: 240098
  - 14
    - Is there any better replacement for UNTIL than DO WHILE .T. I wrote the following code today that I don't like (even though I've written code just like it many times) DO WHILE .t. lcCCFolio = INPUTBOX("Folio Number ") IF EMPTY(lcCCFolio) RETURN ENDIF lcCCFolio = "0000" + lcCCFolio SEEK lcCCFolio IF FOUND() EXIT ENDIF ENDDO I would have preferred something like DO lcCCFolio = INPUTBOX("Folio Number ") IF EMPTY(lcCCFolio) RETURN ENDIF lcCCFolio = "0000" + lcCCFolio SEEK lcCCFolio UNTIL FOUND() Is there a better replacement for an UNTIL statement? Other coding options? Thanks, Jeff Tag: XValues in excel chart Tag: 240091
  - 15
    - Simple code doesn't work... SELECT inventory LOCAL lnfamilyid lnfamilyid = inventory.familyid SELECT sku FROM inventory ORDER BY sku WHERE inventory.familyid = lnfamilyid INTO CURSOR MyList IF NOT USED('ivlist') USE ivlist IN SELECT(1) ENDIF SELECT ivlist APPEND FROM DBF("MyList") && continues to append from inventory.dbf and not MyList USE IN ivlist USE IN mylist SELECT inventory =MESSAGEBOX('IVList Created') This code continues to append records from inventory.dbf. Why? I'm specifying "MyList" which is a temp cursor. The help file says use DBF() when appending from a temp cursor. But VFP 8 continues to append from inventory.dbf (which is open) in a different work area. Tag: XValues in excel chart Tag: 240072
  - 16
    - VISTA!!! I am rather scared. Can I install Foxpro7 on Vista Home Premium? Vista is rather strict, and keeps asking me to wash my feet; and worries me no end with 'service failed logon' and suchlike threats. Mohan -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/foxpro-general/200803/1 Tag: XValues in excel chart Tag: 240068
  - 17
    - Different Column counts for each detail band in report. I'm trying to use multiple detail bands to get a subreport effect. It seems I am only able to control the column count for the entire report. I need to have one detail band of the report print in two columns, the middle detail band in three columns, and the third detail band only one column. All of these have to be on one report with no page breaks in between each detail band. Is there another way to do subreports in VFP9 or are multiple detail bands the only way? Thanks in advance Tag: XValues in excel chart Tag: 240064
  - 18
    - SQL + udf's Where is it cool & where not? I'm at work now & I don't have my dev env. Where is it ok to use a udf in a vfp sql statement & where not. I seem to remember in the Select clause is a no-no, but in the where clause is ok. Tag: XValues in excel chart Tag: 240057
  - 19
    - Cursor cannot be modified because it contains an unsaved record (Error 2072) We have been getting this error intermitantly in our package, and i hopeing someone can shed some more light on this, and possible have a solution as to how to get around this. basically we are getting this in the event of trying to do replace on a cursor that is linked to a grid and also to the control source of a text box. how do we get it to save first? as suggested in the help. i cant seem to find anything that saves a temporary cursor, i thought the whole point is that they are not actually saved to disk, but kept in memory. Tag: XValues in excel chart Tag: 240046
  - 20
    - Foxpro & SQL Server CE Has anyone done any work transfering data from Foxpro to SQL Server CE databases? thanks pete Tag: XValues in excel chart Tag: 240045
  - 21
    - Printing Am trying to print barcodes with an activex component. In vb, I was able to send the graphic barcode to the printer with Printer.PaintPicture I'm not finding anything comparable under FP 9. Is there a way to print such images? Gleason Tag: XValues in excel chart Tag: 240040
  - 22
    - Slow Window Creation Hello and thanks for the help. I have a VFP 9 SP 2 app that creates many instances of my own subclass of the form control. I've noticed that when I start the app and it is creating the necessary windows, there is a noticeable delay between each window that is created. It seems to create about 1-2 windows per second which to me seems kind of slow. Does anyone know if this is normal or if there is a way to speed it up? Each window has a TE Edit activex control. TE is a full featured RTF editor. Would that slow down the load? Any input would be appreciated. Thanks, Jeff Tag: XValues in excel chart Tag: 240036
  - 23
    - Loading form starts VFP 9 Installer Hello and thanks for the help. I have a form which starts the VFP 9.0 installer every time I load it in the IDE or execute it in an EXE. Does anyone have any experience with this behavior? Thanks Jeff Tag: XValues in excel chart Tag: 240033
  - 24
    - VFPWINSOCK is sending the wrong date I am using VFPWINSOCK to send emails viaSMTP from a VFP application. Although the email is given the correct date, when it is received at the other end, it is received with a date 15 hours sooner. ie - sent at 6pm, received as 4am We are at GMT+10 I checked the code and it is setting DATETIME() correctly to the date when sending. Any ideas? Cheers David Tag: XValues in excel chart Tag: 240028
  - 25
    - Easy or hard?: Interface VFP desktop application with an internet application I deal regularly with a custom internet application that my nonprofit organization subscribes to. It requires me to input data manually and regularly and much of this is repetitive and has its quirks and difficulties. For instance, every time I enter a record I'm forced to enter the current time in two fields. The first field is the hour (e.g. 3 for a time between 3:00 and 3:59) and the second field is minutes (e.g. 59). The hour persists, but doesn't always update on time, forcing me to manually change the hour field. If I use my own VFP application to enter the data, I can have the time saved to my own VFP data automatically off the computer's clock, saving me the trouble of entering it manually, looking at the clock, etc. I can also supply data to my records driven by my own tables instead of having to enter it manually into fields like I have to do when using the web application. The problem from my perspective is getting the data from my own VFP tables into the browser form of the internet application. That application is written in PHP on a MySQL database. It has private access requiring a username and password. I don't want or expect to be able to automate the process completely, that's not the issue. I'd just like to make it reasonably convenient to enter the data into the internet application from my VFP data. I was thinking that I might be able to use a macro utility of some sort to grab the data from FoxPro and jam it into the internet form. I could inspect the form before saving data. I would certainly inspect the data online for errors, which is easy to do, as well as correct errors at any time. The internet application has an autocomplete function, but it can be rather dodgy and it's subject to problems with bad data entered by other people, something I have no control over. I'd rather use my own autocomplete functionality, driven by my own data. I'd use that on my client side VFP application when I enter the data, prior to "transferring" my data to the web application. Ultimately, the data would be stored on a server somewhere in MySQL, although I have data locally for my own purposes. How doable is this and what might I use to do it? TIA for guidance. Dan Tag: XValues in excel chart Tag: 240023
- Next
  - 1
    - Vanishing variable I have yet another variable going missing problem that I'd like to understand how it happens. In the click method for a button I have code like: lcinstruct = ' ' do form B p1, p2, p3 to lcinstruct if empty(lcinstruct) messagebox("error happened") endif occasionally the empty(lcinstruct) will fail with "Function argument value, type, or count is invalid." due, I believe to the variable lcinstruct disappearing. In my error handler I do a list memory and in the list of variables lcinstruct does not appear in instances where the crash occurs however it does appear in other instances where I force a List memory to happen. The Unload routine of form B has a return lcinstruct statement. thanks pete Tag: XValues in excel chart Tag: 240016
  - 2
    - Best approach? I've written a function that parses a search string and returns a 1D array for each word in the string. Such as, "PAINT SPRAY RED" would return an array of cArray[1,1]="PAINT" cArray[2,1]="SPRAY" etc. Now I want to issue a SELECT statement to search my inventory file Select * from inventory WHERE cArray[1,1]$descript AND .... (or several other fields may be searched) and so on... The problem is that I can't hard code the select statement because the function will create the number of elements for the array based on how many search terms are entered. I'm assuming a user defined function in the select to return the WHERE clause would work, but is this best? (or is this even permissable and will a UDF in a Select statement return correct results?) What would be the best approach for this? How do search engines like google parse the search string and then return the results to a cursor? Thanks, John I'm using VFP8SP1 Tag: XValues in excel chart Tag: 240012
  - 3
    - Insert sql ... if not found idea I'm trying to insert the val stored in a memvar into a table only if it isn't there already, the idea looks like: cName = 'bob' insert into names (name); select cName from names where cName not in (select name from names) ... but this results in the error: Queries of this type are not supported. Is there a way to do this in a single vfp sql statement? -- -Lew The workers took the robot for Maria. Tag: XValues in excel chart Tag: 240005
  - 4
    - [Microsoft][ODBC dBase Driver] Index not found I'm using VB6 to connect to some foxpro 2.6 tables. I can connect to the tables and run simple queries using ADO. The following query works fine: SELECT BMX.PNO, BMX.SUFFIX, BMX.QTY, BMX.COMPCPU, BMX.SUBBNO, BM.BNO, BM.BNAME, PROD.SPROD, PROD.PROD, PROD.DBTYPE, CUST.CNO, CUST.CNAME FROM PROD, CUST, BM, BMX WHERE BM.BNO = BMX.BNO AND PROD.PNO = BMX.PNO AND CUST.CNO = BM.SCNO ORDER BY PROD.SPROD But when I insert this line in the Query, I get this message: [Microsoft][ODBC dBase Driver] Index not found Line inserted: AND BMX.BNO = 199 Does anyone have any idea what's going on and if there's a fix or work-around? Thanks, Keith Tag: XValues in excel chart Tag: 239999
  - 5
    - Can't close a dbc I'm trying to start an app with a clear slate, but I can't close its chief dbc reliably. The app creates a private session object and opens the dbc in the private session. I may not close it properly in the app during testing for whatever reason, but the main prg does a close all & clear all to make sure that no project managers are open, then loops through aSessions and nests aDatabaseses to visit every possible dbc & does a close databases all for each. Yet, when I finish all this, dbused() still shows that it's open and I can set database to ... successfully without having to open database first. How can I close the blasted thing? -- -Lew The workers took the robot for Maria. Tag: XValues in excel chart Tag: 239996
  - 6
    - Any way to do a hidden password input in INPUTBOX? HI, Is there any way to do a password 'hidden' input in the INPUTBOX statement? Zoom Tag: XValues in excel chart Tag: 239991
  - 7
    - [ot] testing 1 2 3 I can't access msnews.microsoft.com directly... need to post via Usenet... ping... Tag: XValues in excel chart Tag: 239986
  - 8
    - RDA method for SQL server CE Hi All I need to send some data to the SQL Server 2005(Central Server) from my Pocket PC Device(Compact Edition,local database). I am going with RDA method. Is PULLED data only be able to PUSH back top Server? Thanks in advance... Tag: XValues in excel chart Tag: 239985
  - 9
    - MS Graph Hi! I have a freetable called 'cperformance.dbf'' which contain field gname,fname,collection. I have this in a form with a grid, displaying ' Fname, Gname,Collection'. This freetable display the staff collection performance in numbers but it would also be very nice to display the figure in Graph? Anybody, can share me your sample code of creating a GRAPH and print them? Any assistance is very much appreciated. /patrick Tag: XValues in excel chart Tag: 239980
  - 10
    - Creating a searchable pdf with Print2PDF VFP 9.2, XP sp2 Using print2pdf for a number of reports. Most of them are searchable for text, but one is not. Acrobat seems to think the one report is a scanned document. The only difference I find is that when calling the "problem" report I set reportbehavior 90. Could this be the reason? Do I need that command to take advatage of multiple detail bands? Thanks in advance. Dave Tiffany Tag: XValues in excel chart Tag: 239964
  - 11
    - Which one is best for ODBC/MSSQL: pass as ?MyVariable or as the value? Hi all: I wonder which one would be faster to execute by SQL Server - especially if I put this inside a scan-endscan loop: 1) text to lcSQLCmd textmerge noshow pretext 2 select some_field_1, some_field_2 from a_table where the_pk = ?lcThePrimaryKey endtext =sqlexec ( liSQLConnHandle, lcSQLCmd, [xCursor] ) OR: 2) text to lcSQLCmd textmerge noshow pretext 2 select some_field_1, some_field_2 from a_table where the_pk = '<<lcThePrimaryKey>>' endtext =sqlexec ( liSQLConnHandle, lcSQLCmd, [xCursor] ) (please notice the difference on where clause). Looking forward to hearing from all of you. Thanks. WBR, Willianto Tag: XValues in excel chart Tag: 239951
  - 12
    - Report field stretching problems I have a report in which a field was changed from a small character field to a memo field. Some of the memo fields contain a good deal of text, so this field on the report needed to be changed to stretch: http://www.proudviews.com/RptStretch.jpg After changing the report field to stretch with overflow, setting the vertical lines to stretch with the band, and setting the line below the memo fied to float, here is the result: http://www.proudviews.com/stretch_new.jpg The memo field now stretches as desired, but the vertical lines are lost across a page break, and very oddly, a field set not to print repeated values is now showing repeated values. Any input on ironing this out? I usually don't use memos much in reports, so there may well be some setting I'm missing to make this look right. -- TRW _______________________________________ t i m . w i t o r t _______________________________________ Tag: XValues in excel chart Tag: 239948
  - 13
    - systray is ignoring right mouse click Hello and thank for the help. I am using the systray class with VFP 9 and I have code in IconRightClickEvent() which is being ignored. I can't figure out what I'm doing wrong. The IconClickEvent() code is working correctly. Any suggestions? Thanks, Jeff Tag: XValues in excel chart Tag: 239947
  - 14
    - systray class does not show systray icon in EXE Hello and thanks for the help. I have an app in VFP 9 in which I am using the systray class. When I run the app in the IDE, everything works fine. The systray icon appears and responds to mouse events. When I compile the app and run the EXE version, there is no systray icon. Is there a DLL associated with the systray VCX that I need to distribute? Thanks, Jeff Tag: XValues in excel chart Tag: 239945
  - 15
    - Releasing Memory After Completion of a Process Hi! I have developed an EXE [in VFP 9] which the User is intends run to execute certain tasks (like importing, exporting data etc.). In order make use of this all the user does is set the task and the time which the task have to run. The EXE will be run in the background and checks [each 10 minutes] if any task have to be executed. If any scheduled tasks fall within current time range then the task would be run. This EXE is installed on Windows 2003 Server. Microsoft SQL Server 2000 is used as the back end. The issue I'm facing is whenever this EXE tries to execute tasks the CPU Memory usage of the Client's PC goes high [mostly up to 100% usage]. There can 100 thousand records or more involved in the import/ export at a given time. I've been under the impression that the CPU Memory usage goes when the EXE executing tasks is due to the high volume data and the memory would get released as soon as the process is over. But this is not case; the memory is not released once the task is completed execution. The CPU Memory is freed after very long time. At present this single EXE consists of all the data import/ export tasks. I'm planning to have multiple EXE's for each task where the main EXE would call the relevant sub EXE to execute a task. The main reason for me to come up with such a method is the expectation that the CPU Memory would freed / released immediately after the execution of a sub EXE. Can anyone of you help out with some suggestion as to how to over come this issue. Thanks in advance... Cheers... :-) Tag: XValues in excel chart Tag: 239942
  - 16
    - Ebony Dubs Vol 2 legal mp3 E B O N Y D U B S V O L 2 M U S I C D O W N L O A D *Ra Vinyl 2003* 'Ebony Dubs Vol 2 - Ra' (http://tinyurl.com/22tvrs) (4:33 6.25Mb 192kbps) 'Ebony Dubs Vol 2 ringtone' (http://mp3tube.info/ebony_dubs_vol_2/), 'Ebony Dubs Vol 2 Ra Vinyl mp3 music' (http://mp3tube.info/ebony_dubs_vol_2/) -- Dodes65 ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: XValues in excel chart Tag: 239941
  - 17
    - Changing Window Behavior Hello and thanks for the help... Can I change the default behaviors of clicking and right clicking on a minimized window? Right now, as you probably know, clicking alternates between restoring and minimizing and right clicking pulls up a menu with restore, move, etc. I would like to use left clicking for my own purposes and have right click toggle between restore and minimize. Is this possible? Thanks, Jeff Tag: XValues in excel chart Tag: 239935
  - 18
    - open word Hi Very beginner ? What is code to open a word document. The .doc is already created. It is a merge print letter. Please be basic. Thanks sherry Tag: XValues in excel chart Tag: 239930
  - 19
    - VFP 8.0 - How to handle this. I have multiple compiled .exes using VFP 8.0. Each one is called by a prg, calls the form and when the form is destroyed, clear events is issued. Now, I want to call each of these individual .exe's from another .exe. (a form acting as a main menu). But the problem is that when I run the individual .exe the entire app is closed because each .exe issues a clear events in the destroy event. I thought about creating a public variable when the main menu is initialized. Then in each individual .exe during the destory event, checking for the existence of the public variable. If it does not exist, then the destory event would issue the clear events and act as normal. If the public variable does exist, then the destory event would only release the form and return to the main menu. Is there a better way to handle this. I want to minimize changes to my existing .exes. Thanks, John Tag: XValues in excel chart Tag: 239925
  - 20
    - Use Format on Editbox Control Hi, I am using an Editbox control in VFP9. Now I need to format all the keyed in text into this edit box control in the uppercase format. How can I do this? I tried to set the value of ! for UPPERCASE in the FORMAT property. But from VFP help it seems this value works only for the edit box but not edit box control? If so, is there any other work around like setting some other property... Thanks, Chakra Tag: XValues in excel chart Tag: 239922
  - 21
    - file scripting object This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C8821A.E4E36ED0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have used the file scripting object in my application. What do I need to include in my installation routine to make sure that = all files required are installed for the user? Sincerely Stephen ------=_NextPart_000_0006_01C8821A.E4E36ED0 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.6000.16608" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I have used the file scripting object = in my=20 application.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>What do I need to include in my = installation=20 routine to make sure that all files required are installed for the=20 user?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Sincerely</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV> <DIV> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C8821A.E4E36ED0-- Tag: XValues in excel chart Tag: 239913
  - 22
    - Print in Half Page Sheet Hi to All, Can anybody help me with this Report Form, the default paper size I am using is 8.5 x 11, I want to use 8.5 x 5.5. most paper size's depends on printer installed. what Printer model should I need to install... I am using Epson LX-300 thanks a lot for your help. Gechelle Tag: XValues in excel chart Tag: 239899
  - 23
    - line is too long in eval or & I have a very long string that i am trying to evaluate, and it returns. "LINE IS TOO LONG". what are the limitations for eval or macro substitution? thanks, Marty Tag: XValues in excel chart Tag: 239893
  - 24
    - RTF Control What do I need to include (OCX etc) in my setup program to enable the RTF control on my end users machine? Tag: XValues in excel chart Tag: 239888
  - 25
    - Novice Error Very Novice here. Getting this error message within Visual FoxPro program. Error number: 11Error message: Function argument value, type, or count is invalid.Line of code with error: IF "TEST" $ UPPER(pcParams)Line number of error: 175Program with error: CREATE_INC_EXPORT Can someone help me??? I see the attribute pcParams defined. The line of code for that is... LPARAMETERS pcParams Also, does anyone have any suggestions for training and/or reading material for novice FoxPro??? Thanks in advance for your help and consideration. PSULionRP Tag: XValues in excel chart Tag: 239873

I am exporting my data to excel through office automation. First three lines
are Report title and subtitle and some other information. Line 4 is coloumn
heading and from line 5 onwards actual data. Based on this data I am
creating column chart. I want to show my column heading as x-axis labels but
it shows 1,2,3,4,.... I dont find how to setup XValue property of chart as
range. Here is my code.

xlColumnClustered = 51
oChart = oleapp.Sheets[1].chartobjects.add(50,225,550,300)
oChart.Activate()
OleApp.ActiveChart.ChartType = xlColumnClustered
OleApp.ActiveChart.SetSourceData(OleApp.Range("B12:M12"))
OleApp.ActiveChart.SeriesCollection.Add("Sheet1!$B$4:$M$4",2,.T.,.T.,.T.)
OleApp.ActiveChart.SeriesCollection[1].HasDataLabels = .T.
OleApp.ActiveChart.HasTitle = .T.
OleApp.ActiveChart.ChartTitle.Caption = "Statewide Rate"
OleApp.ActiveChart.HasLegend = .F.

Can anyone please help.

Thanks.

Top

Re: XValues in excel chart by tom

tom
Wed Apr 09 07:18:02 CDT 2008

Hi,

I would try to record a macro in excel. The macro source then normally gives
a GOOD hint how to do it.
Maybe you find something in the excellent office automation book from
hentzenwerke

greetings
tom

"Sunny" <just4group@hotmail.com> schrieb im Newsbeitrag
news:%23iniDERkIHA.4664@TK2MSFTNGP03.phx.gbl...
>I am exporting my data to excel through office automation. First three
>lines are Report title and subtitle and some other information. Line 4 is
>coloumn heading and from line 5 onwards actual data. Based on this data I
>am creating column chart. I want to show my column heading as x-axis labels
>but it shows 1,2,3,4,.... I dont find how to setup XValue property of chart
>as range. Here is my code.
>
> xlColumnClustered = 51
> oChart = oleapp.Sheets[1].chartobjects.add(50,225,550,300)
> oChart.Activate()
> OleApp.ActiveChart.ChartType = xlColumnClustered
> OleApp.ActiveChart.SetSourceData(OleApp.Range("B12:M12"))
>
> OleApp.ActiveChart.SeriesCollection.Add("Sheet1!$B$4:$M$4",2,.T.,.T.,.T.)
> OleApp.ActiveChart.SeriesCollection[1].HasDataLabels = .T.
> OleApp.ActiveChart.HasTitle = .T.
> OleApp.ActiveChart.ChartTitle.Caption = "Statewide Rate"
> OleApp.ActiveChart.HasLegend = .F.
>
> Can anyone please help.
>
> Thanks.
>
>

Top