Pass data to Excel option button

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
    - exclude a field in final output XML file Hi friends I am using xmladapter class to create xml files and my following code working fine. LOCAL oXMLadapter as XMLAdapter oXMLadapter = CREATEOBJECT("XMLAdapter") WITH oXMLadapter .AddTableSchema('nhi') && content to the xml file .ForceCloseTag= .T. && maintain open and close tags .RespectCursorCP = .T. .UTF8Encoded = .T. *--XML file will created according to XSD file (schema) .XMLSchemaLocation = "C:\OpthalmologyVirtualConsultationPatientSchema.xsd" .ToXML('c:\xx.xml',,.T.) ENDWITH and i've quick question i've a column in my cursor(nhi) which i dont want see in final XML file.my schema file does not have that element in it but still TOXML method still create that column in final output file. is there any way to exclude that column in final XML file ?? Thanks for ur ideas -- cheers Tag: Pass data to Excel option button Tag: 205774
  - 2
    - newsgroup phrases & acronyms what do the following stand for, OTOH, Coffee Machine, & a whole lot of other such phrases & acronyms?? Where can i get a list of such phrases (at least a few). Becuase sometimes i find it tough to understand what they mean... FOr instance, i guessed that OTOH = On The Other Hand Thanks in advance, Paul Tag: Pass data to Excel option button Tag: 205769
  - 3
    - VFP 9 reports how can i generate a bar graph from VFP 9? Jack Tag: Pass data to Excel option button Tag: 205767
  - 4
    - FRX reference I need the ability to programmatically create/alter reports on the fly depending on certain situations the users are in. Is there a reference article or something to explain what each field and code means in the .FRX file? Thanks, Scott Tag: Pass data to Excel option button Tag: 205766
  - 5
    - Help: Error when adding VFP 9 form to VSS Hello all I am trying to convert a VFP project from 8 to 9 and when I try to add a form to VSS I am getting this error. Error #9 in sortmethods (1349) Data Type mismatch. Has anyone run into this before and have a solution to this. Help on this is greatly appreciated. - Art Tag: Pass data to Excel option button Tag: 205762
  - 6
    - Setting background color for individual cell in grid Does anyone know a way to do this? VFP9. I'm working on something which ideally needs to emulate Excel functionality with a DBF and keep the formatting intact, but also keep the data in a DBF file. Any ideas on a better approach than grids much appreciated. Thanks, Neil Tag: Pass data to Excel option button Tag: 205760
  - 7
    - c0000029 bug report sent to Microsoft This is the bug report I sent to MS, in case anyone wants to play with this. This is a Visual FoxPro bug about FoxPro Version (pick one): 8.0 SP1 Reproduces (pick one): always Hardware and Software Details: Dell opteron 2.6 GHz Celeron Windows 2000 Happens on other machines as well. Other Development Environments? yes If yes which? Visual Studio .net 2003 Steps to Reproduce: 1) First create a database, and put a table in it, put some records in it. CREATE DATABASE ZOOT CREATE TABLE ZOOT (Z1 C(10), Z2 C(10), CHANGE T ) INSERT INTO ZOOT (Z1) VALUES ('ZOOT') 2) Set record validation Rule - we want this procedure in the DBC to execute when a record is changed: setchange() 3) Create stored procedure in DBC called SetChange: PROCEDURE setChange TRY IF glSetChange REPLACE CHANGE WITH DATETIME() ENDIF CATCH * WAIT WINDOW 'An error has occured' ENDTRY RETURN .T. ENDPROC 4) Run this code: USE ZOOT SET STEP ON REPLACE Z1 WITH 'NoZoot', Z2 WITH BadVarName Notice that glSetChange is uninitialized. This is by design. Notice that BadVarName is undefined. In order to reproduce this error, you need a two part REPLACE, and the first one (Z1 WITH 'NoZoot') must be valid, and the second one (Z2 WITH BadVarName) must be invalid IE have a runtime error such as uninitialized variable or invalid table/field name, etc. Observed Behavior: I step through the code via the above SET STEP because if you dont, sometimes VFP will just hard terminate, poof and it's gone. If you step through it, when you get to this line: TRY IF glSetChange You should get a c0000029. It varies according to the code in SetChange, but it will consistently crash. If I change the code slightly , I can get c0000005, c0000029. I also get MS VC++ Runtime Library error, Buffer overrun detected error. The code I posted above seems to consistently produce c0000029. This, for example, IF glSetChange .AND. 1 = 1 seems to produce a buffer overrun warning, other variations produce a mismatched push/pop type of message. Expected Behavior: A trappable VFP error should be generated, not a hard crash. Additional Information: I can get a crash in VFP7 by using this code in SetChange: PROCEDURE setChange ON ERROR llZOOT = .T. IF glSetChange REPLACE CHANGE WITH DATETIME() ENDIF ON ERROR RETURN .T. ENDPROC Since VFP7 does not support TRY/CATCH, I use traditional error trapping instead. In VFP9 the same process generates a c0000005 error. Tag: Pass data to Excel option button Tag: 205753
  - 8
    - inserting new record Is it possible to insert a new record within a table? I don't have a way to sort. It's just a list that needs to stay in a certain order. I'm using vfp8. Thanks Sherry Tag: Pass data to Excel option button Tag: 205749
  - 9
    - about font size of vfp 9.0 This is a multi-part message in MIME format. ------=_NextPart_000_0010_01C4F81D.55EC3520 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable Hi,All, I just compiled my vfp8 project and found a strange problem, Although my = label font size in every form is not changed(I set them all to 10),it = seems that font size 10 in vfp9.0 is more large than in vfp8?=20 Why?=20 B.Regards Chuen ------=_NextPart_000_0010_01C4F81D.55EC3520 Content-Type: text/html; charset="gb2312" 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=3Dgb2312"> <META content=3D"MSHTML 6.00.3790.218" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT size=3D2>Hi,All,</FONT></DIV> <DIV><FONT size=3D2>I just compiled my vfp8 project and found a strange = problem,=20 Although my label font size in every form is not changed(I set them all = to=20 10),it seems that font size 10 in vfp9.0 is more large than in = vfp8?=20 </FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Why? </FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>B.Regards</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Chuen</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0010_01C4F81D.55EC3520-- Tag: Pass data to Excel option button Tag: 205742
  - 10
    - gibberish when printing in landscape VFP9 I have a very simple report, no calculations, no variables. Just simple fields. No report listeners. If I have paper orientation set to landscape and reportbehavior set to 90, the report is filled with gibberish. If portrait mode or reportbehavior is 80, it works fine. Obviously I have a workaround, since I'm not using report listeners, but I thought I'd ask whether others have seen this. I reported it already. Tag: Pass data to Excel option button Tag: 205736
  - 11
    - printers Hello, I am wondering if anyone else who has created full applications in FoxPro has come up with the dilemma of how many possible ways can an envelope be fed through a printer. I am the programmer of a billing software built in Visual FoxPro. I have a feature where people can print envelopes addressed to their clients. I have a report strategicly built so that the return address and clients address are placed in the positions where once an envlope is fed there envelope comes out correct. There are three different types of HP printers at the office that I can take into account, but what about the other brands? Is there a proceedure I can use that can give me how the specific invoice takes in envelopes? Or do I have to figure out all possible ways an envelope can be fed through a printer? If this is the case can someone direct me to the correct place to look this up? I have been unsuccesful so far. Tag: Pass data to Excel option button Tag: 205727
  - 12
    - firing the foxcode i've noticed that not only if we type SPACEBAR, but also typing the closing bracket ) will invoke intellisense. If one looks at the source code in XSource (in the FoxCode.prg), & places some code (preferably a messagebox in the DefaultScript() method, this will get displayed if you type ) Now, i want to know if we can control what characters invoke the foxcode. I don't want to be limited with only SPACEBAR & Closing Brackets. I a few other such key characters to invoke the intellisense (foxcode). Any ideas, any one??? Tag: Pass data to Excel option button Tag: 205719
  - 13
    - new item under Options->File Locations is it possible to put in a new item in the listbox displayed under Options->File Locations I'd like to setup some development tools & want to plug the configurations of the files in here I've had a look at the xsource files, but could'nt find any code related to this Options screen. Tag: Pass data to Excel option button Tag: 205718
  - 14
    - debugger problem in VFP9 I hate to quibble, but... In the Trace window, if you hover the mouse pointer over a variable or field, you get a ToolTip window showing the value of that variable. A very useful feature! But new to VFP9, if the value is a string, what's shown does not include the string delimiters, ie quotation marks. That makes it impossible to differentiate between 12345 and "12345". And it's difficult to tell between "ABC" and "ABC ". Tag: Pass data to Excel option button Tag: 205717
  - 15
    - End Program What code ends a program like END in VB? Tag: Pass data to Excel option button Tag: 205716
  - 16
    - Serial communication -> HOW ? Hi there, I need to somehow link a PC, via a serial port, to a weighting scale. I'm using Visual FoxPro 7 and I really don't know how to do that (I have tried some FOPEN (COM1) but it didn't work) Any ideas? Please... Daniel Tag: Pass data to Excel option button Tag: 205707
  - 17
    - Tableupdate with Oracle (ODBC) Whenever I try to update an Oracle table through VFP remote view I have error message "Update conflict". Looking on internet I found one post that it is known VFP error related to the way how VFP sends fields of type varchar to Oracle (Rpad). Looks preaty catastrofic cause it eliminatas VFP as frontend with Oracle database. Did anybody knows more about it or found a workaround? Many thanks Tag: Pass data to Excel option button Tag: 205702
  - 18
    - Connect to SQL server I would greatly appreciate a sample of the syntax required to connect from VFP 6 to a SQL server - either one on my own machine or one that resides on another machine that I can access by IP address. TIA. -S- Tag: Pass data to Excel option button Tag: 205700
  - 19
    - location of db in de I'm playing around with different scenarios, and found this. In this app, the database consists solely of a connection and remote views, and is located in a subfolder of the project folder called data\. The database is included in the build. Forms are built with the data\ database in their data environment. At runtime, I open the database (no path, because it's included). I was concerned that the forms would not be able to locate their data, since the data\ folder does not exist at this time (I renamed the original to prevent confusion). Yet the forms seem to work fine. Can anyone elucidate? Is this behavior documented? Furthermore, I put a button on a form to display DBC(), and it shows c:\... runtime folder\data\databasename.dbc, even though the data\ folder and databasename.dbc do not exist on disk. (They could be temp files somewhere, but that's not what is shown.) Any help explaining this as a general and reliable rule would be appreciated. Tag: Pass data to Excel option button Tag: 205698
  - 20
    - multiuser problem Hi, I am using VFP6 SP4 and develope an application In the multiuser environment. The form's datasession is 2-Private Data Session In the init event of the form, have the following environment setting set exclusive off open database Mydata shared set multilock on select mytable = CURSORSETPROP('Buffering', 5, 'mytable') users access to the same form (same table), got the error message " File acces is denied " Does anything wroing here ? Please give suggestions thank your very much Tag: Pass data to Excel option button Tag: 205691
  - 21
    - Update Word links Hi foxpro experts, Once again I turn to you for some advise :) I have some Word documents that have linked objects, something like this : {LINK Word.Document.8 X:\\Path\Document.doc \a \f O \p}. Word stores a path to there objects, but once I copy them to a new place, the path is broken, and you have to update them. You can do this by hand ofcourse, but I would like to do it from Foxpro. I found a forum that where someone was able to make a macro to solve this issue, but I don't know enough about macro's to turn it into Foxpro code. I know how to go through "Story's" in Word, but not how to update the fields in there. Does anybody have a foxpro example on this or some help ? the forum is at : http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=wrd&Number=261488&page=&view=&sb=&o=&vc=1#Post261488 thanks very much ! Xavier, CPS Tag: Pass data to Excel option button Tag: 205688
  - 22
    - Change of Paper size programatiically Hi I am using VFP6.0 with Windows XP for a system with Multi-USer I got a report using a Paper Size - Letter. But on some computer the paper size will change depending on the setting of the computer Is there any ways to set the paper size of the report before REPORT FORM Regards, Hughs Man Tag: Pass data to Excel option button Tag: 205687
  - 23
    - Memory variables Vs Table buffering I learnt foxpro from an old foxbase programmer. I have only used up to VFP6. Ever since I collect memory variables from my input forms and update the tables field by field using the memvars. What benefit am I loosing by not using table buffering other than having to write more code(which I don't mind!)? How can I use table buffering when I need to do more than one record in a table (as in accounting entries)? Tag: Pass data to Excel option button Tag: 205685
  - 24
    - How can I get the list of files of a directory with the correct case of letters How can I get the list of files of a directory with the correct case of letters as they really appear and not in upper case as ADIR returns them. Demetrios, Greece Tag: Pass data to Excel option button Tag: 205683
  - 25
    - intellisense custom script Hi friends i've following intellisense script . when i type rk then it turns to "&& Rajani on 10/01/05". It saving lot of time for me when i write comments. ************* LPARAMETER oFoxCode Local lcRetval, lcCase,lccentury lccentury="SET CENTURY "+set('CENTURY ') SET CENTURY OFF oFoxcode.valuetype = 'V' && we want to return a value lcCase = oFoxCode.Case If empty(alltrim(lcCase)) lcCase = oFoxCode.DefaultCase && if not take default foxpro case endif lcRetval = '&' + '&' +'~' +' Rajani on ' + dtoc(date()) &lccentury && reset century Return lcRetval ********* abv code works beautifully without any problem. i am wondering if it is possible when i type my keyword(i.e. rk) on new line i want **Rajani on 10/01/05 if it is on a existing line then "&& Rajani on 10/01/05". any ideas on this will be great. Thanks -- cheers Tag: Pass data to Excel option button Tag: 205679
- Next
  - 1
    - Recordlocking VFP8-SP1 Struggling with multiuserenvironment... A textbox with myView.myField (buffermode 3) as controlsource B user 1 writes Hallo to the editbox and clicks in another texbox - fires the first textbox´s valid-code: SET REPROCESS TO 3 SECONDS lcAlias = 'myView' SELECT (lcAlias) LOCK(lcAlias) tableupdate(2,.F.,lcAlias) && returns T UNLOCK ALL C user 2 on workstation 2 can see Hallo in his textbox D user 2 can do the same ("Hallo again") as B above && no error is reported E User 1 can´t se Hallo again If I replace LOCK(), UNLOCK with tableupdate(2,.F.,lcAlias) && returns T Select tblComp1 (the views sourcetable!!!!!!!!) skip 1 everything works fine! but this can´t be the right way... What am I missing???? Best regards Christina Tag: Pass data to Excel option button Tag: 205673
  - 2
    - VFP web services I would like to set up an extremely basic web service application, just to get going. I only want an example that reads and updates a single field in a free table over internet. What would be the easiest way to achieve this - I don't have the time (or energy) to study hundreds of pages of web technology, and I would like to do it as much as possible within VFP 9.0. So - what's your suggestion? Tag: Pass data to Excel option button Tag: 205661
  - 3
    - Data driving a class Hi, I am attempting to data drive code that can contain several methods by creating a table 'script_def' with two fields:- * script_name c(10) * exec_txt m - contains code to create the class. The test program below selects the appropriate record, creates the class and calls a method. MESSAGEBOX confirms that the correct record is selected and that test_script.prg contains the text from the correct record. However the code from the record that was selected the first time is executed - the .fxp appears to be in memory. Attempting to compile test_script.prg or delete test_script.fxp causes an error 'outstanding references exist' Any help in getting this to work (or a better way to do it) would be appreciated. TIA, John Pugh Adelaide, South Australia * Test data driving a class IF NOT USED('script_def') USE script_def IN 0 ENDIF SELECT script_def LOCATE FOR script_def.script_name='two' MESSAGEBOX(script_def.script_name) SET SAFETY OFF =STRTOFILE(script_def.exec_txt,'test_script.prg',0) SET SAFETY ON MESSAGEBOX(script_def.exec_txt) LOCAL o_test o_test = NEWOBJECT("test_class",'test_script.prg','') =o_test.test_method() RELEASE o_test RETURN *************Code in record one of script_def********************************* * Test class for data driving DEFINE CLASS test_class AS CUSTOM PROCEDURE test_2 MESSAGEBOX('test_method called from rec 1' ) ENDPROC PROCEDURE test_method =THIS.test_2() ENDPROC ENDDEFINE Tag: Pass data to Excel option button Tag: 205656
  - 4
    - Product Purchase Help Its been a few years since Foxpro 2.0, Borland C++ 3.1, VB 5.0, Codebase 2.5 etc ... been off on other development tangents in the RS6000 world ... now have a client that needs some ACCESS database work ... I have been using ACCESS 2000 and not liking it very much ... ASP looks interesting ... but Im having no luck in narrowing down a dev tool to go forward with What am I looking for ... something current that I can create applets for distribution that don't require additional licencing on the users part. I have several Access databases that are 5 to 100MB that need to have multiple user access which will be deployed on Win2K Pro Serverless peer 2 peer machines Foxro used to have a licence free engine which could be packaged up with an application EXE as did VB ... What products would I need to do this today? there appear to be several flavours of Visual studio that claim the ability to develope in Foxpro, CSharp or VB Or am I better off getting a Visual Foxpro or VBasic I downloaded the free ASP webmatrix and played with SQL on a test database however the moment I attempted to connect to a 100M databas it crashed Thanx in advance Tag: Pass data to Excel option button Tag: 205636
  - 5
    - Tableupdate() retuns T but acts as F - vfp8/SP1 Two users runing an VFP-app on workstation A and workstation B conected to a LAN; 1 User A enter a textbox based on myView.myField 2 User B modifies the same textbox/field 2B User B leaves the TEXTBOX and it´s valid fires (lcSuccess = tableupdate(1,.F.,myView) && returns T) 2C User B don´t leave the RECORD in myView 3 User A can´t see the modification made by B. If user B leaves the record directly after the modifing everything works just fine. But if user B don´t leave the specific record - user A can´t see the modification. And an updateconflikt occurs. myView is optimistic rowbuffered, parameterized and contains one record only. Exclusive is set off. What´s wrong? Any ideas would be very appreciated. Best reards Christina Tag: Pass data to Excel option button Tag: 205626
  - 6
    - VFP 6: Large and Small Fonts I have read various posts about how large and small fonts affect Fox2 apps. How does it apply to VFP? I think I have a case of it. The symptoms: On one system, text is truncated in labels and command button captions. The form is the correct size, but the fonts are too big. How do I find out which font type is in use and the appropriate scaling factor? Sincerely, Gene Wirchenko Tag: Pass data to Excel option button Tag: 205625
  - 7
    - EventHandler() or....? Hello, I'm in the process of writing an IE automation interface and was wondering if EventHandler() is still the preferred way to go. I know that Drew Speedy has used BindEvents() extensively, but I don't know if it provides similar (or superior) capabilities regarding attaching event code to an automation server. Any thoughts/suggestions will be appreciated. Thanks. -- William Fields MCSD - Microsoft Visual FoxPro US Bankruptcy Court Phoenix, AZ Software will always be better when written at 105 decibels. -Whil Hentzen Tag: Pass data to Excel option button Tag: 205622
  - 8
    - c0000029 VFP8. This is a new one on me. This line of code causes this error: TRY IF (UPPER(SUBSTR(JUSTSTEM(DBF()),4,4) <> 'ZOOT' .AND. glVar glVar is undefined, and instead of jumping to the CATCH statement like it should, it crashes with c0000029. Tag: Pass data to Excel option button Tag: 205614
  - 9
    - is not an object Hi, on the thirth line I get an error llcallform is not an object ?! Does somebody know why and how to avoid. or Howelse can I check if something is an object then Type() ? in a forms.destroy llcallform = thisform.callform IF TYPE("llcallform") = "O" .and. .not. ISNULL("llcallform") llcallform.datform = "" ENDIF regards thanks in advance christophe Tag: Pass data to Excel option button Tag: 205604
  - 10
    - VFP7 cursoradapter tableupdate write order I have a situation where the order records are written (shown via audit triggers) is a bit odd. Basically I have code which updates 3 files via separate cursoradapters (buffermodeoverride=5) in one transaction. The cursoradapters can be Native or SQL Server. Cursoradapter 1 is scanned and updated 1 record at a time using tableupdate(.F.,.F.). Cursoradapter 2 is scanned and updated 1 record at a time using tableupdate(.F.,.F.). Cursoradapter 3 has a single record updated using tableupdate(.F.,.F.) Transaction ends The order the records are committed is as follows: All Cursoradapter 1 records except the last one updated. All Cursoradapter 2 records except the last one updated. Cursoradapter 3 record. Last Cursoradapter 1 record. Last Cursoradapter 2 record. Is there any way of getting the last 2 record updates committed before the Cursoradapter 3 record as it looks really odd in our audit and is bound to raise questions later? Thanks for any help. Bernie Tag: Pass data to Excel option button Tag: 205601
  - 11
    - HOWTO: Know VFP version from an .EXE, thanks to Rick Bean. Once again, this is a code I borrowed from this newsgroup to be posted at www.PortalFox.com, to support VFP communities in spanish language, thanks to Rick Bean... --- HOWTO: Know VFP version from an .EXE --- --- Obtener la version con que fue compilado un EXE de VFP --- http://www.panoramabox.com/GoPub.aspx?IdObj=2410 --------------------------- Espartaco Palma SysOp www.PortalFox.com Mexico Tag: Pass data to Excel option button Tag: 205592
  - 12
    - =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Continuing spreading the VFP knwoledge, here's a great code about Automating MS-Office with VFP. --- HOWTO: Inser Tables in a Word document --- http://www.panoramabox.com/GoPub.aspx?IdObj=2363 As usual, the site is in spanish, but the code is in Universal Language (VFP). HTH -------------------------- Esparta Palma SysOp www.PortalFox.com Mexico Tag: Pass data to Excel option button Tag: 205590
  - 13
    - VFP database stability What's the VFP 8 database stability? I tried (long time ago) to work on i'ts database in version 4.0 and and it was terrible (constant damages and inconsistency) - since then I work on plain dbf. Is it in version 8 any better? And btw what about fpt files in this version (fpt files often loses their record links with dbf's). Jader Tag: Pass data to Excel option button Tag: 205589
  - 14
    - Report Engine Error: Not enough system resources Hello, I am running Visual DBASE 5.5 on a new machine that was just installed with WinXP. The software runs on other machines, but for some reason when I try to runit on this newly configured machine, I get the following error: "Report Engine Error: Not enough system resources". I get it when I try to print a report with the built-in Crystal report tool. Does anyone have any idea as to why I am getting this error? Thanks, Eddy. Tag: Pass data to Excel option button Tag: 205585
  - 15
    - New Method Why is it after I define a new method: ie, GetRecord that Foxpro dies when I assign this method as follows: THISFORM.GetRecord ( and the moment I enter the ( I get the following error: Fatal Error Exception Code=C0000005. This Method has LPARAMETERS and I am simply trying to pass them. This is VFP7 with SP2 and thats as good as it gets. If I paste GetRecord ("Delete") it works fine, as long as I don't do this within the Foxpro environment... Am I missing some important update? Thanks for your help Tag: Pass data to Excel option button Tag: 205584
  - 16
    - Hiding main foxpro window Hi I am new to foxpro and am having a problem with the way it executes. In the program I call a form using a do form command and then a read events command right after it. I have compiled this and my form comes up with the data I want on it but theres a MicroSoft Visual Foxprow window behind it that I don't want to see. I assume its the window executing my code until the read events command. How can I hide this window? Thanks and cheers Jerry Tag: Pass data to Excel option button Tag: 205573
  - 17
    - Unable to find an API Can anyone tell me why I'm getting the following error when I try to compile my program? Program c:\source\vbpf\prgs\procedures.prg has the following errors: Unknown _WFINDTITL - Undefined Unknown _WHTOHWND - Undefined I have this line of code in my main program SET LIBRARY TO SYS(2004) + "FOXTOOLS.FLL" ADDITIVE I have this procedure in a different program PROCEDURE TileVertically LOCAL lnhWnd * Get the Active Form's window handle lnhWnd = _WhTohWnd(_WFindTitl(_SCREEN.ActiveForm.Caption)) * Get the form's parent window lnhWnd = otile.GetParentWindow(lnhWnd) otile.TileVertical(lnhWnd) ENDPROC Tag: Pass data to Excel option button Tag: 205566
  - 18
    - check if filename is legal Hi, Is there a way in Foxpro to check if a filename the user entered is legal before creating it ? thanks ! Xavier Tag: Pass data to Excel option button Tag: 205554
  - 19
    - outlook class with MDI form with pageframe Hi, Can anyone show me the code to create a pull down menu with following :- - outlook class at left hand side - mdi form with pageframe at right hand side - on click of outlook class button the mdi form change accordingly ? Regards Hoe Tag: Pass data to Excel option button Tag: 205549
  - 20
    - OLE error code 0x80020006: Unknown name All, I have a VFP7 application that manipulates the Outlook Inbox - searches for incoming emails and does some processing to them. One of my clients has just started receiving "OLE error code 0x80020006: Unknown name" on this line... m.FINDCNAME = UPPER(PADR(ThisForm.oItem.SenderName, LEN(cName))) Any clues? Thanks, Brian Tag: Pass data to Excel option button Tag: 205547
  - 21
    - sql cursor Hi, SQLEXEC(nConnect,'select * from mytbl') I read user guide that the result will be stored into cursor SQLRESULT. But when I call 'SELECT SQLRESULT', an error 'alias not exist' shown. What am I missing ? Regards Hoe Tag: Pass data to Excel option button Tag: 205544
  - 22
    - Hidden/protected object test function? Is there an easy way to test if an object is hidden or protected? I'm grabbing a likely property, BASECLASS, and using pemstatus(....,2). Just wondering if there's anything more direct. -Lew Tag: Pass data to Excel option button Tag: 205541
  - 23
    - VFP table lookup on a PDA Hi, I've got a fun new project, where people in the warehouse want to be able to key in a stockcode on a PDA and return data from from our central VFP tables about current stock levels and stock location over a wireless LAN connection. PDAs will be Windows Mobile based. I realise that native VFP apps won't run on these, but there are still a few different approaches to this - various web based ones, .NET apps, etc. I'm not sure which would be best, easiest or cheapest. (got .NET through MSDN as an option, but never had time to try it out seriously.) Is anyone running a similar app? Any pointers would be very much appreciated. Cheers, Neil Tag: Pass data to Excel option button Tag: 205539
  - 24
    - distributing DLL Hi friends I've created a DLL in vfp8.i want to distribute to some software vendors . my question is do i need to distribute vfp runtime files also along with my DLL? i tried using my DLL in VB on a machine which has no foxpro s/w and got runtime errors(like activex objects cant.....etc.,) but it worked fine when i copied vfp runtime files to the folder where my DLL exist. could u guys tell how you u normally distribute a DLL created in vfp. Thanks -- cheers Tag: Pass data to Excel option button Tag: 205531
  - 25
    - EXE size differs when I rebuild project. I have a project. I built the EXE about 2-3 weeks ago. This morning I build it again, and the EXE it produces is a couple hundred bytes larger. Nothing has changed, the project is kept in sourcesafe and I did a get latest into a clean directory. What would cause the EXE to be different in size when rebuilding it a few weeks later? I rebuilt it in the same directory structure, but my environment changed in that I have more mapped drives. I can't think of anything else that might have changed. Tag: Pass data to Excel option button Tag: 205529

caGood day everybody,

I am trying to control the Excel option button via VFP 8.0
Example : The option buttons in Excel are OptA, OptB, OptC
My user input "1" in my VFP form, I need to make OptA.value = True.
I tried macro recording in Excel but no code generate for option button
selection, so I have no idea how to program it.

I will appreciate if anyone can help me.

Have a nice day.

Best regards,
Julie

Top