How to Show the Report in a Container

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
    - How to Insert a Blank Row in a Grid.. Hi, I have one task in Visual FoxPro. My task is 1. I have a Form with Grid is Displaying 10 Records. 2. I want to Insert a New Blank Row After 5 Record (Using some Short Keys..Example Ctrl+N) Can anyone please guide me in right direction.. Thanks in Advance. Guruprasath B Tag: How to Show the Report in a Container Tag: 238251
  - 2
    - show tip text in combo box Hello, i would like to show a tip text when i pass the mouse pointer over the items of a combo box. How can i do it? thanks Guillermo Arias Tag: How to Show the Report in a Container Tag: 238240
  - 3
    - Form Designer at Run Time It seems that in a VFP program I can issue a command like "modify report test" and I can get to the report designer. But, I can't seem to do that with the form designer. It seems like something flashes on the screen but then disappears. So, if I have a VFP program that runs well and has a read events, etc and somewhere in the program I decide to issue a "modify form test" it doesn't seem to work but a "modify report test" will work. Is there a way to access the form designer at run time so as to allow customization of forms at runtime? Thanks, Mike Tag: How to Show the Report in a Container Tag: 238227
  - 4
    - Recreate a project file When I try to open my project I get an error 'Project File Invalid'. The problem arose when Windows did an automatic reboot to install some important security update. My project was open at the time. Is there an easy way to recreate or rebuild the project file? thanks pete Tag: How to Show the Report in a Container Tag: 238226
  - 5
    - surprising result from ADDBS('') Who would have thought that ADDBS('') would return the empty string, instead of '\' !? This from VFP6 Help: "Adds a backslash (if needed) to a path expression." That was clear enough! Tag: How to Show the Report in a Container Tag: 238216
  - 6
    - scan....endscan problem I have the following sample working program: sele 1 use abc do while not eof() ma = a sele 2 use def do while not eof() mb = b mc = recno() skip scan for apple = ma while empty(dog) replace boy with mb, increment with recno() - mc endscan enddo sele 1 skip enddo My problem is that is it possible to terminate the scan...endscan loop when apple <> ma, or only process the scan...endscan loop in specific scope??? Thanks! Patrick Tag: How to Show the Report in a Container Tag: 238213
  - 7
    - Single Button Spell Checker My client wants me to add a single button which will spell-check one of the app's reports before printing it (VFP8). He said if it's too much bother ($$$), forget it, but that only makes me more determined <g>. I'm looking for a simple way to output the report in some form which is spell-checkable. Any ideas? I tried REPORT FORM .......... TO FILE <fname> ASCII but the output file's really not in ASCII and I can't open it with his word processor (WordPerfect). Years ago, I wrote macros in WP which merge data from a .dbf, but this particular report conatins a list of items which could be any length, so I'm not sure if I can take that approach. Another approach I thought of might be to output the list to a text file instead of a "REPORT". The problem here, I think, is the font has to be in Arial bold. Not sure how/if I can do that. Having this client change the font in WP is out of the question :) Thanks for any help. Steve Meyerson Tag: How to Show the Report in a Container Tag: 238212
  - 8
    - error instantiating application object Okay a small exe written in vfp5 and now running under vista gives this error on startup, you can ignore it and the app runs ok. I remember another exe long ago giving the same error on a network with restricted access to the local drives, is this the same problem, is there anything I can do without recompiling in a later version (I have 8 but its not installed ATM). BTW the app doesnt create an application object per se. Tag: How to Show the Report in a Container Tag: 238206
  - 9
    - Calling maps.google.com from VFP? Hi. We have someone doing service calls who would like to have a button that will call up google maps by passing the address & city of the client currently on the screen. He has seen this done somewhere and was wondering if we could do it for him as well. The app is currently in VFP6 but can be converted to VFP8 if needed. Sample code would be appreciated. TIA Mike Tag: How to Show the Report in a Container Tag: 238200
  - 10
    - How to change the default font for VFP applications? In my VFP-based application, I havenâ??t set font names for any objects. It is Arial by default. But one of my clients is using a different default font and makes my application looks very strange. I donâ??t know how to change it to Arial. Any ideas? TIA. Tag: How to Show the Report in a Container Tag: 238192
  - 11
    - strange inconsistency in JUSTPATH I just noticed this, under both VFP6 SP5 and VFP7: justpath("C:foo\bar") -> "C:foo" [correct] but: justpath("C:foo") -> "" [empty string - why not "C:" ??] This seems inconsistent, and it complicates the problem of supporting relative paths. Am I missing something? Tag: How to Show the Report in a Container Tag: 238190
  - 12
    - Shell execute settings for a large pdf picture I am trying to use shellexecute to print a pdf file automatically. SOmetimes it works perfectly, and other times it prints way too big. is there a setting on this command to set the size of the picture? Thanks, Martin Tag: How to Show the Report in a Container Tag: 238189
  - 13
    - How to digitally sign a VFP Application Hi Group, Recently we installed Microsoft Live Onecare and we find that every time we upgrade our application Live Onecare will prompt for permission to allow the application to send e-mails. The application returns an error 1429 IDispatch code 0 error before you can "allow" the application to send the e-mail. This results in that instance of the send not working. If you allow the send you are able to send e-mails without incident until you do another version upgrade then the cycle begins again. Research on the net indicates that live onecare will prompt for the user to allow an application to send e-mail if the application is not digitally signed. Has anyone digitally signed their VFP apps and what is involved? Many thanks in advance Jan Tag: How to Show the Report in a Container Tag: 238182
  - 14
    - DECLARE and DECLARE again Is there anything wrong with using DECLARE - DLL in a function where it might be called multiple times? Does it use up memory every time it's called, or anything like that? Tag: How to Show the Report in a Container Tag: 238180
  - 15
    - Looking For Free Porn I love sites concerning sex.I really like this site.Keep it going! Linda--24 Hours Of Porn--http://www.24hoursofporn.com Tag: How to Show the Report in a Container Tag: 238177
  - 16
    - Restore Window/Form Hi, I have a Form inside a Top level form. If the user Minimized the Window/Form, what command do I issue it to restore it? Thanks, Herbert Tag: How to Show the Report in a Container Tag: 238169
  - 17
    - select statement Is there a select statement that can do the following: (it is in the where clause but not sure) Table 1 170 170 170 5 5 15 15 15 15 into tables table a table b table c 170 5 15 170 5 15 170 15 15 Thank you Tag: How to Show the Report in a Container Tag: 238165
  - 18
    - Creating a routine to update an existing installation Does anyone have any links that will point me to some ideas on creating a routine that will automatically update an existing application? The problem I'm running into is that sometimes the new tables have new fields and that throws off my local views. I've thought of using the ALTER table, but I'd have to do it for (what seems like) a hundred of so views.....so what I'd like to do, is move the old tables, put the new ones in and then import the old data. Thank you Tag: How to Show the Report in a Container Tag: 238163
  - 19
    - VFP 6 SP5 installation under Vi$ta http://www.msdner.com/dev-archive/200/24-120-2009384.shtm Does fox.wikis.com has the solution in this link? If not, could I cut-and-paste the solution in that URL into fox.wikis.com? -- @~@ Might, Courage, Vision, SINCERITY. / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Xubuntu 7.04) Linux 2.6.23.9 ^ ^ 19:20:01 up 6 days 7:33 2 users load average: 0.00 0.00 0.00 ºî ´© (CSSA): http://www.swd.gov.hk/tc/index/site_pubsvc/page_socsecu/sub_addressesa/ Tag: How to Show the Report in a Container Tag: 238141
  - 20
    - How to Unload a Form without it showing? Hi, I have a form that if there are no records in a table will give a message and unload itself without showing the form? How can I do this? Thanks in advance. Tag: How to Show the Report in a Container Tag: 238138
  - 21
    - floating point precision On the more general subject of floating point precision ... see previous post ... I guess that storing division results in an array would be as accurate as vfp can get ... I mean as opposed as storing them in a cursor. So I'm thinking of a routine that creates a cursor of lookup keys and an array of long division results. The routine would seek the key and return arrayelement[recno()]. Has anyone tried something like this or... do I just need more sleep? -- -Lew The workers took the robot for Maria. Tag: How to Show the Report in a Container Tag: 238129
  - 22
    - cast and precision I'm doing a series of principal * rate calculations and the rate lookup itself is calculated in a sql statement. When I first wrote the query, vfp showed me a cursor with 4 decimal places in the rates col .. which isn't enough for my users, so I redid the query using cast( <calc> as N(10,6)). While this has certainly improved the appearance of the col in the cursor, floating point calc's being what they are... has it also increased its accuracy? -Lew Tag: How to Show the Report in a Container Tag: 238115
  - 23
    - password Does anyone have a quick (and dirty) password module I can front-end to my project? I am using VFP9.0 on XP machines -- Lost in Tampa Tag: How to Show the Report in a Container Tag: 238113
  - 24
    - can't use mail merge with word 2003 in VFP 9, invalid merge fields I am able to merge a FoxPro table with an existing word letter document on computers with older versions of word, but with 2003 (and only when done programatically in FoxPro... a manual mail merge always works), it says that all of the merge fields are invalid / could not be found in the data source. The original author of the code (not me) thinks that word is defaulting to using the address book as a data source and then not finding any of the fields, but neither of us has any idea what would trigger such a thing in only one version of word. And I've got the latest VFP ODBC driver... I thought that it might be something in our code that's causing it, but I used the mail merge wizard in FoxPro and got the same exact errors (only works when manually merging from word so far). What could be the problem? Tag: How to Show the Report in a Container Tag: 238105
  - 25
    - replacement of missing values Given the following raw tables with the fields, a, b, and c: a b plus 111 10 0 111 10 0 111 0 111 11 0 111 12 0 111 0 111 0 111 13 0 123 15 0 123 16 0 123 16 0 123 0 123 17 0 123 0 123 0 130 0 130 15 0 130 188 0 130 0 130 99 0 Is it possible to have the following output? a b plus 111 10 0 111 10 0 111 10 1 <-- replace with the last b and plus become 1 when a = 111 111 11 0 111 12 0 111 12 1 <-- replace with the last b and plus become 1 when a = 111 111 12 2 <-- replace with the last b and plus become 2 when a = 111 111 13 0 123 15 0 123 16 0 123 16 0 123 16 1 <-- replace with the last b and plus become 1 when a = 123 123 17 0 123 17 1 <-- replace with the last b and plus become 1 when a = 123 123 17 2 <-- replace with the last b and plus become 2 when a = 123 130 0 } 130 15 0 } 130 188 0 } skip the replacement of missing value when the top-most b in the new a (i.e. 130) become empty 130 0 } 130 99 0 } Thanks!!! Tag: How to Show the Report in a Container Tag: 238102
