Reprot Grouping on multiple detail bands?

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
    - VFP8 won't install, won't run VFP 8 no longer runs on my box. It generates c0000005 on startup. I have deleted all foxuser files, cleared config.fpw. I uninstalled it with the installer, and that worked fine. I tried to re-install it, and it gives an error, so now I can't re-install it. I copied files from CD, which I have done before sucessfully, set them to read/write, but it still gives c0000005 on startup. VFP9 works fine on the same machine, other apps work fine AFAIK. Anyone run into this before? Tag: Reprot Grouping on multiple detail bands? Tag: 216808
  - 2
    - Anyone have experience with fingerprint scanners? Any tips, good sources of info, recommendations? -- You can reach me at: p one six seven (remove spaces and convert words to digits) at comcast dot net Tag: Reprot Grouping on multiple detail bands? Tag: 216799
  - 3
    - PC Install problem on certain Versions of Win XP with FoxPro 6.0B I have been using PC-Insall for years now, and lately I am unable to install successfully on certain versions of Win XP. The message states that the system file is not suitable for using MS-DOS or Microsoft Applications. Any ideas on what could be causing this message. Maybe autoexec.nt file settings? Thanks for any input. George Tag: Reprot Grouping on multiple detail bands? Tag: 216797
  - 4
    - delayed write errors We use vfp8. In the last few months we keep getting delayed write error messages. Data will be lost. We have lots and lots of free space. Our system gets very slow and after a few messages will freeze up and we must reboot the server. Is there any known reason for this? thanks sherry Tag: Reprot Grouping on multiple detail bands? Tag: 216795
  - 5
    - Is the paste offset user-definable? Through the years, I've gotten used to the fact that, in the VFP IDE, when you copy a control and paste it, the pasted copy is 8 pixels lower and to the right from the original location. Often, I am copying and pasting controls from one page or container to another and I want to retain the original location. Currently, I just automatically hit the left arrow 8 times and the up arrow 8 times to place the copy. I was wondering if this 8-pixel offset can be changed somehow. Anyone know? -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: Reprot Grouping on multiple detail bands? Tag: 216794
  - 6
    - Trouble upgrading to VFP 8.0 I have a large application that we need to upgrade to VFP 8.0. I already built the application using vfp 8.0. But, when i made a slight modification and tried to rebuild, it gave me these errors: Compiling c:\program files\m2mwinv5\formcust\m2mform.vcx .aecmaudits[xx, 8] = {01/01/1900} Error in line 4003 of m2mentryform.commitecmaudit (record 81): Ambiguous date/datetime constant. Use the format: {^yyyy-mm-dd[,][hh[:mm[:ss]] [a|p]]} .aecmaudits[xx, 9] = {01/01/1900} Error in line 4007 of m2mentryform.commitecmaudit (record 81): Ambiguous date/datetime constant. Use the format: {^yyyy-mm-dd[,][hh[:mm[:ss]] [a|p]]} I don't know where to find the dates that need to be fixed. someone told me that commitecmaudit was a new thing in VFP 8.0. Thanks for your help. Tag: Reprot Grouping on multiple detail bands? Tag: 216784
  - 7
    - FoxPro expertise gevraagd Wij komen graag in contact met een drietal Visual FoxPro programmeurs om werkzaamheden uit te voeren voor een Zorgverzekeraar die het gevolg zijn van veranderende wet en regelgeving. Start Asap, Locatie Eindhoven, 32 uur per week Belangstellenden kunnen hun CV e-mailen naar: SDMC Detachering BV e-mail: psanstra@sdmc.nl phone 0294 270019 www.sdmc.nl Tag: Reprot Grouping on multiple detail bands? Tag: 216777
  - 8
    - Reports 'suprpcol'? what is it? I've had a report for which fields just won't print on the first page no matter what the data or 'print when' settings are. When I open the report as a table the only difference between fields that print and don't is that the column suprpcol=3 on fields that print and 0 on fields that don't. If I hack the frx by manually changing suprpcol to 3 and save it then run the report those fields magically appear on the first page again. But I can't work out what suprpcol is or how it is changed in report designer. Does anyone know? LH Tag: Reprot Grouping on multiple detail bands? Tag: 216776
  - 9
    - Question about report dataenvironment class If I link a report to a dataenvironemtn class and then make some changes to the dataenvironment on a specific report, will these changes be kept when the dataenvironment class is updated and / or the report is run? Cheers David Tag: Reprot Grouping on multiple detail bands? Tag: 216775
  - 10
    - Inserting characters in a memo field Hi everyone, Is there a way to insert a number of characters in a memo field? I may want to insert 2 words at the 20th position or 40 characters at the 1st position and so forth... Thanks Hutch -- --------------------------------------------------------------------- "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: Reprot Grouping on multiple detail bands? Tag: 216771
  - 11
    - October 2005 letter on Visual FoxPro web site October letter at http://msdn.microsoft.com/vfoxpro/letters/. This month's letter contains information about new content online about Visual FoxPro 9.0, news about the SP1 for Visual FoxPro 9.0 beta download, more in-depth information about Microsoft's roadmap for Visual FoxPro, plus recent content and community news. There is a new one hour audio podcast (MP3) interview on the FoxShow, FoxShow #24: Interview with Ken Levy with mentions of various members of the VFP team, Sedna, transparency, VFP roadmap, etc. Ken Levy VS Data Product Manager Microsoft http://blogs.msdn.com/klevy http://msdn.microsoft.com/vfoxpro -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy_winegarden@msn.com www.cindywinegarden.com Blog: http://spaces.msn.com/members/cindywinegarden Tag: Reprot Grouping on multiple detail bands? Tag: 216767
  - 12
    - C0000005 on Windows2003 Hi, The following code (VFP8(SP1), MSXML4(SP2)) works properly on WindowsXP Professional(SP2) and Windows2000 Server(SP4) - parsing error is caught by a handler. The same code doesn't work correctly on Windows2003 EE(SP1) - C0000005 is raised. **************************** Local loException,rdr,hnd try rdr = CreateObject("MSXML2.SAXXMLReader.4.0") hnd = CreateObject("_XMLValidator") rdr.errorHandler = hnd * Valid XML rdr.parse("<catalog><book id='bk101'></book></catalog>") =MessageBox("Valid XML") * Invalid XML rdr.parse("<catalog><book id='bk101'></book></cataloge>") =MessageBox("Invalid XML. This message should never appear.") Catch to loException =MessageBox(; Ltrim(Str(loException.ErrorNo))+; loException.Message+; Iif(IsNull(loException.Details),""," "+loException.Details)) Finally EndTry Define Class _XMLValidator as custom IMPLEMENTS IVBSAXErrorHandler IN {F5078F18-C551-11D3-89B9-0000F81FE221}#4.0 &&"c:\windows\system32\msxml4.dll" **** IVBSAXErrorHandler PROCEDURE IVBSAXErrorHandler_error(; oLocator AS VARIANT, strErrorMessage AS STRING @, nErrorCode AS Number) AS VOID; HELPSTRING "Receive notification of a recoverable error." * add user code here =MessageBox("Error") ENDPROC PROCEDURE IVBSAXErrorHandler_fatalError(; oLocator AS VARIANT, strErrorMessage AS STRING @, nErrorCode AS Number) AS VOID; HELPSTRING "Receive notification of a non-recoverable error." * add user code here =MessageBox("Fatal Error") ENDPROC PROCEDURE IVBSAXErrorHandler_ignorableWarning(; oLocator AS VARIANT, strErrorMessage AS STRING @, nErrorCode AS Number) AS VOID; HELPSTRING "Receive notification of an ignorable warning." * add user code here =MessageBox("Ignorable Warning") ENDPROC ENDDEFINE ****************************** Please, advise Thank you. Tag: Reprot Grouping on multiple detail bands? Tag: 216761
  - 13
    - Calling a Crystal Rpt file version 11 from VFP I see code for calling other Crystal versions from VFP but I am wondering how to do this for version 11. Thanks in advance. Tag: Reprot Grouping on multiple detail bands? Tag: 216753
  - 14
    - ODBC for remote views Have always used ODBC to access data remotely in VFP 6. Been told this method is "outdated". The application primarily reads SQL data. Is ODBC still the most reliable and (more importantly) fastest method of accessing remote data in VFP6? - Ben Tag: Reprot Grouping on multiple detail bands? Tag: 216752
  - 15
    - memo field Hi All, I have a table with memo field created in FoxPro 2.6. We've been using VFP 6.0 and now we want to move the data to SQL 2000, I have tried using the DTS, (comes with SQL 2000), to transfer the data, but some of the contents in the memo field are missing. Does anyone have a better way to transfer table with memo field to SQL 2000 without lossing contents in the memo field. Many Thanks, Nancy Tag: Reprot Grouping on multiple detail bands? Tag: 216750
  - 16
    - resend: Windows Fax Service i'm able to send out fax using xp fax service. but how can i extract send status from Fax like what we see in fax consol in Foxpro ? Thanks! Tag: Reprot Grouping on multiple detail bands? Tag: 216746
  - 17
    - VFP9 report data environment display bug I have a report data environment with many tables and many relations (> 20 tables up to 5 levels deep). Works fine in report data environment. However when I save the data environment to a dataenvironment class and reuse it on another report, the layout of the tables in the data environment is lost. They just appear in a straight line across the data environment designer. This in its self is not the problem, just an annoyance. The problem is that at some point, I can not get to the tables on the far right side of the data environment designer. The relation lines go off the right side and no matter what I do, I an not get to the tables to reorganise them. I tried resizing the form every which way, resiizing the screen resolution. Even tried editing the table directly. So, how can I get to these tables to lay them out neatly? Cheers David Tag: Reprot Grouping on multiple detail bands? Tag: 216743
  - 18
    - Dataenvironment Is there any way to preserve the layout of the data environment once it is saved to a datanevironment class and reused on a report. It seems to lose the entire layout and reverts to a straight line across the dataenvironment designer.. Cheers David Tag: Reprot Grouping on multiple detail bands? Tag: 216742
  - 19
    - Populate web page fields Hello, I need to populate a form on a web page with data from a single record. How do I map a table field to a web page field and then do the web page population? Make sense? Thanks RH Tag: Reprot Grouping on multiple detail bands? Tag: 216739
  - 20
    - function syntax hi all, just to make this simple. I want to call a function, pass 3 parameters to the function and I want the function to pass back the total of the 3 parameters and the product (parm1 * parm2 * parm3). I thought the following will do it, but it doesn't. How is it done? Function returnvalues(parm1,parm2,parm3) numadded=parm1+parm2+parm3 nummultip=parm1*parm2*parm3 RETURN (numadded, nummultip) ENDFUNC thanks Hutch -- --------------------------------------------------------------------- "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: Reprot Grouping on multiple detail bands? Tag: 216731
  - 21
    - Error instantiating Class I can't seem to get rid of this message whenever I open this form. I am asked for the location of the Class, point it to the proper place and then save. My efforts at executing Project->Build, Project->Refresh, Project->Clean Up Project will not make this message disappear. I am Using VFP 9.0 and hope I do not have to completely rebuild this form! Thanks for your help Tag: Reprot Grouping on multiple detail bands? Tag: 216727
  - 22
    - web service : using FFC\_WS3Client.vcx hi i have a small dll ( VFP 9 - mult subproc ) for consuming a web service i instantiate the dll on My PC with CreateObject and it's all right then, i put the DLL on the server i instantiate it with CreateObjectEX up to this point it's all right ... BUT it can't get the reference to "web service" at the method SetupClient( ) i'm using the FFC\_WS3Client.vcx class any idea ? thanks -- atte, Hernán Tag: Reprot Grouping on multiple detail bands? Tag: 216719
  - 23
    - OLE Automation and Window handles I am working with automating some barcode label software in VFP 9. One of the OLE functions is used to draw a preview image of the barcode label in an image object. The parameter of the function requires a handle to the control that I want to paint the image in. This can be accomplished in Visual Basic by using the hWnd property of the image control. VFP does not have this functionality that I am aware of for controls. 1.) Is it possible to use this method of painting in an image control in VFP 9? 2.) If not, is it possible to use a form and draw the label preview directly on the form using the form's hWnd propery, maybe by using GDI? Thanks for any help you can give. Tag: Reprot Grouping on multiple detail bands? Tag: 216715
  - 24
    - update conflict I have code like its CREATE SQL VIEW wfzby REMOTE CONNECTION dbccon AS ; select * from wfzby append blank repl ne with xx &&" 1001" tableUpdate(.t.) refresh() requery() skip -1 skip +1 replace rt with '1' skip -1 * here is error skip +1 what is wrong that is error: conflict update? Adam Rataj Tag: Reprot Grouping on multiple detail bands? Tag: 216699
  - 25
    - Who Dunnit? Thanks in advance for the help. I have a nightly job which sometimes fails to run because a user stayed in the application and the nightly job can't get exclusive access to the files which need to be updated. I have the following questions: 1. Is there any way for me to get VFP to tell me which user has the file open? 2. Is there a way (that works) to have applications terminate at a specific time? I tried putting a timer on the main form but if the user stays in a sub-form, it never gets back to the main form (or the main form timer fires but can't close the app because a sub-form is open). Do I need a timer on each form? Do I need to write a routine like: FOR EACH OPEN FORM OpenForm.Close() NEXT If that is the way to go can someone tell me the actual code that will do this? Thanks, Jeff Tag: Reprot Grouping on multiple detail bands? Tag: 216698
