Modify report

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
    - route Planner Has anybody experiences useing RoutePlanners within VFP?.I'm using an older Map&Guide version just now. It works fine, the data between VFP and MG were passed via Ascii-Files. The new version however has limited capabilities regarding batch processing and I'm looking for an alternative way. Thanks Michael Tag: Modify report Tag: 224218
  - 2
    - Is there a quicker way to remove selected items from MS listview Activex? Hi, Is there a better way to remove items from the Microsoft listview 6.0 activex control. Our current code is, but it takes a long time if the listview has 10,000 items etc. With This.Listview For a = .ListItems.Count To 1 Step - 1 If .ListItems(a).Selected .Listitems.Remove(.ListItems(a).Index) ENDIF EndFor EndWith Thanks Tristan Tag: Modify report Tag: 224217
  - 3
    - Mike Feltman at LA Fox, June 13 Mike Feltman of F1 Technologies (makers of the Visual Fox Express framework) will be doing the SoCal tour this month! Come on out to our user group to see a great presentation! Mike will also be doing our 7:00 PM Jump Start. The topic will be What's New in xCase 8.0. The main presentation will be Everything You Ever Wanted to Know About Docking in VFP. The topic description follows: Dockable forms and toolbars are becoming the norm in modern Windows desktop applications. VFP has supported dockable toolbars since VFP 3.0 and has long supported dockable forms as part of its IDE. VFP 9.0 now allows developers to create dockable forms in addition to toolbars. End-users and developers can take advantage of dockable forms and toolbars to easily customize an applications interface to suit their individual preferences. This session will look at dockable forms and toolbars from two angles. First, we?ll cover the mechanics of docking windows, tips for working with dockable windows in the Visual FoxPro IDE and programmatically manipulating the dockable windows (and some that aren?t) in the VFP IDE to customize the development environment. Second, we?ll look at practical uses for dockable forms in desktop applications, the differences between dockable forms and toolbars and we?ll cover the pertinent properties, events, methods, commands and functions that relate to docking. Users will leave this session with a better understanding of how to take advantage of VFP?s dockable windows in the development environment and how to take advantage of dockable windows to enrich the user experience in their applications. Please visit our web site at http://www.lafox.org for further details. See you then! Bill Anderson Tag: Modify report Tag: 224215
  - 4
    - fixing mappoint registry entries? we have an app that used to call mappoint.application to (using mappoint 2004 vfp9) for doing some mileage calcs. it was rewritten to use the mappointcontrol.ocx. it USED to work on my machine. during some testing the mappoint quit working (turned out to be our code) and we tried uninstalling/reinstalling mappoint. which proceeded to break using mappoint with old, new and inprocess program. we setup a new machine with vfp and mappoint and the code works now. my machine however is not working. i have reinstalled or repaired vfp, mappoint and office, w/o much luck. i started comparing registry entries between the new machine that works & mine. by exporting some mappoint related items i succeeded in getting the calls to mappoint.application in the older code to work. however, .reg imports related to mappoint.control and not doing the job yet. it appears that something is really fubared in the registry. i have 'registered' the .ocx with regsrv32 with no problem, but whenever our code tries to call the mappoint.control and setup the object to be used i get 'unknown member oMap'. it is failing to find (we presume) the control. any thoughts on how to trackdown the wayward registry entries or reg entry with perhaps wrong info would be appreciated. thanks. jim Tag: Modify report Tag: 224206
  - 5
    - Do I need a special DLL for e-mail? I have an old APP (v5) that had trouble when everyone got XP. Then I rewrote a part and compiled it into v6. We don't do an install when we get a new version, we just throw out the EXE on the network. But now, no one can do the e-mail anymore. I can do it on my machine, and I am wondering if there is some DLL that they don't have on their machines that I have. The code is using MAPISESSION. I thought it might be the mapi32.dll, or I must have an updated DLL (for V6) that they also need. Does this ring a bell for anyone? Thanks so much for any thoughts. Kelly Tag: Modify report Tag: 224203
  - 6
    - Keyboard Question My apologies if this ends up posted twice. It never showed up in the NG after the first time I posted it. Hello and thanks in advance for the help... Is there anyway to pass keystrokes to the OS keyboard buffer? The KEYBOARD command seems to stuff a keyboard buffer that is only seen by FoxPro. For example: I have a desknote application running that is listening for ALT+N to open a new note. If I type this on the keyboard, I get a new note opened up. If I issue the command KEYBOARD '{ALT+N}', nothing happens. I would like to be able to stuff characters into the operating system's buffer. Thanks again for the help. Jeff Tag: Modify report Tag: 224194
  - 7
    - Use HideDragon to Quick hide window, the best Bosskey! Use HideDragon you can hide any windows on your desktop easily by clicking the mouse's left and right keys together (or use the hotkey).To resume these hidden windows whenever you like by re-clicking the mouse key (or hotkey), and those hidden windows will redisplay. The tray icon at the right bottom corner can also be hidden or be run in the background. http://kinghome.51.net/en/XP_QuickHide.htm Tag: Modify report Tag: 224193
  - 8
    - adobe pdf & fox 6,7 and 9 Hello !! I have a word document into an "general" field ( texte1) i use this : oword=createobject("Word.application") with oword @ 1,1 say texte1 verb 0 nowait wait "" timeout 5 && wzit for word oword.visible=.T. oword.application.activate oword.activeprinter="Adobe PDF" && change printer .Wordbasic.Fileprint(0) oword.documents.close(0) .application.Quit(0) endwith release oword but , i dont know how to put the file name and the path for create the pdf. I want to create my pdf into c:\mydir\myfilename.pdf if somebody can help me. Thanks a lot Tag: Modify report Tag: 224192
  - 9
    - Keyboard Buffer Hello and thanks in advance for the help... Is there anyway to pass keystrokes to the OS keyboard buffer? The KEYBOARD command seems to stuff a keyboard buffer that is only seen by FoxPro. For example: I have a desknote application running that is listening for ALT+N to open a new note. If I type this on the keyboard, I get a new note opened up. If I issue the command KEYBOARD '{ALT+N}', nothing happens. I would like to be able to stuff characters into the operating system's buffer. Thanks again for the help. Jeff Tag: Modify report Tag: 224185
  - 10
    - "Use" command. Hi All, For now I have another questions that might drive you all attention to it. Well I now have two identical systems situated at different locations (computer A and B where they both are connected through local LAN and their project folder are shared). I'm in A and expecting to open a dbf file from B. For example: computer name: B project folder: projfdr dbf name: b1.dbf My code is like as follows; select 30 use '\\B\projfdr\data\b1' It jumps an error message of "Invalid Path or...". Please tell me what command I should use to open this dbf file. Thanks. Sam. Tag: Modify report Tag: 224183
  - 11
    - File is not open error Hello, I am trying to open a table and I get the File is not open error. I beleive something is corrupted in this table. Any ideas of how to fix it without losing the data? This problem table also has a direct connect to a another table. When I delete the index file I can view the table but the connection between the two tables is gone, how can I rebuild the connection? Thank you. Tag: Modify report Tag: 224175
  - 12
    - Remote view with olddb - how? I can create remote views using odbc - have done so for years. But how do you do it with oledb? It won't accept my connection string and selecting an existing dsn seems to only use odbc. Tag: Modify report Tag: 224174
  - 13
    - Grid's column Visible = .F. Hi all, I have this odd refresh problem with I hide a column programmatically in a form. After I hide a column and do a scroll to the right using the bottom right scroll button of the grid, the grid appears odd like the columns do not really moved and value of columns messing up. The grid display is okay if you click on the bottom scroll bar to scroll to the right though. -- Eric Lim Tag: Modify report Tag: 224172
  - 14
    - Sedna, du nouveau... http://www.microsoft.com/downloads/details.aspx?FamilyId=3A010370-4FC0-46F2-B495-C7C2F16930B1&displaylang=en -- Thierry Tag: Modify report Tag: 224163
  - 15
    - Report Amount format Q. How in a report can I format a negative amount to be in parentheses? ie: -100.00 to (100.00) Your help is greatly appreciated. Respectfully, Jonathan Morningstar ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: Modify report Tag: 224160
  - 16
    - uncommitted change Dear Sir/ Madam, I created a form and press a button with the command to operate the Edit mode. While I made amendment on a field (e.g. apple) of one of the records from the table, says abc.dbf, then when I close the edit mode, it¡¦s okay; but when I close the form with the button mentioned above, the error message was shown: =CursorSetProp(¡§buffering¡¨,THIS oldBuffering,aTablesUsed[m.i,1]) &&optimistic table buffering Error 1545 Table buffer for alias ¡§abc.dbf¡¨ contains uncommitted changes. Method: destroy Line: 68 How can I solve this with my scenario?? Thank you for your kind attention!! Patrick Tag: Modify report Tag: 224159
  - 17
    - Art Bergquist will speak at ChicagoFUDG on June 13 Chicago is one of the stops on Art Berquist's 2006 Lake Michigan tour. On June 13 he will be speaking on "Highly Effective Habits for VFP Developers." It promises to be a great overview of the best tricks, practices, and tips in programming techniques from a man who spends every working day in the VFP trenches. Art Bergquist is a Senior Consultant at Visionpace, and has extensive experience working on numerous Visual Maxframe Professional applications both as the sole developer and on a team. Art has contributed many VMP features and enhancements, is currently maintaining the framework, and frequently mentors developers at Visionpace and it's clients. He has also authored articles and tips in FoxTalk and FoxPro Advisor magazines (and has tech-edited articles for FoxPro Advisor), and has been a presenter at the San Diego and Orange County FoxPro Groups, as well as at Essential Fox, and has taught MaxStart sessions and VMP Boot Camp. Join us on June 13, 2006 at 53 W. Jackson Blvd., Suite 826 in Chicago's famous Loop. The door opens at 5:30pm. http://www.ChicagoFUDG.com Next month: Reserve July 11, 2006 to hear John Koziol on Sedna at CFUDG. -- Message posted via http://www.dbmonster.com Tag: Modify report Tag: 224158
  - 18
    - Sedna June 2006 CTP posted From http://msdn.microsoft.com/vfoxpro/letters/, by Milind Lele Sedna June 2006 CTP We have released the second CTP (Community Technology Preview) of Sedna. The June 2006 CTP includes latest builds of NET4COM and MY library for VFP. NET4COM is a library of COM wrappers around commonly used functionality from the .NET Framework 2.0. This allows these API to be called from Visual FoxPro. The library also includes source code and samples. The MY namespace is a native Visual FoxPro class library that contains similar wrappers for SYS() functions, Windows API and Windows Script Host properties and methods. The idea is to make a select few commonly used API accessible in a form that is easy to discover and navigate. ...... -- Cindy Winegarden MCSD, Microsoft Most Valuable Professional cindy@cindywinegarden.com Tag: Modify report Tag: 224157
  - 19
    - Obscure DOS path I am working in an old FPDOS application, and I see references like this: DO C:\#@1)0~!_\myprog.prg Can anyone tell me the signficance of that bizarre-looking path? Tag: Modify report Tag: 224151
  - 20
    - Foxpro now an "A" language http://www.tiobe.com/tiobe_index/index.htm Tag: Modify report Tag: 224138
  - 21
    - opening cash registers How in VFP 6 do I issue a command to open a paralell, serial or USB cash register? R Gallo OGES Systems Tag: Modify report Tag: 224135
  - 22
    - doEvents Does anyone know of a better method than fastDoEvents() to get the DOEVENTS command to process correctly? I am running with VFP 8 and even with using the FORCE option I am still having problems when embedding the webbrowser control onto forms. Essentially the system will do nothing until I move the mouse around which I think forces the events to fire. Tag: Modify report Tag: 224123
  - 23
    - The Domain www.bestnewsletter.eu is now for selling. The Domain for OVER 600 Million People in Europe. The Domain www.bestnewsletter.eu is now for selling. The Domain for OVER 600 Million People in Europe. Tag: Modify report Tag: 224110
  - 24
    - VFP 9 Report Designer Is it only my machine, or has anybody else experienced this. (using reportlisteners to preview/print ), The labels keep disappearing in Preview I have to include the table in the Datasession window, even though it is in the DE, to be able to pick fields from the Expression builder. Deleting an object refreshes the whole screen When doing multiple bands, the tables have to be related, even though the form calling the report has the initial table with corresponding paramatized view open. Only tables and no views in my experience... The bands have the view name in quotes as target aliases Get an error ".... is not related...". Cannot figure out "commandclauses". Listeners do not respect While or For clauses of the Report Form, Need to print only one parent record with multiple child records in 5 paramatized views. Kludgy as hell Sending email using successor listeners is erratic, on some machines it works perfect others the html report is out of whack Lines and labels not properly sized etc. All examples and the Pundits make a big deal about conditional formatting...cutesy red and blues etc... In the real world who gives a S.... I would rather be able to control output without having to write a convoluted program Wondering if its worth it. Why not make the report designer like a form, its kinda the same principle, both with a table in the backend.. Just drop classes, controls etc.. Now in this crazy world of specialists, a new breed of Report specialists is all we need. Tag: Modify report Tag: 224106
  - 25
    - The Domain www.bestwaypay.eu is now for selling. The Domain for OVER 450 Million People in Europe. The Domain www.bestwaypay.eu is now for selling. The Domain for OVER 450 Million People in Europe. Tag: Modify report Tag: 224101
