How to fix grid headings?

Visual FoxPro General

Index ‹ Visual FoxPro

- Previous
  - 1
    - Field names from excel import You can determine the field names by creating the cursor or table before you do the import. For example, given an Excel spreadsheet with five columns of data from the Northwind sample database, you can create a table with the desired column names and then import from the spreadsheet, like this: Code Block CREATE TABLE tblNorthwind ( cCustomer c(10), cCompany c(50), cContact c(30), cCountry c(20), cPhone c(20)) APPEND FROM northwind. xls TYPE xl8 Just be sure to create the table with the column names in the same order as the columns in the spreadsheet. Then when you import the data, it will be in the desired columns in the VFP table. To answer your second question, the table is written to the current directory at the time the table is created. If you're running the code from the command window, you can check use CD or SYS(2003) to check what the current directory is. -Rick Tag: How to fix grid headings?
  - 2
    - Expecting Advise on A Graphics Problem Tolga, You can provide a canvas by placing slider controls. However using a map activex like mapObjects, mapPoint etc would be much easier (search for GIS,activex keywords, you have a chance to find a free one). Lines are problematic to manage for map drawings yourself (it works, I too did it but doesn't worth the effort I think). PS: If you're living in Izmir and can visit me (DEU deniz bil.veTek.Enst. - close to Turkuaz-Inciralti), I can show you how it works with activex. Tag: How to fix grid headings?
  - 3
    - DotDotDot Check the trimming options in the report field properties. The ellipsis is the default, but you can control how data gets trimmed. But the simplest way to do this is to convert the data anyway - create a field whose content is simply: MDY( date1) + " - " + MDY(date2) or whatever Date-to-character format you want your dates to display as. Then you can be sure that the field size will be consistent. Tag: How to fix grid headings?
  - 4
    - ComboBox Control There are several ways to achieve your functionality. I would probably go with create cursor curItems (cItem C(30)) &&, cOrder C(1)) *index on cOrder + cItem insert into curItems values ('(Please Select)') insert into curItems select Item from myTable order by 1 and use this cursor as the RowSource for your combobox. Tag: How to fix grid headings?
  - 5
    - vfp9 error reading file 1104 on server 2003 First at all you may check if users who are using vfp application have enought rights to access the files, granted by os. Tag: How to fix grid headings?
  - 6
    - How to send email by using default email client installed on user's machine You have a number of options - http://fox.wikis.com/wc.dll Wiki~AutomatedEmail~VFP probably lists them all. Also Craig Boyd has done some articles on the subject with much sample code, starting with http://www.sweetpotatosoftware.com/SPSBlog/PermaLink,guid,8f569366-c76a-4873-9029-f31c07cf125e.aspx Regards Tag: How to fix grid headings?
  - 7
    - adding carriage return and line feed through foxpro oledb provider You may tray to add CHR(13) before CR: string1+CHR(13)+string2... Tag: How to fix grid headings?
  - 8
    - MS Access importing visual foxpro tables Use VFPOLEDB driver instead of ODBC driver. ODBC driver is not aware of new VFP table formats (ie: it wouldn't recognize a free table created using VFP9 - even if it did there would be problems with datatypes that it doesn't know. ODBC driver is not updated after VFP6). Unfortunately I don't know how you could import using an OLEDB connection in Access via menus (though I remember I did it in the past programmatically. Since Access help has reference to ADO, Excel 2003 can do that using menus there should be a way). If I were you I wouldn't downsize from VFP to Access but maybe upsize to SQL server instead. Tag: How to fix grid headings?
  - 9
    - How to create a VFP program whose name should not be shown during runtime in task bar, task list, systray ? Config.fpw: screen=off and no UI element would do it. ie: * my background task.exe - main.prg Code Block Local oTimer oTimer = createobject('myTimer') Read events Define class myTimer as Timer Interval = 1000 Started = datetime() Procedure Init Strtofile("I'm running... "+ ttoc(datetime()),"started.txt") Endproc Procedure Timer If DateTime() > this.Started + 30 This.Enabled = .f. Strtofile("Stopped at "+ttoc(datetime()),"started.txt",.t.) Clear events Endif Endproc Enddefine Tag: How to fix grid headings?
  - 10
    - Need help with report expression Hi Jennifer Code Snippet IIF(EMPTY(grntradd) OR ISNULL(grntradd) OR PROPER(grntradd)=PROPER(mailaddr),"Not Available",PROPER(grntradd)) &&& ) Tag: How to fix grid headings?
  - 11
    - Command Window in Vista What do you mean by "VFP 9 Management Studio" I haven't seen anything like you describe, so I'd be suspicious that you've turned on some kind of special handler that's interfering. Maybe something complex in IntelliSense Tamar Tag: How to fix grid headings?
  - 12
    - Assigning an array to an Activex property This migh work for you: o.RxNumbers = getArrayRef("arrRx") procedure getArrayRef(tcArrayName) return @&tcArrayName Tag: How to fix grid headings?
  - 13
    - importing from excel Thanks Naomi, I've not managed to get VFP OleDb to work properly either. I had thought of opening up a low-level file and populating a table as it runs through character strings. I think that would do the job - it just seemed like a lot of work. And I'm lazy! Tag: How to fix grid headings?
  - 14
    - webbrowser newwindow event You may check : http://msdn2.microsoft.com/en-us/library/ms379558(vs.80).aspx Tag: How to fix grid headings?
  - 15
    - Importing data from Excel into a FoxPro Memo field I am not sure, but I don't think is working.May be if you import xls file first in a table and after that to try to format a vector with data to put it in a memo field... Tag: How to fix grid headings?
  - 16
    - Outlook 2003 won't open A recent update caused a similar situation for me and I restored my system to an earlier time before the update. Tag: How to fix grid headings?