- Next
  - 1
    - Converting DBF to MySQL My tables has memo fields. DBF2MYSQL can´t convert this fields. How Can I do this? Thanks. Alejandro Tag: How to Show the Report in a Container Tag: 238097
  - 2
    - Two Monitors and ShowWindow and Desktop properties at RunTime? One of my users comments that they want to be able to drag windows from my application to a second monitor on the same computer. Is there any way to easily set these properties at runtime? The only way I can think to do it is to create two copies of the same form where one property is set to true and the other set to false. But, if I do this with multiple forms it really gets into a lot of upkeep. It would be great if there were some way to do this in the Load method at form runtime. I would like to check a table for user preferences to determine how to set one of these properties. One last thing: The main reason I'm thinking that I have to do this is if a computer has two monitors then as far as I know, there is no way to drag a window from one monitor to another since it is confined to the VFP window when the ShowWindow and Desktop properties are set to false. If there is a way to drag the window that would be great. Does anyone have any ideas on this? Thanks, Mike Tag: How to Show the Report in a Container Tag: 238096
  - 3
    - CFUDG Dec'07: Toni Feltman unwraps Sedna DBI controls and Etechnologia Merry Xbase! Gather at the Chicago FUDG meeting as Toni Feltman unwraps presents from DBI Technologies. They are some sparkling screen controls which are included in the Sedna release of Fox add ons. She'll also give us a peek at Etechnologia, the tool that compiles VFP code into Dot Net executables. Toni is one of the original Fox Software employees from its days in Toledo and now an owner of F1 Technologies (Fox Express framework). Tuesday, December 11, 2007 - 5:30 PM - we meet at 53 W. Jackson, Suite 826 in the Chicago Loop. January's speaker will be Jay Van Santen. http://www.ChicagoFUDG.com Tag: How to Show the Report in a Container Tag: 238095
  - 4
    - Sync Grids Is it possible to have 2 grids on a form with both of them having the same number of columns and identical column sizes and have them both scroll left or right when the user scrolls one of the grids left or right. There would be no sync of the vertical scrolls, only the left and right scrolls. I have a situation where I need to expand a grid that will cause it to exceed the size of the screen. I will have to enable the horizontal scroll. Currently the grid is small enough to fit the screen. Below the grid is some related information in text boxes that will have to be placed in a grid to accommodate the added fields.. If so, how would the be accomplished? I would appreciate any help you can give me. Mike Tag: How to Show the Report in a Container Tag: 238078
  - 5
    - VFP 9 on Windows 2008 TS We are testing W2k8 TS. On 32 bit OSs we copy the VFP support files to the \System32 directory. However, this does not work on W2k8. Any suggestions? Thanks. Tag: How to Show the Report in a Container Tag: 238064
  - 6
    - vista pia Like many other developers of multi-user applications, I often use an application upgrade model in which an updated version of the app is downloaded from the file server. Makes it very easy to upgrade several users. Mostly, they don't even know it happened. Now MS in its wisdom, has broken that method, and starting with Vista we can no longer write anything to Program Files. (I don't like that change at all, but they didn't ask for my opinion.) What's wrong with installing my app outside of Program Files, say in its own directory under the root directory? Offhand, it sounds to me like a simple and workable solution. After all, there are already some commercial apps that do that, stay away from Program Files altogether. Is that a bad idea? What could go wrong? Tag: How to Show the Report in a Container Tag: 238037
  - 7
    - Pure sql solution to date period I've got a semi sql solution to this problem, but can I do it in pure sql? Here it is: Given a table in the form name, date, rate, create a result cursor in the form name, startdate, enddate, duration (it's crosstab ish). The idea is for each name, show when the rate went into effect, when it changed and how long the rate was in effect. The procedural + sql solution goes like this: index the rates table on name + dtos(date) scan dStart = Date cName = Name select min(date) as nextdate from ratestable where Name = cName and date > dStart; into cursor results insert into durationtable values (cName, dStart, results.NextDate, results.NextDate - dStart) endscan This is unbelievably fast with the help of a few add'l tags, but I wonder if there isn't a single sql statement that'll do the whole thing. -- -Lew The workers took the robot for Maria. Tag: How to Show the Report in a Container Tag: 238031
  - 8
    - Fastest way to convert 1000's of YYYYMMDD char dates to real dates? -- -Lew The workers took the robot for Maria. Tag: How to Show the Report in a Container Tag: 238026
  - 9
    - set relation to iif(lCondition, fieldA, fieldB) into ........ Has anyone else seen code like this? I'm revving an old app written by someone who loved stuff like this. The app is full of it and it's twisting my mind. -- -Lew The workers took the robot for Maria. Tag: How to Show the Report in a Container Tag: 238021
  - 10
    - SEO Services you can Trust... 2 months I had first page organic results and they delivered on every key term I wanted so here they are http://www.atomicsearchengineoptimization.com or you can go straight to their contct page to get a great free report and a friendly call back. http://www.atomicsearchengineoptimization.com/Monthy_plan_rates-seo-services.html Tag: How to Show the Report in a Container Tag: 238016
  - 11
    - combobx Hi to all! How can I disable an item of a combobox? I donâ??t remember the character(s) what precede of the item? Ioannis Tag: How to Show the Report in a Container Tag: 238014
  - 12
    - numerous screen redraws while editing Anyone else have this problem? While typing in a code window, FoxPro will sometimes go into a frenzy of screen refreshes, often redrawing the screen 10-20 times within the space of a few seconds. I thought it might have to do with IntelliSense, but I disabled it and still have the problem. Tag: How to Show the Report in a Container Tag: 238004
  - 13
    - append from cursor I just noticed that I can't append from cursor. VFP keeps insisting, validly, that it can't find the dbf. So I can use append from (dbf(cursorname)). Since the cursor in question is a create cursor.... kind of cursor there's no danger of its being a filtered version of a larger table... so I'm thinking that my append idea should be totally safe in this situation. Am I right? Tag: How to Show the Report in a Container Tag: 238001
  - 14
    - Determine Operating System How would one go about determining which operating system is being used in an application. I have an application that I have to use a modified code when run in Vista. The code runs in XP as well as Vista but I have a double window open up when I call Word in XP but the double call is needed in Vista in order to move Word off of the task bar. Thanks for any suggestions. TonySper Tag: How to Show the Report in a Container Tag: 237992
  - 15
    - encryption replacement for DeFox Can someone recommend a product to encypt an app or prevent decompiling? I'm aware of ReFox. Is it the only game in town? Tag: How to Show the Report in a Container Tag: 237990
  - 16
    - Disable/Enable a network card Can somebody help me by showing me how to disable and then enable a network card through VFP 9? I can already tell by which IP address the user has obtained if they are rightly connected to the network. However, on this network, for whatever reason, several PCs don't get logged onto the network properly. My easy solution is to disable and then enable the local area connection. That usually does the trick. I'd like to write a program so the users don't have to go though this process. TIA. BR Tag: How to Show the Report in a Container Tag: 237981
  - 17
    - Dynazip Max 5, vfp9 and Installaware This is a multi-part message in MIME format. ------=_NextPart_000_008F_01C83343.6BC0C500 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Long shot - but hopefully somebody who has used Dynazip Max 5 with vfp9 = and InstallAware can help. We have used these activex components to = provide backup.restore facilities within the application. Clients (mostly but not exclusively network users) are experiencing = problems installing the dynazip activex modules. Everything else in the = application installs and registers ok. People tell us of failures to install and/or register correctly. We have = tried instructing them to terminate their firewall and anti-virus = systems temporarily but these steps are not resolving the issues in many = cases. I have set each Dynazip activex as self-registerng. The current client reporting a problem is using Windows Server 2003 and = the workstations are XP with SP2. The user attempting the installation = is logged into the network as network administrator. I will also ask in the appropriate InstallAware and Dynazip forums but = thought somebody with vfp knowledge may have experienced similar = problems. Sincerely Stephen Ibbs ------=_NextPart_000_008F_01C83343.6BC0C500 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.3199" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Long shot - but hopefully somebody who = has used=20 Dynazip Max 5 with vfp9 and InstallAware can help. We have used = these=20 activex components to provide backup.restore facilities within the=20 application.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV> <DIV><FONT face=3DArial size=3D2>Clients (mostly but not = exclusively network=20 users) are experiencing problems installing the dynazip activex modules. = Everything else in the application installs and registers = ok.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial = size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>People tell us of failures = to install and/or=20 register correctly. We have tried instructing them to terminate their = firewall=20 and anti-virus systems temporarily but these steps are not resolving the = issues=20 in many cases.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I have set each Dynazip = activex as=20 self-registerng.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The current client reporting a problem = is using=20 Windows Server 2003 and the workstations are XP with SP2. The user = attempting=20 the installation is logged into the network as network=20 administrator.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I will also ask in the=20 appropriate InstallAware and Dynazip forums but thought somebody = with vfp=20 knowledge may have experienced similar problems.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Sincerely</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Stephen = Ibbs</FONT></DIV></DIV></BODY></HTML> ------=_NextPart_000_008F_01C83343.6BC0C500-- Tag: How to Show the Report in a Container Tag: 237979
  - 18
    - External function errors. I have several *.app files that I keep out of the project. They change with different customer and I just add it to the customers folder. But my project manager keeps complaining not finding the files. I tried "EXTERNAL PROCEDURE Whatever.app" statement but the PM still complains. Anyway to stop the PM from doing that? ----------------------------------------------------------------- Paul Lee ........ Abri Technologies ........ http://www.abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: How to Show the Report in a Container Tag: 237958
  - 19
    - VFP and Oracle Hello. Does anybody know how to prevent ADO from adding trailing spaces to varchar fields on Oracle? I use CursorAdapter class and ADO. Thx M.Kujawa Tag: How to Show the Report in a Container Tag: 237956
  - 20
    - conversion from VB to VFP hello I have this piece of code that I can mostly make out what it is. It is written in VB and I need to convert it to VFP. I think there is some word wrapping issues too. But my specific two things are lRetVal = RegCreateKeyEx(HKEY_CURRENT_USER, "Software\Custom PDF Printer", _ 0&, vbNullString, REG_OPTION_NON_VOLATILE, KEY_ALL_ACCESS, _ 0&, hKey, lRetVal) and RegSetValueExString hKey, "OutputFile", 0&, REG_SZ, sValue, Len(sValue) the entire code is below. But what exactly would these two be traanslated to in VFP? thank you ************** Private Sub Print_PDF() Dim lRetVal As Long Dim hKey As Long Dim sValue As String lRetVal = RegCreateKeyEx(HKEY_CURRENT_USER, "Software\Custom PDF Printer", _ 0&, vbNullString, REG_OPTION_NON_VOLATILE, KEY_ALL_ACCESS, _ 0&, hKey, lRetVal) sValue = "C:\Sample.pdf" RegSetValueExString hKey, "OutputFile", 0&, REG_SZ, sValue, Len(sValue) sValue = "1" RegSetValueExString hKey, "BypassSaveAs", 0&, REG_SZ, sValue, Len(sValue) Dim worddoc As Word.Document Set worddoc = wordapp.Documents.Open("C:\Sample.doc") wordapp.ActivePrinter = "Custom PDF Printer" wordapp.PrintOut worddoc.Close sValue = "0" RegSetValueExString hKey, "BypassSaveAs", 0&, REG_SZ, sValue, Len(sValue) RegCloseKey (hKey) End Sub Tag: How to Show the Report in a Container Tag: 237955
  - 21
    - Getobject("WinNT://" + strDomain) I have the following code in VFP 9: strDomain = "STIEGLITZDOM" && change to your domain name Public PrimDomainContr Create cursor ADnames (username c(30),fullname c(80),descript c(80),Class c(50),accdisable l,acclocked l,profile c(30),loginscrpt c(50),Homedir c(30),lastlogin T) PrimDomainContr = Getobject("WinNT://" + strDomain) For Each User In PrimDomainContr If User.Class = 'User' WAIT WINDOW User.Name nowait Insert Into ADnames (username,fullname,descript,Class,accdisable,acclocked,profile,loginscrpt,Homedir,lastlogin) ; Values (User.Name,user.fullname,User.description,User.Class,User.AccountDisabled,User.IsAccountLocked,User.Profile,User.loginscript,User.Homedirectory,{}) replace lastlogin WITH User.LastLogin Endif NEXT Which other properties can I list with this code ? LastLogoff ? LogonCount? Is it possible? Where can I see a list of the properties? TiA Walter Tag: How to Show the Report in a Container Tag: 237953
  - 22
    - Combo List Missing Item I tend to use Comboboxes quite regularly with a style=2 (List) and recordsource=6 (Field) populated from other tables. It allows the user to easily select items from lookup tables. Problem is when a user deletes an item from one of the lookup table, then next time I show the form with the combo box on it which references the table, there is nothing displayed in the combobox - understandably as the data no longer exists. I know I can use a combobox with style=1 which isn't as sensitive to missing data in the underlying table but I would prefer to avoid this as I don't want to have to write code to control data entry etc. Is there a better way of going about it? Tag: How to Show the Report in a Container Tag: 237952
  - 23
    - Using FOR EACH with a ListBox Is it possible to use FOR EACH to process a ListBox? I tried: For Each cNextVal in thisform.List1.List but that gives an error saying that the List property is not found. I realize it can be done with a regular FOR loop, but FOR EACH would be more convenient if it would work. Regards, Kevin Clark Seton Home Study School Tag: How to Show the Report in a Container Tag: 237949
  - 24
    - Problem creating winmgmts using Visual FoxPro on XPe SP2 We have an application written in VFP9 that we would like to start using on an XPe system. The application needs to check to see if a certain exe (process) is running, and if it is not, then start it. The line of code that we are using is that is giving the error on the XPe system is: objWMIService = GetObject("winmgmts: {impersonationLevel=impersonate}root\cimv2") This line of code runs just fine on a standard Windows XP SP2, but it gives a 'moniker cannot open file' error when it is run on the XPe SP2 machine. When I run the WBEMTest.exe from the WBEM folder, I am able to connect to Root\cimv2, and get all of the instances of the winmgmnts through that with not problem. I have tried many different variations for the parameter for the GetObject method. Other things that I have checked are: 1. There is a CLSID key in the registry HKCR\CLSID \{0000031A-0000-0000-C000-000000000046} 2. The Path in the Registry includes "%SystemRoot%\system32\WBEM" I also created a small app that would return all of the current processes to messageboxes using vb .net 2005, and it errored out, saying that it could not create the ActiveX controls. This app also works fine on Standard XP SP2 machines. Any help would be greatly appreciated. Tag: How to Show the Report in a Container Tag: 237947
  - 25
    - Synchronizing General Field Hi, I have two tables that I want to Sync, but it contains a General Field (photo). Im stuck with the General Field. Im using scatter and gather to snyc the data, but General Fields is ignored. Is there a way to update this? Maybe save the photo to disk 1st then update it on the other table using Append General? Thanks, Herbert Tag: How to Show the Report in a Container Tag: 237939