- Next
  - 1
    - error (108) "File is in use by another user" I have "discovered" that this can prevent a table opening ie if the file is in use with a REPLACE FOR/WHILE then another user cannot open the table. Is this correct or am i missing something?? i know i have set reprocess to 1 but i'm just trying to open the table not edit it Greg Tag: Reprot Grouping on multiple detail bands? Tag: 216691
  - 2
    - Update syntax problem I try the following syntax in command window. but got errors. Does anyone can help me to correct it ?? Thanks in advance update blcostheader set jobperiod = jobheader.jobperiod from blcostheader ,jobheader where jobheader.jobno = blcostheader.jobno Tag: Reprot Grouping on multiple detail bands? Tag: 216684
  - 3
    - Network Drive is there a function that can determine this drive is a NETWORK? Tag: Reprot Grouping on multiple detail bands? Tag: 216683
  - 4
    - Default Directory Hi all, I am not sure why this is working like this. What am I doing wrong? all I want is to allow the user to select a directory and I want to set this selected directory as the default directory. here is the code: CLEAR tempdir = Getdir() && I am selecting the C:\Casino directory ?tempdir Set default To SET DEFAULT TO ("&tempdir") ?"Default Dir= "+SET('default') SET path TO (HOME() + 'ccalps') Additive ?"path =" +SET('path') and here is the output: (Notice how the Default Directory is showing as C: only !!!!!!) c:\casino Default Dir=C: path=C:\Program files\microsoft visual foxpro9\ccalps -- --------------------------------------------------------------------- "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: Reprot Grouping on multiple detail bands? Tag: 216676
  - 5
    - Running application installed by InstallShield Limited edition for VFP as limited account Hi, I have an application, which I install with InstallShield Limited edition for VFP. It has some ActiveX controls, and also I use several merge modules After installing, application works fine if I run it logged as Admin But if I try to run it logged on a limited account (which is member of users group only), I get an error, Class not registered (when application try to create an ActiveX object instance) I had another problem early, with write access in application root folder (because it is installed in Program Files), but I manage to handle it, by setting Permissions for install folder: I created an entry Users, and give it all rights. I try the same for ActiveX I use in my project (setting full permissions for them individually to Full) but still don't work Can anyone give me a suggestion howe to handle it? Thank you Bogdan Zamfir Tag: Reprot Grouping on multiple detail bands? Tag: 216670
  - 6
    - working with to records. i have a table, and it has 101 records in it. 2 records for each person. i want to subtract field1 record 1 from field2 record2 of the same person and replace the value of field 1 with the result. is that asking to much without having to create a temp table? Tag: Reprot Grouping on multiple detail bands? Tag: 216659
  - 7
    - Report Form xx PROMPT vs. Default Printer Hi All, Ever experienced super small 1/4 size printing on a report? In circumstances where you use the PROMPT and NOPAGEEJECT options on the REPORT FORM command so that the user can select the printer desired and so that a subsequent report will be part of the same print job, the subsequent report will always use the default printer driver no matter what printer the user selected. IOW, the PROMPT option of the report command only effects that specific report and not all the reports that are part of the same print job. Example: REPORT FORM A1 TO PRINTER PROMPT NOPAGEEJECT NOCONSOLE REPORT FORM A2 TO PRINTER NOCONSOLE If the user selects any printer other than the default when prompted the two reports above that are both part of the same print job will be printed to the same printer using different printer drivers for the first and second reports. (Keeping them part of the same print job is really handy when printing to a PDF file) . Using the wrong printer driver for a report going to a printer can give you strange results. Is there a way to force multiple reports that are part of the same print job and all going to the same printer to use the printer driver that is related to the PROMPT selection made on the first report? I have resorted to placing a sys(1037) in code just before my report rather than using the PROMPT option on a REPORT FORM command, to change the default printer. It is a kludge and does not present as nice a user interaction as the prompt option but it works. This seems like a minor bug to me... Anyone have a new information or ideas? -- Alec Tag: Reprot Grouping on multiple detail bands? Tag: 216649
  - 8
    - Wish list : TOTAL... EXCEPT ... How about : TOTAL ON ID_EQUI TO m:\matable.dbf EXCEPT ID_EQUI Fabien Tag: Reprot Grouping on multiple detail bands? Tag: 216648
  - 9
    - Wish list: update sql How about a: update <TableName> from name <ObjectName> where .... Tag: Reprot Grouping on multiple detail bands? Tag: 216643
  - 10
    - form.click()? A form with a textbox. Click the textbox. enter a few characters. then the mouse click outside the textbox. what event is fired? Definitely not form.click().... -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.6.13 ^ ^ 21:57:01 up 9 days 43 min load average: 1.02 1.02 1.00 Tag: Reprot Grouping on multiple detail bands? Tag: 216640
  - 11
    - SourceSafe hangs when multiple users access anything at the same t Does anyone else have the problem when using Visual SourceSafe and two or more developers start up VFP (or one starts up and another wants to modify a form) at the same time. Basically it seems hang when multiple users do anything at the same time, that accesses the VSS database. It hangs until one of the users kills VFP. It seems wired that this would happen when the purpose of SourceSafe is to allow you to develop in a multi-user environment. Has anyone else experienced this or is there something we could try to solve this? Thanks, Jerry Tag: Reprot Grouping on multiple detail bands? Tag: 216639
  - 12
    - call32.dll questions I've been using Rick Strahl's call32.dll from FPW with fairly high success on Win95 and ntvdm under 2K and XP. It can be a bit painful at times (eg just trying to Declare32 a non existant function name will throw a GPF instead of something friendlier.) There's also an annoyance when trying to RegFN() - if you pass the whole path to the dll then the second and subsequent attempts to register a function claim there is no function of that name within the dll. Relative paths seem OK but since I can't be sure of current directory I found the easiest thing to do was change default to dll directory, register the functions and then change default back. Anyway, sometimes after a few function calls, a GPF will be thrown just trying to call any function in call32. It is always the same GPF and it persists between FPW sessions. I have found that if I kill off the ntvdm process using task manager then it starts working again (or, of course, reboot. Merely exiting all 16bit applications doesn't stop wowexec and ntvdm, they are left running for a quicker startup if you run another 16bit application.) Does anyone have any idea why it seems to go a bit screwy after a while? It's a little annoying because I thought I'd got it working stably but now I've put it into production the flakiness has been exposed. All the examples I've seen for calling functions in external dlls don't do anything to tidy up afterwards and I wonder if this is the problem? The next thing I'm going to try is the latest version of call32.dll, it was originally written for VB and Rick took the source and added a few other functions that may be useful to Foxpro programmers. The latest version has been updated a couple of times since Rick's build and there is an extra function to free libraries used. Anyone else have any experience with this module? -- TIA Andrew Howell Tag: Reprot Grouping on multiple detail bands? Tag: 216634
  - 13
    - discrepancy between keyboard an mouse I have an textbox with an input mask of "999,999.99" The value is "0.00" Then the user used the mouse and hit the space on the left of the leftmost "0" in "0.00" and typed "1" The field now displayed like "1 0.00". If I used the mouse to exit the field (by hitting somewhere else in the from, the value become "10.00" If I hit <ENTER> key, the value becomes "1.00", which was what the user expected. Now, how could I make the mouse hit to behave as keyboard? -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.6.13 ^ ^ 19:42:01 up 8 days 22:28 load average: 1.00 1.02 1.00 Tag: Reprot Grouping on multiple detail bands? Tag: 216633
  - 14
    - Screensaver Question I'm trying to deactivate the screen saver programatically using SystemParametersInfo DECLARE INTEGER SystemParametersInfo IN user32; INTEGER uiAction, INTEGER uiParam,; INTEGER @pvParam, INTEGER fWinIni when I use SystemParametersInfo(SPI_GETSCREENSAVEACTIVE, 0, @lnTemp, 0) or SystemParametersInfo(SPI_GETSCREENSAVERRUNNING, 0, @lnTemp, 0) I can detect whether the screen saver is running / active etc but neither SystemParametersInfo(SPI_SETSCREENSAVEACTIVE, .T., @lnTemp, 0) or SystemParametersInfo(SPI_SETSCREENSAVERRUNNING, .F., @lnTemp, 0) will turn it off, I've tried using .T. or .F. but it doesn't make any difference. Does anybody use these successfully? What am I doing wrong? Thanks LH Tag: Reprot Grouping on multiple detail bands? Tag: 216629
  - 15
    - Autosize Problem I have a generic form with a label that is passed a variable size caption. I set the caption in the Init method. Autosize is set to .T.. I then resize the form in the Activate method in relation to the change in the size of the label. This works fine in VFP 8.0, but it doesn't work in 9.0. In 8.0, the change in size is recognized at the time of the Activate method, but this is not the case in 9.0. I can create a breakpoint in the Activate method and step through the critical lines of code and it will recognize the autosize change. Any suggestions? Rick Tag: Reprot Grouping on multiple detail bands? Tag: 216628
  - 16
    - Select from an Array Can you do this? I have a single dimension array containing a list of different widgets. I would like to count the quantity of each widget in the array. Can I use a select statement for this? tia Tag: Reprot Grouping on multiple detail bands? Tag: 216616
  - 17
    - Adding a picture to a general field VFP9. I want to programmatically add a picture (e.g. a .gif file) to a general type field for use in a report. I couldn't find how to do this in the doc. I tried the APPEND GENERAL command and looked at the sample, but my results only put the file name in the field and no picture showed on the report. I can do it interactively in the report designer, but I want the user to select the file for his/her own logo. Thanks for any help. Steve Meyerson Tag: Reprot Grouping on multiple detail bands? Tag: 216615
  - 18
    - Object class is invalid for this container When I try to copy an OLE control from one class library into another, I get the error message "Object class is invalid for this container". Obviously that's a mistake, because the class already exists in a class library. Any suggestions? Tag: Reprot Grouping on multiple detail bands? Tag: 216611
  - 19
    - Wish list: append from name <ObjectName> Any support for this? -Lew Tag: Reprot Grouping on multiple detail bands? Tag: 216606
  - 20
    - Difference between fdate(,1) and ftime() Can anyone explain this, please? -Lew Tag: Reprot Grouping on multiple detail bands? Tag: 216605
  - 21
    - MS Word Problem Lee: Thanks for the suggestion, but that caused no difference. It should also be noted that MS Word starts and opens the original document, but then displays an error "This cannot be completed because of a dialog or database engines failure. Please try again." Thanks. BR I can't reply to the earlier question. I get an error with an Infortion icon and 3 choices, but no words.? Tag: Reprot Grouping on multiple detail bands? Tag: 216603
  - 22
    - MS Word Merge problems using VFP 9.0 I am having a lot of problems getting a MS Word Merge to work from VFP 9.0. I swear it used to work in 6.0. I am getting the error message "OLE IDispatch exception code 0 from Microsoft Word: Word was unable to open the data source..." Below is a majority of the code. The last line is what generates to error. TIA for taking a look. Thisform.Wordmailmerge1.cSQL = "" Thisform.Wordmailmerge1.cDataPath = SYS(5) + CURDIR() Thisform.Wordmailmerge1.cDataSource = "OUTPUTER" Thisform.Wordmailmerge1.cFormLetter = ALLTRIM(THISFORM.PrimaryDOC.VALUE) Thisform.Wordmailmerge1.lSave = .T. Thisform.Wordmailmerge1.cSaveAsFolder = FOLDERNAMEIS Thisform.Wordmailmerge1.cSaveAsName = FILENAMEIS Thisform.Wordmailmerge1.Merge Local oWord, lcFileName, lcConnectionString, oFormLetter If Empty(This.cSQL) Then This.cSQL = "SELECT * FROM " + This.cDataSource Endif lcFilename = addbs(This.cDataPath) + This.cDataSource + ".DBF" If !Directory(This.cDataPath) Then Messagebox("Invalid Datapath specified : " + This.cDatapath, 0, "Error") Return Endif If !File(Addbs(This.cDatapath) + This.cDataSource + ".DBF") Then Messagebox("Datasource " + addbs(This.cDatapath) + This.cDataSource + ".DBF does not exist", 0, "Error") Return Endif If !File(This.cFormLetter) Then Messagebox("Form Letter " + This.cFormLetter + " does not exist", 0, "Error") Return Endif lcConnectionString = "DSN=FoxPro Files - Word;UID=;PWD=;SourceDB=" + This.cDataPath + ";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=MACHINE;Null=Yes;D eleted=Yes;" On Error Do MSMergeError oWord = GetObject(,"Word") *ON ERROR DO errhandler WITH ERROR( ), MESSAGE( ), MESSAGE(1), PROGRAM( ), LINENO( ) ON ERROR If Type("oWord") != "O" Then oWord = CreateObject("Word.Application") If Type("oWord") !="O" Then MessageBox("Unable to start MS Word", 0, "Error") Return Endif Endif With oWord .visible=.t. EndWith lnSelectArea=select() oWord.Documents.Open(This.cFormLetter, .F., .F., .F., "", "", .F., "", "", 0) oFormLetter = oWord.ActiveDocument oWord.ActiveDocument.MailMerge.OpenDataSource(lcFilename, 0, .F., .F., .T., .F., "", "", .F., "", "", lcConnectionString, This.cSQL, "") BR Tag: Reprot Grouping on multiple detail bands? Tag: 216592
  - 23
    - How do you read postdata in a webbrowser control? I'm working on a VFP project for engineers designed to help them collect descriptions, links and images from manufactures sites to simplify creating design documents. Part of the time saving aspect of this project is to reduce the dozens of times each day they have to logon to each manufacture site and search/navigate to the pages they need for their projects. To accomplish this for non-programmers I need a way to capture POSTDATA from the beforenavigate2 event. I believe the datatype is a safearray. I've found code that is for VB that uses lenb and midb functions. It looks like this: Private Sub ctrlWB_BeforeNavigate2(ByVal pDisp As Object, URL As Variant, Flags As Variant, TargetFrameName As Variant, PostData As Variant, Headers As Variant, Cancel As Boolean) If pDisp Is ctrlWB.object Then Dim lCount As Long Dim lLen As Long Dim strPostData As String lLen = LenB(PostData) ' Use LenB to get the byte count If lLen > 0 Then ' If it's a post form, lLen will be > 0 For lCount = 1 To lLen strPostData = strPostData & Chr(AscB(MidB(PostData, lCount, 1))) ' Use MidB to get 1 byte at a time Next MsgBox strPostData End If End If End Sub But I can't seem to figure out what I need to do in VFP to capture and use this data. Many thanks in advance! Tag: Reprot Grouping on multiple detail bands? Tag: 216591
  - 24
    - VFP 6.0 and Network Access Storage (NAS) Our Win2K server was recently migrated to Oa new NAS (Network Attached Storage) device. Since this time, some of our application have been receiving 'Cannot Update Cursor' errors. I've narrowed it down to when a 'PACK' command is issued. The application utilizes a control file that stores folder names in it associated with the server on the Q:\ drive (i.e. Q:\TEST). The application has been running for years and hasn't had updates in the past 9 months. Since the NAS migration, these errors have been experienced. Any thoughts on how to get around this? It is my understanding that this NAS device uses a Linux OS - so my guess is there are compatibility issues. Tag: Reprot Grouping on multiple detail bands? Tag: 216590
  - 25
    - Advice for first time "contractor" I've been programming (in FoxPro) for around 10 years and working at it (W2) for 8 or so. I've had quite a few jobs. I am sometimes asked if I want to work as a contractor or as an employee and I have always said "employee" mainly because I've always done that. I figured I could probably easily take those jobs on a contract basis and figured that someday I'd have to (or even want to) but that day hasn't come until today. A recruiter got my resume off an employment recruitment site and has been lining me up for a position at one of their client companies and yesterday I was told that the decision has been made that I get the job (starting Monday). I am to be paid on an hourly basis as a contractor. They emailed me papers to sign yesterday. Generally, when I sign preemployment papers I scan them and sign, have a general idea what it's about, the legalese notwithstanding. Since I was at home this time, at my "leisure," I took the time to read this stuff carefully. Most of it looks pretty OK, although I'm rather inexperienced at this, obviously. There's a nondisclosure agreement, a W9 form - pretty standard stuff. Then there's the 5 page contract with an "Exhibit A" tacked onto that, being a purchase order for my services. That's a bit weird from my perspective, but probably standard, I figure. It states my hourly rate, basically, with a sentence or two with yet another guarantee by me that I won't make any agreements with the 3rd party for a year after the completion of my assignment, things of that nature. In the contract they want me to guarantee that if I do start working directly with their client, I will fork over 20% of my salary. I guess I'm OK with signing on that. However when I got to paragraph 12 in the contract, I did a double take: 12. INSURANCE. Contractor will obtain for itself and its personnel before providing services, at its own expense, comprehensive General Liability insurance coverage for projects covered by this Agreement, for limits of liability not less than $500,000 and will name <insert name of recruiter here> as an Additional Insured, provide a copy of the binder and policy to <insert name of recruiter here>, and hold <insert name of recruiter here> harmless for any damages or expenses, including attorney's fees, incurred as a result of misconduct of Contractor or its personnel involving <insert name of recruiter here>, the TPU (third party unit), or any customer of client of the TPU. Now, that's something I wasn't prepared for and I figure I'll be calling them first thing in the morning - their office won't be opening for at least 3 hours. You people with experience, can you tell me what this is about? Are they going to waive this for me? I can't believe that they recruited me with the assumption that I already have an insurance policy of this nature and didn't ask me up front. I'm a computer programmer, and they were careful to check out my references before making me the offer. In the past, the trust inherent in that type relationship has floated my boat. Please, in addition to answering that specific question, can I get some tips and hints to give me a more solid footing in embarking on my first gig as a contractor? I've had quite a few contractor-like assignments, but never actually been on a contract basis. I always figured it was going to be principally a matter of filling out some different or extra IRS forms, but I guess there's more to it. For one thing, it looks like I'm going to have to manage my own withholding of federal and state taxes and SS. Do I do that at tax time or do I have to manage that during the work year? This job is 6 months+ (I'm told it's funded for a year, possibly with extensions) but I will be on a trial basis, especially at the start. The TPU is contractually entitled to send me home for any reason at any time. The contract seems to carefully stipulate that I'm entitled to zero benefits, just my hourly rate with no possibility of extra compensation for overtime, no possibility of being compensated for training of any kind, etc. I am in California. Thanks for any help. Tag: Reprot Grouping on multiple detail bands? Tag: 216589

Is there a way to do grouping on individual detail bands in a multi band
report?

I have an invoice that prints parts and labour from 2 different tables.
Works really well.

I want to sub group the labour by Site ID, but not the parts. I this
possible?

Cheers
David

Re: Reprot Grouping on multiple detail bands? by Dan

Dan
Wed Oct 05 11:01:18 CDT 2005

I suspect your best bet will be to "flatten" your data into a cursor used by
the report so that only one grouping is needed. With multiple detail bands,
only one of them can be "in control".

Dan

David Younger wrote:
> Is there a way to do grouping on individual detail bands in a multi
> band report?
>
> I have an invoice that prints parts and labour from 2 different
> tables. Works really well.
>
> I want to sub group the labour by Site ID, but not the parts. I this
> possible?
>
> Cheers
> David

Re: Reprot Grouping on multiple detail bands? by David

David
Sat Oct 08 07:18:42 CDT 2005

Thanks Dan but I just thankfully moved away from a flat file for the report
as I ave up to 4 detail bands on the report and it was an absolute mess.

The multiple detail bands are a joy to work with but Really need their own
grouping to be truly phenomenal. I find this a major disappointment.

Cheers
David

"Dan Freeman" <spam@microsoft.com> wrote in message
news:uy0#GYcyFHA.1856@TK2MSFTNGP12.phx.gbl...
> I suspect your best bet will be to "flatten" your data into a cursor used
by
> the report so that only one grouping is needed. With multiple detail
bands,
> only one of them can be "in control".
>
> Dan
>
> David Younger wrote:
> > Is there a way to do grouping on individual detail bands in a multi
> > band report?
> >
> > I have an invoice that prints parts and labour from 2 different
> > tables. Works really well.
> >
> > I want to sub group the labour by Site ID, but not the parts. I this
> > possible?
> >
> > Cheers
> > David
>
>