- Next
  - 1
    - How to Copy 2 worksheet from one excel sheet to to 2 Worksheet of another Excel Sheet What language are you writing this in. Your code looks like some VB variant, but you're asking in a Visual FoxPro group. Tamar Tag: How to fix grid headings?
  - 2
    - userprompt Depending on the interface (look) you want to show, you can use a form and a textbox. There is a simple function: InputBox() http://msdn2.microsoft.com/en-us/library/aa979056(VS.71).aspx but I do not think it was available in VFP6. I think it came out in VFP 7.0 Why do you use such an outdated version anyway BTW, for historical illustration, the old way to do it in the days before Visual FoxPro, was with @..GET Tag: How to fix grid headings?
  - 3
    - Some more Excel automation questions 1. Yes, this can easily be done. In the sample DBFToExcel function I posted in another thread here there was a sample doing this, I also saw samples recently on another forum. Here is a function sample http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1607610&SiteID=1 Code Snippet IF m.tlLockHeaderRow && we need to prevent headers from modifying ** Code from Borislav Borissov loSheet.UsedRange.SELECT loExcel.SELECTION.Locked = .F. && First we need to UNLOCK all cells loExcel.ROWS(m.lnLines + m.lnoffset).SELECT && Select the header row of the sheet loExcel.SELECTION.Locked = .T. && Lock Cells in the header row loExcel.ActiveWorkbook.ActiveSheet.PROTECT(,.T.,,.T.) ENDIF 2. Perhaps it's better to be done in MSHFlexGrid. Tag: How to fix grid headings?
  - 4
    - Why won't this commit to the local FoxPro Table? It's better to not use thisform properties (objects) in UPDATE, SELECT, INSERT statements but rather local variables. Code Snippet local lcNewDescrip, lcNewRate, lcNewPriority, lcNewHeadingNum lcNewDescrip = ALLTRIM(Thisform.txtDescription.Value) lcNewRate = ALLTRIM(Thisform.txtrate.Value) lcNewPriority = ALLTRIM(Thisform.txtpriority.Value) lcNewHeadingNum = ALLTRIM(thisform.cbopageType.Value) UPDATE adtype ; SET adtype.description = m.lcNewDescrip, ; adtype.rate = m.lcNewRate, ; adtype.priority = m.lcNewPriority, ; adtype.headingnum = m.lcNewheadingNum ; WHERE adtype.booktype = cAddEditAdtype.booktype AND ; adtype.bookcode = cAddEditAdtype.bookcode AND ; adtype.adtype = cAddEditAdtype.adtype Tag: How to fix grid headings?
  - 5
    - Historical FoxPro What is FoxPro back up A third party software Tag: How to fix grid headings?
  - 6
    - Validations on Textbox Use this code: IF ISBLANK (thisform.text2.value) MESSAGEBOX ("please...") RETURN .f. &&abort execution of rest of the code ENDIF it works only for the text fields, for numerical fields you should change the code, anyway I don't think that you are going to have both text and numeric data types in single textbox Tag: How to fix grid headings?
  - 7
    - File is in use by another What version of Windows is this IIRC since XP, Windows has automatically suggested a chkdsk on reboot when it can't get exclusive access. Try scandisk if it is an older version. Also try temporarily disabling any realtime antivirus protection on the drive to be scanned. If the .idx file is corrupted just delete it as that is the index file you are trying to create anyway. Tag: How to fix grid headings?
  - 8
    - Drag and Drop with Listbox Have you seen the sample provided with VFP Open the Task Pane Manager, go to Solution Samples | Controls | List Box and try the "Move items between listboxes" example. It may answer all your questions. See: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/ceef4ee0-0b13-498a-ad2b-33c095d86724.asp frame=true Tag: How to fix grid headings?
  - 9
    - Memo file is missing or invalid Hi Selim, You may lose/have lost all the information in your Memo fields. One way to get the table to open is to create another table with one field for each Memo column in your problem table, named with the same names as your table. After you create your table, don't add any records. Close it. Rename the FPT file with the same name as your problem table. After this you should be able to open the problem table. As always, make a backup before doing this process so if you create more problems you can go back to what you had. Often this type of Memo corruption comes from shutting down a computer when the table is open. This can be due to an unreliable network or a user. Beef up the network and educate the users to close out of the app before they turn off their computers, as appropriate. Tag: How to fix grid headings?
  - 10
    - image from file Put an image control on the form and add two last lines of code in this procedure: clear resources thisform.Image1.Picture = m.lcFile Tag: How to fix grid headings?
  - 11
    - Need better performance with FP Tables Dave; Going Gigabit would certainly help, but I suspect your problems are on the software side. How exactly do you 'run an update' Tag: How to fix grid headings?
  - 12
    - Problem with Vista Windows mail Yes, on the same mentioned site in your other thread I saw this problem reported as well. I found a similar thread with no real answer http://www.universalthread.com/wconnect/wc.dll 2,15,1237482 and another one with an answer from Nigell Gomm http://www.universalthread.com/wconnect/wc.dll 2,15,1165365 I'm not sure if it can help. Also what is the exact message number I found this website http://rselby.net/out2_3.htm which lists lots of different errors related with Outlook. Perhaps you would be able to find your answer there. Tag: How to fix grid headings?
  - 13
    - DCT FILE First I would try to pack it in VFP7 (work on a copy). VFP9 checks files more thouroughly for problems and finds issues that previous versions ignored. See: SET TABLEVALIDATE in help. Tag: How to fix grid headings?
  - 14
    - Visual FoxPro9 Report Designer BUG I followed exactly you steps, but I did not received the error. I am using Vfp 9 SP1... If you find a bug is good to report it, may be will be solved in SP2.( but must be sure it's a bug) Tag: How to fix grid headings?
  - 15
    - Sqlexec() command line maybe too long. If you exclude "Subject" from command is working ...something like: SQLEXEC(m.temp1, "INSERT INTO MsgInfo (ID, creator, created, sequenceNo, EnvCount, Status, StatusTime, Body, BodyType); VALUES ( MsgInfo_ID, Strategic.sg_creator, &temp_time, MsgInfo_ID, '0', '3', &temp_time, Body_ID, 'ASCII' )") Tag: How to fix grid headings?
  - 16
    - OLEDragDrop errors Can you please provide some code Right now it's hard to guess what may be a problem. Tag: How to fix grid headings?