Hi

I have one typical task in VFP 6.0

I wish to show the Report in an Container..Or in some part of the
form. The Report should not maximized..

The Report should in the part of the form..like Container...

File I used report file FRX.

Please guide me in this.

Thanks in Advance,

Guruprasath B

Re: How to Show the Report in a Container by Dan

Dan
Thu Dec 13 08:50:07 PST 2007

Your options for doing this in VFP6 are extremely limited.

I'd recommend printing the report to a PDF printer driver and displaying the
resulting PDF file in an OLE control.

Dan

guruprasathb@gmail.com wrote:
> Hi
>
> I have one typical task in VFP 6.0
>
> I wish to show the Report in an Container..Or in some part of the
> form. The Report should not maximized..
>
> The Report should in the part of the form..like Container...
>
> File I used report file FRX.
>
> Please guide me in this.
>
> Thanks in Advance,
>
> Guruprasath B

Re: How to Show the Report in a Container by guruprasathb

guruprasathb
Thu Dec 13 21:11:09 PST 2007

On Dec 13, 9:50 pm, "Dan Freeman" <s...@microsoft.com> wrote:
> Your options for doing this in VFP6 are extremely limited.
>
> I'd recommend printing the report to a PDF printer driver and displaying the
> resulting PDF file in an OLE control.
>
> Dan
>
>
>
> guruprasa...@gmail.com wrote:
> > Hi
>
> > I have one typical task in VFP 6.0
>
> > I wish to show the Report in an Container..Or in some part of the
> > form. The Report should not maximized..
>
> > The Report should in the part of the form..like Container...
>
> > File I used report file FRX.
>
> > Please guide me in this.
>
> > Thanks in Advance,
>
> > Guruprasath B- Hide quoted text -
>
> - Show quoted text -

Hi Dan,

Thanks..Thats Good idea..I will implement your suggesstions.

Guruprasath B