Answer Questions

• deltwebguy Thank you Microsoft

  I just wanted to say thank you to microsoft for giving us this forum.  I know there are a lot of great forums, but this gives us a chance to be a fly on the back of the couch in the living room at microsoft... This may well become my primary forum to turn to now when I have some real questions to throw out there... Agreed! I have previously used various combinations of newsgroups, universalthread & EE (experts-exchange). Each seem ...Show All

• MAG Word Document Formating

  Dear Expert I create some table in word with following procedure. These codes were written by Sir Cetin Basoz and by some other UT Professors. The codes work fine. #Define wdTableFormatColorful2 9 #Define wdTableFormatContemporary 35 #Define wdTableFormatElegant 36 #DEFINE wdAlignParagraphThaiJustify 9 #DEFINE wdOrientPortrait 0 #DEFINE wdOrientLandscape 1 #DEFINE wdCellAlignVerticalBottom = 3 *Local oWord As Word Application, ...Show All

• Tomas Srna Help in VFP 6 Application...

  Hi, I've developed a application in VFP 6.0 in Windows 2000 Server Env. The problem is that if I start the application. the splash screen shows up... but with the Command window and the standard toolbars in background..... I tried with application.visible=.f. But it imposed several limitations in my applications.... So is there any way to get around this situation..... One more thing I wanted to ask is what is the be ...Show All

• SSG31415926 MSComctlLib.TreeCtrl.2 BackColor ???

  MSComctlLib.TreeCtrl.2 does not have BackColor property. Is it possible to define one (it is of course possible) and actually make it functionable Thanks. Wow!!! Spectacular . It works! You have my admiration for the rest of your life... NO, my life! And how did you know that this yellowish hue (255,255,192) is my favorite color for background in treeview contols! This is clairvoyance through and through. It turns out I am no ...Show All

• paolod Registering a Visual FoxPro driver in SQL

  Hi... Not sure if this is the right place but we have a problem registering a Visual Foxpro driver in SQL. The driver does not appear on the initial drop down list and so we have added it manually using regsvr32. All seems fine until we try to access the server when we get error 7403 Could not locate registry entry for OLE DB provider 'VFPOLEDB' Any ideas or advice gratefully received... Hope I have all the details, but it is happening ...Show All

• Christian Kuendig Spacing columns in a grid.

  Is there a way to set up grids so there is a slight margin between the columns (I'd like a little space between the text of the control and the left grid line) I can't use the margin property though because its not just for the left side of the control but all around. Thx, Aleniko Aleniko, You can set the Text1.Margin = 4 and the Column.Sparse = .F. this will only add space to the left and right ...Show All

• Tim Sohn Day Time Picker little trouble.

  Back in Visual dBase days we used regular spinners for dates but here in Fox the spinners do not seem to like dealing with anything but numeric values. I placed three day/time picker controls on two different containers that are supposed to become visible or invisible depending on some buttons being pressed. I am certain the pickers' parents are the containers however when I make the containers invisible (setting .visible to .F.) the pickers sta ...Show All

• Phil Coveney Hooking into VFP's compile cycle (the ultimate builder)

  Randy and the entire Visual FoxPro Team, I'm excited to see this new forum! I'm looking for a way to hook into VFP's compilation cycle so that I can have my own VFP code pre-process the source code that VFP will compile. I can turn off auto-compliation for PRG files, and then use project hooks to do this for PRG files at project build time but I have been unable to find a way to disable the auto-compliation of method code in the form and class d ...Show All

• Sher J show certain record in gridbox

  dear all, i dont want my form show ZZZZ product code that i make hardcode to my table. sele b SET ORDER TO 2 GO TOP thisform.grdSales.RecordSource = "b" thisform.grdSales.RecordSourceType = 1 thisform.grdSales.column1.Bound = .F. thisform.grdSales.column2.Bound = .F. thisform.grdSales.column3.Bound = .F. Thisform.grdSales.column1.text1.ControlSource = "P_name" Thisform.grdSales.column2.text1.controlsource ="P_c ...Show All

• AndyLee71 Report Designer Help Needed

  I have created a statement with 2 bands 1)Acctno, 2)Orderno,  Within the page footer band I have created a portion that the user is to cut and submit back, however, due to overflow of information to a 2nd page I end up the next customers data appearing within the "submit with payment" area. I have tried to include this "submit with payment" portion within the Acctno Band, however it does not stay at the bottom of the 2nd page (it floats). A ...Show All

• sbogollu Data design for my application - Comments welcome

  dear all, I've an application for financial accounting.... It handles data for various Financial accounting years.( Apr- Mar). The application provides lot of reports with annual comparisons and analysis... The data comes from transaction tables (independent not DBC) which contains average of 1,000,000 records per table....(per year). I've designed the application in such a way that the tables are seperate for each and every year.... ...Show All

• DIG Using VTable interface of Excel Component from FoxPro 8.0

  I am writing a FoxPro program that uses the Microsoft Excel component in order to generate a XLS file. However, FoxPro is evidently using the IDispatch form of the Excel interfaces instead of the VTable interface. How do I write the program so that FoxPro will use the VTable interface instead Your welcome. 70000 rows is not too much, strange you needed it. Sorry it took so long to acknowledge your reply ...Show All

• Alex Calugarescu COPY TO CommandHi Cetin,

  In Visual Foxpro, I am trying to create a CSV file using the COPY TO command with TYPE CSV, but do not want header fields on top of the output file. Furthermore, I am also trying to attach a COMMA after every row. Current Output f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16,f17 "0","49162","0","0","0","0","0","0","0","0", ...Show All

• lbalogh VFP6-Did anyone experience this problem (with ActiveX Ctrl)?

  hello guys, I post here my problem and hope that there will be certain VFP expert to help. The problem was that when i call the MouseDown event from an OleListView control (this ole is inserted in FORM1). This MouseDown event will show a shortcut menu (1st shortcut). A Command in the 1st shortcut will open a modal form named FORM2 and on form2 is also placed another activeX listview control. The MouseDown event of this olelistview will show a ...Show All

• Arjen Stolk Form won't close

  Hi, folks. I'm facing yet another strange problem. I'm using VFP6 and SQL Server thrgouh an ODBC connection. I hava a form tha works with the database server. If I don't run any data modification commands, it works perfectly. But if I run a certain stored procedure, when I try to release the form, it simply won't close. As if it wasn't strange enough, it does run the "destroy" method of the class. It just won't   ...Show All