- Next
  - 1
    - DevTrack, other bug track recommendations Can anyone recommend bug tracking software? Tag: Modify report Tag: 224099
  - 2
    - Outlook Email Automation I am trying to write an unattended email module for sending out notices using a timer based on certain conditions. I'm using Outlook 2002 SP2 and VFP9.0 SP1 and outlook redemption v4.1 to bypass the security check. All my emails keep getting routed back to my inbox as "Not Sent". I have tried the below code and MANY other iterations, with no success. There has to be a better way! Is there another solution? Am I missing something in Redemption? loOutLook=CreateObject("Outlook.Application") loRedemption=CreateObject("Redemption.SafeMailItem") && Create an instance of Redemption.SafeMailItem loMailItem=loOutlook.CreateItem(0) && Creates a new message loRedemption.Item=loMailItem && set Item property loRedemption.Recipients.Add("name@server.com") loRedemption.Recipients.ResolveAll loRedemption.Subject="Testing Redemption" loRedemption.Body="This is the test for the Redemption.Dll" loRedemption.Send loRedemption=.NULL. loOutlook=.NULL. RELEASE loOutLook,loRedemption HELP! Tim Cairns Tag: Modify report Tag: 224094
  - 3
    - something similar to shortname function in filesystemobject I have got a table of items, and I need to produce a unique but recognisable 8-character descriptor for each one. The problem is that the items might be so similar that the first 8 characters are the same. Is there a way of generating a 8-character descriptor like this. I am imagining something similar to the shortname function in filesystemobject to get a result like this: Widgets white (Widget~1) Widgets black (Widget~2) Acme (Acme) General (General) Grommets small (Gromme~1) Grommets large (Gromme~2) etc Many thanks Stephen Tag: Modify report Tag: 224091
  - 4
    - vfp Outlook Automation Hi, Using VFP 8, I can create an email in Outlook 2003 However, I have multiple email accounts in my Outlook 2003 How can I programmatically tell outlook which email account is to be used for sending the mail? Thanks in Advance Mahmud Abdulla Tag: Modify report Tag: 224084
  - 5
    - shortcutmenu alignment Hi, How can i align a menuitem in a shortcutmenu ? Cut (Ctrl+X) Copy (Ctrl+C) .... so it is possitioned on the left and rightside of the menu. Kind Regards christophe Tag: Modify report Tag: 224081
  - 6
    - DO MyMenu.mpr With myparameter ? Hi, DO MyMenu.mpr With myparameter, Where are the parameters send to when I've create the shortcutmenu with the menudesigner ? Or where should I place "LParameters myparameter" in ? Or is the With not used when I call a shortcutmenu. I have a textbox with a Rclick event which activates a shortcutmenu. and whould like to send the objectreference for that textbox to it so I can alter the textbox upon the users menuselection. Or is there maybe a workaround ? What I do now is a bunch o _screen.activeform.activecontrol but when the textbox is in a grid that is not very usefull. regards christophe -- Regards christophe Tag: Modify report Tag: 224077
  - 7
    - screensavers Is it possible to create a screensaver using vfp 8 and if so can anyone point me in the direction of some sample code Thanks in advance Dave Tag: Modify report Tag: 224075
  - 8
    - ComboBox and column I have ComboBox with ColumnWidths = '220,0' ( I want to hide second column) When list drops there is second column with no data in and with width about the width of scrollbars. How to remove second column. Tag: Modify report Tag: 224074
  - 9
    - Input field name (VFP9) I need to let the user suggest a field name for a free table. I use chrtran(cInputval, cCrapCharacters, "") to remove illegal characters. I feel that this way of doing it is a bit "home made". Is there any other good way to do it? Tag: Modify report Tag: 224072
  - 10
    - FoxPro and MySQL field size does not match Hi everybody, I am connecting via ODBC and sqlstringconnect to a MySQL server. Let's assum I have a numeric field named my_id with length 3 defined in the MySQL table "test_table". After connecting and doing a SQLExec "select my_id from test_table" the resulting FoxPro table will have a field length of 11 for the field my_id. That causes problems when displaying the no in a combo box. What's wrong here? Thanks for your help Andi Tag: Modify report Tag: 224067
  - 11
    - Local view and buffered table Hi all, Can I get data in local view from buffered table? In sample SELECT I can use WITH (BUFFERING=.T.), but I don't find way use something similiar with local views. Meskis Tag: Modify report Tag: 224048
  - 12
    - Test a SQLSTRINGCONNECT() connection handle This is a multi-part message in MIME format. ------=_NextPart_000_005F_01C6856E.9336B290 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, I create a Shared Connection Handle to MySQL using SQLSTRINGCONNECT()and = saved in a _SCREEN property, so far so good, in other parts of the = application I would like to test if this Handle is still a valid one, I = could not find a function that will allow me to do just that, then here = is the question: =20 What would be the way to test if my _SCREEN property for the = connection handle is still a valid one? Thanks! --=20 Edhy Rijo www.progytech.com Bronx NY ------=_NextPart_000_005F_01C6856E.9336B290 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.2873" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi all,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I create a Shared Connection Handle to=20 MySQL using <FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2>SQLSTRINGCONNECT</FONT><FONT face=3D"Courier New"=20 size=3D2>()</FONT></FONT><FONT face=3DArial size=3D2>and saved in a = _SCREEN property,=20 so far so good, in other parts of the application I would = like to=20 test if this Handle is still a valid one, I could not find a function = that will=20 allow me to do just that, then here is the question:  </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>    What would be the = way to test if=20 my _SCREEN property for the connection handle is still a valid = one?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks!</DIV> <DIV><BR>-- <BR>Edhy Rijo<BR><A=20 href=3D"http://www.progytech.com">www.progytech.com</A><BR>Bronx = NY</DIV> <DIV> </DIV> <DIV></FONT> </DIV></BODY></HTML> ------=_NextPart_000_005F_01C6856E.9336B290-- Tag: Modify report Tag: 224046
  - 13
    - Foxpro to VFP6 I have a number of source code applications in Foxpro 1. I purchased VFP6 when it was then offered, but I have not yet updated my old applications. A few questions: 1 - Does VFP6 have a separate runtime for inclusion with client applications? 2 - Should I update to VFP9, or would my current 6 be easier for me to re-code, since my programming skills still are back there with Foxpro 1? Thanks in advance. Tag: Modify report Tag: 224039
  - 14
    - time function Hi all, What is the best way to define a field in a table to contain Time? should it be a character or datetime? also, once it is defined in a table, how is best to utilize that field in a form? like what input mask should it have and how do you stop the user from entering an invalid time? Is there a control (or does anyone have one?) that could be dropped on a form that is already validated as a time field? Thanks HME -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: Modify report Tag: 224033
  - 15
    - finding procedures in a procedure file I came across some odd behavior today, and would appreciate feedback on this. To demonstrate the issue, create two files: File 1: zoot.prg Procedure zoot =zoot1() set procedure to =zoot1a() return File 2: zoot1.prg PROCEDURE zoot1 WAIT WIND `ZOOT1' TIME 1 RETURN PROCEDURE ZOOT1A WAIT WIND `ZOOT1A' TIME 1 RETURN Then in the command windows, DO ZOOT. It does the zoot1 wait window as expected. Surprisingly, it also does the zoot1a wait window. Why? I added the SET PROCEDURE TO line to clear any open procedure files, thinking that DOing zoot1 did an implicit SET PROC TO ZOOT1, but it still works. CLEAR PROGRAM stops it from working. Is this an undocumented feature? I was not aware that DOing a PRG file would load make all procedures in the PRG available, even after the top level procedure was exited, and therefore no longer in the call stack. We also discovered that suspending VFP would clear it from memory, as if VFP arbitrarily clears such stuff when it wants to or thinks it needs to. Tag: Modify report Tag: 224031
  - 16
    - Chado spell editor and mailmerge A post elsewhere had me asking about recordsets for use with Chado spell Editor, which now works. However mailmerging with the Chado spell-editor is proving rather troublesome, and whilst their help file is good, it doesn't cover vfp <sigh>. Has anybody done mailmerging with the recent Chado SpellEditor and could they give some pointers as to how to actually merge and print. Many thanks Stephen Tag: Modify report Tag: 224024
  - 17
    - VFP and ADO.NET I'm wondering if anyone has come up with a way yet to load ADO.NET data into a read/write BROWSE window. Thanks ahead for any leads. Tag: Modify report Tag: 224012
  - 18
    - ADO recordset This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C6840F.7BBD7EB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable This is a completely new area for me. I am looking at the Chado spell = editor, which now has mailmerge - great! However the reply to a query to = Chado states: Unfortunately, you have to use an ADO recordset in order to have = mailmerge work properly. What I have got in my application is a temporary cursor called CUSTOMER = from which I want to do the mailmerge. Could somebody handhold me through the commands I need to issue to get = an ADO recordset from this. Many thanks Stephen =20 ------=_NextPart_000_000E_01C6840F.7BBD7EB0 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.2873" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>This is a completely new area for me. I = am looking=20 at the Chado spell editor, which now has mailmerge - great! However the = reply to=20 a query to Chado states:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV>Unfortunately, you have to use an ADO recordset in order to have = mailmerge=20 work properly.<BR></DIV> <DIV><FONT face=3DArial size=3D2>What I have got in my application is=20 a temporary cursor called CUSTOMER from which I want to do the=20 mailmerge.</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Could somebody handhold me through the = commands I=20 need to issue to get an ADO recordset from this.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_000E_01C6840F.7BBD7EB0-- Tag: Modify report Tag: 224005
  - 19
    - Timer/Interval Q. Is there a Interval amount that cuts a timer off? Does 0 cut it off? Respectfully, Jonathan Morningstar ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: Modify report Tag: 224001
  - 20
    - Strange printing with reportBehavior to 90 In VFP 9 SP1, i've an invoice report containing - title - header - group header - 1 detail band - group footer (with new page) - page footer - summary (with new page) When i print it with reportBehavior set to 80, it works fine. (It works for many years !) When i print it with reportBehavior set to 90 - page 1 is correct - page 2 to n-1 have a blank space above (+- 5 cm) and the content seems to be vertically condensed - last page is correct There is no special code in the reportListener. Just created from the base class (VFP ReportListener, not the FCC) Any idea or tool to solve this problem. Thanks in advance, Guy Tag: Modify report Tag: 223998
  - 21
    - Which one is better option ? I am using Visual Foxpro 8.0. In my application i have two panes, on left pane i have product categories and on right pane respective products are being shown. Currently i am using FILTER command to show respective items. But it is getting slow and slow as data is increasing. Right now i have more than 10,000 records in products table and system is not responding quick enough. There is another way to do same job using INDEX command with FOR condition. Before going in any optimization work, i would like to have your expert opinion which option can work better for such kind of requirements. OR any other new suggestion. Thanks in advance. NR Tag: Modify report Tag: 223992
  - 22
    - New VFP multi-threading example posted I've updated the VFP MT example (at http://codegallery.gotdotnet.com/SednaY) based on Calvin's example to be sort of like .NET: Example Use: * t=CREATEOBJECT('testserver.thread') * t.start(5,"do c:\MTmyVFP\MyThreadFunc WITH p2") * && start method params:(1)#threads,(2)VFP code to MT,(3)Silent mode * ?t.check && returns .T. if completed * t=null && cleanup Simple, fast, efficient - it is VFP!! And, yes, it's really multi-threaded... Tag: Modify report Tag: 223991
  - 23
    - Inserting a page in a report - VFP 9.0 Hello, Within a VFP 9.0 report, i would like to insert a blank page between page 1 and 2, if the total number of pages of my report is uneven. Would be perhaps possible with the new reportListener object. But i don't see where to start. Thanks in advance for help, Regards, Guy Tag: Modify report Tag: 223990
  - 24
    - Items color in listbox Is there any way to have different colors for items in listbox (I want to have some items green, some red, some blue) Tag: Modify report Tag: 223987
  - 25
    - Opening Cursor aychee wrote: > *Re the above: > Forgive my stupidity it is the Hand_cursor I get not the wait_cursor > - the latter would be tolerable * Further stupidity (senility?) -I'm in the wrong forum. Trying to delete -- aychee ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Modify report Tag: 223983

At run time, the MODIFY REPORT with the Preview menu allow the user to test
the modification he has done in the layout.

I've noticed different behaviors between VFP9 and VFP8 (or before)
- VFP 8 : when there is an error in an expression in the layout, the preview
show a dialog box with the error and then directly open the properties of
the object causing the error.
- VFP 9 : when there is an error in an expression in the layout, there is no
error dialog box and the execution of the calling program continues at the
line after MODIFY REPORT

In VFP8, this was a pretty function to help the user to design correctly his
FRX.

Is it possible to obtain the same behavior in VFP9 ?

I use VFP9sp1 with reportbehavior set to 80 in this case.

Thanks in advance for help,

Regards,

Guy

Top