Another Report Writer Question

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
    - Report Writer Bug?? Hello - this appears to occur in VFP6/sp3, not sure about VFP 7, 8 or 9. If I have a field in the Title band of the reportwriter and suppose it is really long (say 90 lines or so) and I check the Stretch With Overflow then anything after that field or even that field gets cut off after page 1. In other words, the title band appears to be limited to 1 page. Any way around this without redesigning the entire report? Thanks, Mike Tag: Another Report Writer Question Tag: 200127
  - 2
    - Ocx Registration Q. I have build myself an application that contains some ActiveX calendar tools. I am using install shield to build my setup and that seems to be cool too. The problem is that when I install and run the program I get the message box error that says: OLE error code 0x80040154: Class not registered. OLE object is being ignored. Record number 5. <s>. Does this mean that I am messing up my Install Shield build or that I need to registered the objects by running something like: Regsvr32 "C:\Program Files\Bblocks\ctBanner.ocx" In a program on startup of the installation. I just have a feeling that I am missing something very obvious. Respectfully, Jonathan Morningstar Tag: Another Report Writer Question Tag: 200120
  - 3
    - Scatter Name .... Blank and default values problem Hi, Shouldn't Scatter .... Blank conatain the default values where those assigned in a table? I think that this should be expected. Demetrios, Greece Tag: Another Report Writer Question Tag: 200110
  - 4
    - Automatic reindexing...A newbie asks Greetings All: I am new to VFP and would like to know how I can set up regular reindexing of a database so it doesn't have to be done manually - I sometimes forget to do it on a regular basis. Thanks in advance. -- _______________ Regards, Jerry M. Gartner Tag: Another Report Writer Question Tag: 200103
  - 5
    - VFP7 Project file not visible Have been working for years with this project file but all of a sudden when I attempt to open the project file nothing happens - it is not visible. No error messages display and no other windows are created - using the Screen only. The 'Modify Project' help file says: "NOSHOW Specifies that the Project Manager is hidden (its Visible property is set to false (.F.)) when it is opened. To display the Project Manager, set the Project Manager's Visible property to true (.T.)." There is not a command/flag to SHOW the Project Manager, so how do I set the Visible property to .T. so I can see my project manager again? Please. TIA PetC Tag: Another Report Writer Question Tag: 200102
  - 6
    - VFP7 very slow performance I am looking at speed problems that one of our application users has reported. Basically the problem is happening on very large tables of around 100,000 records. Each record has around 40 fields. All fields are indexed as a rule in our application. The speed issues are mainly over a network although it is also noticeably slow on my c: drive. I've analysed the problem using SET COVERAGE and have found that on saving a new record to one of these tables, the Tableupdate takes about 1 second but the application pauses for 16 seconds on the END TRANSACTION line. I have no idea how to improve the speed of this so any clues would be most helpful. Bernie Tag: Another Report Writer Question Tag: 200095
  - 7
    - VFP 7 installation/uninstallation problem! I just did a fresh install of Windows 2000. Haven't even gotten around to installing the Windows 2000 service pack update or configuring Internet access. To access some documentation (which I keep in DBFs) I decided to install VFP 7.0. I did so, updated it to SP1 (which I had saved on disk), got everything configured. The installation process appeared to have proceeded normally after I was prompted to install necessary Windows Components from the VFP 7 installtion CD. However, turning on the machine I am prompted to install a component (not specified), and am asked for a location. It hints that it's looking for vs_setup.msi, if you poke a bit. This is on the VFP 7.0 installation CD, which I put in. A process goes on for some ten minutes, and it appears that a lot of stuff is getting installed, configured (therm bars going on and on). However, later I get the same thing on subsequent Windows 2000 startups. I decide to uninstall VFP 7.0 and reinstall it. I go to Add/Remove programs and try to remove it there. I'm informed that Windows can't find the uninstall file and am asked if I want to remove the representation of the program in Add/Remove programs. Stupidly, I agree. I try to uninstall from the VFP 7 installation CD. The option is right there: Uninstall MS Visual Foxpro 7. I pick it and a dialog comes up saying: Setup has detected that you might not have enough space to install this product. Do you want to continue? Yes No The installation drive has 87 GB free! I can't pick either Yes or No, as the dialog and the VFP 7 Maintenance screen is completely frozen. My only option is to end the task. What can I do to fix things? I really don't want to reformat Windows 2000 again. It appears that the dialog was waiting for a response from me. Of course, I couldn't respond. However, something changed at one point and I chose to uninstall ("Yes"). That appeared to proceed "normally," however afterward my installation directory and files appeared to persist. I put in the installation CD and proceeded to attempt to install VFP 7 again. The process immediately aborted and I was offered this logfile explaining the reason for the abort: [09/18/04,04:06:52] setup.exe: [0] CreateDirectoryLayout problems creating directory: W:\Apps\Fox\MS Visual Foxpro 7.0 [09/18/04,04:06:52] setup.exe: [2] InstallSetupFiles : CreateDirectoryLayout failed [09/18/04,04:06:57] setup.exe: [2] ISetupManager::InstallSetupFiles() failed in ISetupManager::RunInstallLists [09/18/04,04:06:57] setup.exe: [2] ISetupManager::RunInstallFromThread() failed in ISetupManager::RunInstall() ***EndOfSession*** What should I do? Thanks for any help. Dan Tag: Another Report Writer Question Tag: 200092
  - 8
    - Naming files in VFP How can I rename a PDF programmatically? I want to use the file picker to select the PDF, and then rename it based on the value in a character field. Thanks for the reply... Tag: Another Report Writer Question Tag: 200088
  - 9
    - Stop user from installing more than 1 instance Hi all! What is the best way to prevent an user to start an run more than one instance of a VFP-app? Best regards Christina Tag: Another Report Writer Question Tag: 200085
  - 10
    - Help w/ DOS foxbase app--won't start Help. I am trying to get a program written in DOS foxbase about 6-7 years ago to start. It seems to start, but then I get a message that says "Preparing files ... Please be patient" Then it drops to a dos prompt. No other messages. I cannot get it to do anything. The most puzzling part of this is that this program works fine on an old computer running W98. That computer boots to dos and then this legacy foxbase ap is used. When I copied all of the files from that old computer to a new one, it did not work and is doing as I described above. I'm not sure this matters, but the new computer is using VirtualPC on XPPro. The virtualPC boots to dos and only loads w98 when asked. I duplicated the config.sys and autoexec.bat settings. I cannot think of anything else. Any help would be much appreciated. PS: if you email an answer, use rob@drrws.com as the adr. Thanks Tag: Another Report Writer Question Tag: 200073
  - 11
    - Fatal error 1088 :-) I think this is old news, but thought I'd share it anyhow :-) ftp://zootal.no-ip.info/fatalerror1088.jpg Tag: Another Report Writer Question Tag: 200072
  - 12
    - XMLAdapter and multiple tables I try to use, within VFP8, the XMLAdapter to open an XML file containing multiple (4) tables. oXMLAdapter = NEWOBJECT('XMLAdapter') oXMLadapter.LoadXML('M:\Edipax\order.xml',.T.) oXMLAdapter.Tables(1).ToCursor() up to there it works fine. but when i try oXMLAdapter.Tables(2).ToCursor() i got an error "no existing member in the collection". Thanks in advance for help, Kind regards, Guy Tag: Another Report Writer Question Tag: 200065
  - 13
    - Form Works in One App but Not Another Part II Thanks in advance for any help. I have a form that I'm trying to use in two different apps. It works in one but in the other I get this error (which I think that I incorrectly reported in an earlier post) Visual FoxPro Reference "field" phrase is not found (Error 1130) The field specified in PROMPT field was not found. a.. You are using a command with a PROMPT clause that references an unknown field. For more information, type PROMPT in the Index tab of the Help file and select the command you are using. To the best of my knowledge I am not using a PROMPT command or function. Following the instructions above to type PROMPT in the Index tab of the Help file did not help. Does anyone have any idea what this error means? It is an error which can be safely ignored (which I guess means that it can be trapped) but I don't think I should have to do that. Thanks again, Jeff Tag: Another Report Writer Question Tag: 200062
  - 14
    - Join VFP Project to SourceSafe I have a VFP 8.0 project that was, at one time, hooked into SourceSafe. I have since created a new project file and recompiled everything. Everything works great, except now, I cannot check in or check out files from within the Project Manager. I have to go directly to SourceSafe to do that. I've tried Join Source Control Project... but I am not able to join it back to the SourceSafe project. Any ideas? TIA. -Paul Tag: Another Report Writer Question Tag: 200057
  - 15
    - How can I run a FPD2.6 program in VFP8? Program only, not from screen generator or anything like that. I could run it in VFP6, but when I try to run it in VFP8, I get an error message that it can't create the .fxp file. I'm sure this is a stupid question, but since I don't know the answer, gotta ask! :) Thanks! Shawn Tag: Another Report Writer Question Tag: 200053
  - 16
    - Crystal reports We are trying to use crystal reports from fox. The problem we have is how to pass a parameter into the report so that only records are printed depending on the parameter. ie do report1.rpt with id =1 print only records with an id of 1 Is this possible. Thanks in advance Dave Tag: Another Report Writer Question Tag: 200049
  - 17
    - grid display problem Hi, In a column of a grid, the field is defined as c(1), I want to display the word 'Posted' in that column if the field content is 'P', if not then blank. I have tried the iif() in the control thisform.grid1.column1.text1.value It just display the word 'P', I though it is because the field length is c(1) please advise How can I do that whitout change the field length ? I would retrieve those records by 'SELECT ..... ' into a temp table Can I change the field length in doing 'SELECT' ? thanks Tag: Another Report Writer Question Tag: 200038
  - 18
    - TEXT/ENDTEXT limits I use "TEXT to lcXX TEXTMERGE NOSHOW" to build a SQL statement. I have a SQL insert failure due to a syntax error in the insert statement. When I save "lcXX" to a file I notice that a carriage return and line feed (CHR(13)+CHR(10)) have been placed into the string. The insert command being generated is about 2000 characters long. I have used this technique in many applications and have not seen this before, although this merge may be larger than others. Can someone explain why this occurs, how to prevent it or at least predict it. In reading the documentation I do not see any limits. TIA Mark VFP7 SP1 Tag: Another Report Writer Question Tag: 200033
  - 19
    - Record pointer moving on its own (it's possessed!!) I have a situation with a client's app that results in the record pointer not moving properly. On the forms I develop, I use a pageframe with a List tab at the far right. On the tab is a grid showing the form's main table and this grid is used for locating a record. You click in a column, start typing, it does an incremental search, and when you hit the record you want you just press Enter. The pageframe's main tab is activated and this is where the data entry/edit is done. This works great, but after installing VFP 8 a client noticed a problem. While on the main tab, the user may move to another record (this is basically a bill of materials form and the user can right-click on a line item and choose Inspect this part and the record pointer will be moved to that part and the form will display it). After doing this and clicking back on the List tab, instead of the grid being positioned on the record displayed in the main tab, the grid will be on some other record. It's not necessarily a record that was previously being viewed on the main tab. As I mentioned before, this has worked perfectly up until the install of VFP 8. In fact, when the client tests on a VFP 7 version of the app, it still works fine. I had noticed some similar behavior in another client's app, but attributed it to an error in my code (though I could find none) and didn't think it was VFP 8 related because it had been awhile since we moved to VFP 8, so that connection didn't jump out at me. However, that may be the same issue. If the code is traced, it works, if the code is not traced it will fail. Has anyone seen anything like this? Thanks, Russell Campbell Tag: Another Report Writer Question Tag: 200030
  - 20
    - Project Manager problem Hi, I am experiencing a weird problem with the program manager. On an existing project it does not add automatically the forms, programs, icons etc used. If I create a new project and just add the main program, everything is rebuilt correctly. But, if I reopen the project and remove a form (for test reasons) and rebuild the project, the form is not added. It reports that the form is Undefined ! I found and read another relative post but those guidelines do nothing for me. I have deleted all foxuser files, Rebuild, Cleanup the project. Recompile all files. The problem does not seem to appear on other projects, on other directories. Pleeeaaase Help, before I get crazy. Demetrios, Greece Tag: Another Report Writer Question Tag: 200024
  - 21
    - Create an Empty Dataset From XML... Version: Visual FoxPro 7.0 Pre-SP1 OS: WinXP SP1 I have an XML string that has an in-line schema. It just happens that there is not any data in the XML document, meaning the table has no records. When I issue the XMLTOCURSOR() command, it is placing a record in the cursor and inserting .NULL. as field values. Question: The XSD handles the field names, etc..., so no problem there. How do I create an empty recordset from and XML string and an in-line XSD? I am an XML newbie so be nice... Tag: Another Report Writer Question Tag: 200022
  - 22
    - Form works in one app but not in another Thanks in advance for the help... I have a form that I need to use in two different applications. It compiles in both applications just fine and it works properly in one of them. In the other I get a message Field "phrase" not found at the thisform.refresh line (according to the debugger). The error appears twice and can be ignored after which the form works correctly. Does anyone have any ideas about this problem? Thanks Jeff Tag: Another Report Writer Question Tag: 200019
  - 23
    - sys(3050) I've been having a problem with freeze-ups in FoxPro 8, where a compiled application will either freeze entirely or seem to be frozen for a long time but then eventually come back online. This seems to happen especially when a user is just stepping through a table. I'm wondering if possibly this has something to do with the sys(3050) setting. Microsoft has a KB article in which they say that FoxPro does not always work very well with large amounts of RAM. Of course, all computers these days have large amounts of RAM. The KB article says 256 megabytes or more might cause a problem, and all the computers my application is running on have at least 512 megabytes. My question is, in general, is it a good programming practice to always use SYS(3050) in a FoxPro application to reduce the amount of available RAM? If so, what is a good number at which to set the available RAM? Kevin Clark Seton Home Study School Tag: Another Report Writer Question Tag: 200018
  - 24
    - Chron job on server A client has asked us to write an app that will run as a timed job on a Windows 200 Server, using Windows ability to schedule the process to run at timed intervals. Is there anything special I need to know about 1. Installing a vfp app on a Windows server 2. Rights and other considerations for the job to run Thanks in advance. Josh Rubin Tag: Another Report Writer Question Tag: 200014
  - 25
    - Problem installing VFP 7.0 on XP Home Edition Service Pack 1 When trying to install VFP 7.0 on XP Home Edition Service Pack 1, once de CD insertend into CD-ROM, even before being able to choose the option "Install VisualFoxPro 7.0" an error message apear: "Windows Component Update. Setup has detected that some of the Windows components that are installed on your computer do not match the version required for Visual FoxPro. You must install a different version of these Windows component" Than I installed XP Service Pack 2. No results, the message is the same when I try to install VFP 7.0. What can I do ? -- Manuela Musat Tag: Another Report Writer Question Tag: 200000
- Next
  - 1
    - How to run SQL Script through VFP? Hi, Does anyone know how to run SQL script through VFP and load it into Oracle? Regards, Anand. Tag: Another Report Writer Question Tag: 199999
  - 2
    - select statement problem Hi, The following statement is placed in the init event of myform thisform.grid1.RowSource = "select pinvitem.invnum, pinvitem.partno, invoice.invdate ; from pinvitem, pinvoice into table invallo where pinvoice.invdate = date() ; and pinvoice.invnum = pinvitem.invnum and pinvitem.recstat = 'P' ; order by pinvitem.invnum, pinvitem.partno asc" thisform.grid1.RowSourceType = 4 I got an error message : 'commands contains unrecognized pharse/keyword' but I do the above 'select' statement alone , it has no error at all. please give me a hand thanks Tag: Another Report Writer Question Tag: 199997
  - 3
    - read only tables We are having problems where client machines cannot update tables. We are using vfp6 and the data is on a 2000server. The client machines are 2000 pro. When trying to write to a table we occasionally get error 111 'cannot update the cursor'. According to the help this is because the table is read only. This has happened with two different tables now and there seems to be no pattern to it. The error persists until the server is restarted. Until then the table cannot be written to. How can a table suddenly become read only? Has anyone else experienced this problem. Any help would be appreciated Dave Tag: Another Report Writer Question Tag: 199996
  - 4
    - Different cell color in a grid using a cursor Is it possible to store values in a cursor to format cells in a grid? For example, I've the cursor: Field1 Field2 Field3 -1 1 3 1 -1 2 and the table: Field1 Field2 Field3 aa bb cc dd ee ff I would like to display the table using a grid with blue background cells for positive values of the same field of the same record in the cursor and red for negative values, like this: The grid: Field1 Field2 Field3 aa (RED) bb (BLUE) cc (BLUE) dd (BLUE) ee (RED) ff (BLUE) Any suggestions? Thanks in advance! Lorenzo Tag: Another Report Writer Question Tag: 199993
  - 5
    - HP printer conflict I'm having trouble with HP printers. I'm running foxpro 2.6a.. REPORT FORM < > TO PRINTER PROMPT REPORT FORM < > PREVIEW The problem is occuring always running under terminal services, and intermittently on a conventional windows NT domain. Other printer ok.. only HP. Can somebody help me.. Thanks! wdennys Tag: Another Report Writer Question Tag: 199990
  - 6
    - How to make an application to be minimized in taskbar tray? (Further Question) I have asked this question before. Thanks Eric and other guys of you that provide the solution to achieve this. I have tried it and it really shows the icon in the systray. But I have a question: I compile my project with this systray icon tool to an execution file. But when I run it, the main Visual FoxPro is still appeared, although the systray icon has been shown. I have included a command _screen.Hide. But the result will be the application quits. I have found a DLL, systray.dll that can really hide Visual FoxPro window the systray icon is appeared. But there is something that does not meet my requirement: When I left or right click the systray icon, the Visual FoxPro screen is appeared. What my requirement is: the application should be always hidden and the systray icon appears. When I right-click the systray icon, a menu appears that can let user to choose. Does anyone have any ideas or suggestion? Tag: Another Report Writer Question Tag: 199985
  - 7
    - uncommitted changes and setfldstate I'm using a view with optimistic table buffering. I go to requery() an SQL view, but get the error: "Table buffer for alias ViewDocHeader contains uncommitted changes (Error 1545)". prior to this I use: 'setfldstate("DiscPCent", 1, "ViewDocHeader")' to manually set the field status of the view, because the control source has been changed for a control using the DiscPCent field, in debug I can see that this code: getfldstate(-1, tcAlias) returns "1111111111111111111111", why does it still think there are uncommitted changes, when in fact there isn't anything different and I've used 'setfldstate' Any help greatly appreciated. Grant Tag: Another Report Writer Question Tag: 199982
  - 8
    - Editing a memo field in a grid I have created a grid and one the columns in this grid is a memo field. I can't use the standard ways of adding data or editing this memo field (CTRL-PGDN or double-clicking do this in a browse window). What am I missing? There must be some way to view and edit data in a memo field in a grid, but I can't find anything about this in the help files. I'm using VFP 7 / SP1. -Everett Tag: Another Report Writer Question Tag: 199977
  - 9
    - How do I get match data from one table twice? I have a two tables. One is my product description table, the other is my Orders table. I have two fields in the Order Table that match one field in the Product table. I want to get the description for the new product and I want to get the description of the old product. How do I get this using a query. Below is my current query but this only brings back a null value for the old product description and the correct description for the new product. Select Orders.Product as NewProd, Productn.Desc as New_Desc,; Orders.Old_Prod, OLD.Desc as Old_Desc, Orders.inumber as Invoice; from Orders; inner join Productn on Orders.Productn = Productn.Productn; left join Productn as OLD on Orders.Old_Prod = Productn.Productn; where !empty(Orders.Old_Prod) Tag: Another Report Writer Question Tag: 199964
  - 10
    - How to disable listbox entry I have the need to disable listbox entries that start with '\\', such as a network path. Normally, you start the entry with '\', and it will be disabled. If you have a legitimate backslash, you would change it two backslashes so that it is enabled and displays a single backslash. BUT - if you have two or more backslashes, it will just display backslashes and not disable the entry. How would you get \\SomePath to appear as disabled? I can put a space between a backslash and the rest of the item, but then I have a disabled entry with a leading space. Tag: Another Report Writer Question Tag: 199963
  - 11
    - Excel automation Can somebody help me with this problem .. I need to add lines to an existing Excel file. To open the file and add the lines is no problem, but I need to check if the file is already open, so I don't open it again. So if the file is open in Excel, I need to add lines to the open file ofcourse. Thanks for the help Xavier Tag: Another Report Writer Question Tag: 199957
  - 12
    - Which Control? Which ActiveX Control do I use to have Calendar that looks like the Outlook Calendar for a Month at a time? I am looking for a control that I can see if anything is scheduled for a day and the ability to add and view entries from the same form too. Respectfully, j. Morningstar Tag: Another Report Writer Question Tag: 199949
  - 13
    - Getfile() Q. How do you get the Getfile() command to start in a specified directory? Respectfully, Jonathan M* Tag: Another Report Writer Question Tag: 199947
  - 14
    - Dynamic Shortcut Menu I have added the custom class menulib in ..\samples\class\utility.vcx to my form. I load data in the array and call the shortcut in my right click procedure in the form. It works fine in this scenerio. The problem occurs if I have a top level form which calls a second form which contains the dynamic shortcut menu. Basically when I right click on the form, the menu is not displayed as part of form. Thus... Form1 is defined as Toplevel form, Always on top, Modal and calls form2. Form2 is defined as in toplevel form, modal, always on top. Any suggestion would be appretiated. Thanks Shahriar Tag: Another Report Writer Question Tag: 199943
  - 15
    - 4up printed forms Am using vfp 5.0 and need to print a 4up 4x6 inch form that requires a page length of 12 inches. Unable to find a way to do this. Is it possible or what is the next version that will allow me to do this. Avery sells a packet of 4up - 4x6 inch forms which is not available on my version under labels. Tag: Another Report Writer Question Tag: 199942
  - 16
    - change sct to prg ? Hi, Is there a way to strip a scr/sct file into a prg. I have made some forms with the formdesigner and would like to get rid of them and have the code in my prg. regards christophe Tag: Another Report Writer Question Tag: 199935
  - 17
    - server time Hi All, How to get time value from another machine (server or another)? Client's OS could be Win98, NT, ME, W2K, or XP May be it need WinAPI, how is the easiest way to implement ? Thanks in advanced I'm using VFP 7.0 Tag: Another Report Writer Question Tag: 199929
  - 18
    - what's the command? the old foxpro 2.6a.. running a screen using this command (eg. DO customer.SPR )..what is the command for visual foxpro... i try write DO FORM customer (but i needed to included the CUSTOMER form to run the form), in foxpro 2.6.. i don't need to included the .SPR cause alredy compile and embedded in the .EXE pls help me.... thanks! Tag: Another Report Writer Question Tag: 199926
  - 19
    - MapPoint Looking for info on integrating MapPoint into a VFP app. Anybody aware of any papers that might be available? thanks Tag: Another Report Writer Question Tag: 199925
  - 20
    - grid row alignment I have a page with a grid based on one local view ("the list page") & a details page based on another couple of views ("the details page"). The problem I have is when you click the button to show the list page and set the record pointer on the correct record, set focus to the grid, even refresh etc it will be highlighted on the row it was before leaving the list page. How can this be set to be "showing" the correct record/row? I have a feeling I've forgotten something, I've never had this problem before?! Grant Tag: Another Report Writer Question Tag: 199918
  - 21
    - Help files not displaying on some machines I have an application in foxpro 6. Help files are all "*.chm". On machines that do not display help when F1 is pressed: Help is on Help file paths are correct Issuing a "Help" command has no effect. The application is the same on all machines so it appears to be related to the machine, not the program. These machines will display a help file when the file is double clicked in an open folder. Any ideas? With thanks Tony --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.749 / Virus Database: 501 - Release Date: 1/09/2004 Tag: Another Report Writer Question Tag: 199911
  - 22
    - SQL datatime Field Having upsized my data to SQL 2000, my date fields are stored as "datetime" in the sqlserver. This causes problems in my forms where users were to only enter dates. Now it shows time along with date in my data entry forms. There is no Date field in SQL 2000 without the time? Any suggestions? Thanks in advance Tag: Another Report Writer Question Tag: 199909
  - 23
    - Calendar Q. What is the best way to write a "Calendar" for VFP? I want a calendar that all users can see what people have scheduled for a day. I would like it to have the apperance of Outlooks Calendar. Tag: Another Report Writer Question Tag: 199901
  - 24
    - Re: COMPILE REPORT ReportFile Ok, compiling the report generated an FXP file with the same name as my report format. 1. Should I remove the Report Format from my project and add the FXP? 2. Should I still use the REPORT FORMAT command to call it? Gary Z Sietse Wijnker wrote: >Hi Gary, >Try >COMPILE REPORT ReportFile >after you've cleared out the Tag1, Tag2, and cleaned up the Expr field >Regards, >Sietse Wijnker Gary Z wrote: >> I checked the Expr, Tag1 and Tag2 fields. They're still empty. This has got me >> stumped. Where's it getting the incorrect printer from now? Tag: Another Report Writer Question Tag: 199878
  - 25
    - HowTo?: re-index LINKed FoxPro files (Access 2002/2003, Windows XP Professional) Scenario: The customer is developing in Access 2003 and installing the .mdb to systems running Access 2002. The customer is running legacy third party accounting software that uses FoxPro files. He has successfully used the ODBC driver for Visual FoxPro to update the legacy FoxPro .DBF tables. There are two other FoxPro files (.CDX, .FPT). After the customer updates the FoxPro .DBF, he unfortunately must open the third party accounting software's utility menu to re-index the files. If he does not do this manual task, the transactions that he added via Access are not visible in the third party accounting software. This manual step prevents the customer from fully automating the transfer of Access data into the legacy FoxPro database. That is the first part of this problem. The second part is the accounting system data is resident on a file server, and the customer is forced to LINK to the legacy tables. He has tried to update the legacy LINKed tables but Access will not re-index LINKed tables for him. I have been searching KB and MSDN and can not find any information about this problem. QUESTION: is it possible from within Access to programmatically re-index FoxPro files? ???? If yes, what is the Access command for re-indexing? If no, I assume (hope) it could be done with a few lines of MS Foxpro or C++ code ... or maybe there are some Foxpro utility programs that could do this via a simple shell to a command line (.cmd/.bat) file. ??? Thank you ................ gerry Tag: Another Report Writer Question Tag: 199868

Hello - is there a simple way to force the report writer to print the Detail
band one time with the labels even if there are no records or will I have to
create a "dummy record?"

Thanks,

Mike

Top

Re: Another Report Writer Question by Fred

Fred
Mon Sep 20 01:39:24 CDT 2004

Yes, the report will need at least a duumy record to "chew on" in order for
the detail band to print.

Fred
Microsoft Visual FoxPro MVP

"MAppell917" <mappell917@aol.com> wrote in message
news:20040919193153.03267.00000767@mb-m17.aol.com...
> Hello - is there a simple way to force the report writer to print the
Detail
> band one time with the labels even if there are no records or will I have
to
> create a "dummy record?"
>
> Thanks,
>
> Mike

Top