Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MarciaAkins
  • Order by date
  1. MarciaAkins

    How to add combox in a grid row VFP 9.2

    You can download the white paper and sample code from my conference session entitled "How to put a combo in a grid". You will find it on the Tools and utilities page of my web site. Marcia G. Akins www.TightlineComputers.com
  2. MarciaAkins

    Selecting a Specific Excel Worksheet from VFP

    If you have named your worksheets, you can reference them by name. You can also reference them by index. oXl.ActiveWorkBook.WorkSheets( "Mar" ).Activate() or oXl.ActiveWorkBook.WorkSheets( 3 ).Activate() Marcia G. Akins www.TightlineComputers.com
  3. MarciaAkins

    How to copy and paste a PDF file as attachment?

    You should create a subfolder under the application's home directory especially for your PDFs and save your PDFs there. Then you can use a character field in your table to point to the DBF. Marcia G. Akins www.TightlineComputers.com
  4. MarciaAkins

    Grid Double Click

    You did not say which version of VFP you are using. In version 8 and later, you can use BindEvent() to handle it like this: FOR lnCol = 1 TO This.ColumnCount loColumn = This.Columns[ lnCol ] FOR EACH loControl IN loColumn.Controls IF LOWER( loControl.BaseClass ) = 'header'...
  5. MarciaAkins

    Resize Common Dialog

    *-- Class: acxcommondialog (e:\marciapresents\activex\libs\activex.vcx) *-- ParentClass: olecontrol *-- OLEObject = C:\WINDOWS\system32\comdlg32.ocx * Define Class acxcommondialog As OleControl Height = 37 Width = 36 *-- The folder from which the file(s) were selected cpath =...
  6. MarciaAkins

    Resize Common Dialog

    AFAIK, the common dialog is resizeable by default. This is one of the values for the flags property of the control. The flags property controls the appearance and the behavior of the dialog. This is similar to the DialogBoxType parameter in the native VFP MESSAGEBOX() function: the values of...
  7. MarciaAkins

    List Box

    This.ListIndex Marcia G. Akins www.TightlineComputers.com
  8. MarciaAkins

    Hide Grid Row

    One word of caution - filters in grids are not Rushore optimizeable. Marcia G. Akins www.TightlineComputers.com
  9. MarciaAkins

    Hide Grid Row

    Thew short answer is no. Instead, create a view that excludes the records you do not want to display and use the view as the grid's RecordSource instead. Marcia G. Akins www.TightlineComputers.com
  10. MarciaAkins

    Select statement : COMMA DELIMITED

    Because copy to is a VFP command and SQL Server doesn't understand VFP. What you need to do is to connect to SQL Server from VFP and use SQLEXEC to run your query. This will give you a local VFP cuors and you can use the COPY TO command on that, See SQLCONNECT(), SQLSTRINGCONNECT(), and...
  11. MarciaAkins

    VFP 9: Line Graph DataLabels

    It is a property of the point interface in the MS Graph object model. Marcia G. Akins www.TightlineComputers.com
  12. MarciaAkins

    Vanishing Combo VFP9

    I am so sorry for not being more specific. If you had wanted to turn off Themes support for the entire app, all you needed to do was to set _Screen.Themes = .F. at the beginning of your main startup program. Marcia G. Akins www.TightlineComputers.com
  13. MarciaAkins

    Error 43 : Not enough memory to complete operation

    ...problem on PC's with 1Gb memory or more and limiting the buffer size fixes it. You can try to limit the size of VFP buffers. SYS(3050, 1, 512*1024*1024) SYS(3050, 2, 512*1024*1024) Also try to call SYS(1104) after command that process large tables. It clears memory cache and buffers...
  14. MarciaAkins

    Vanishing Combo VFP9

    What happens if you set Themes to .F. ? Marcia G. Akins www.TightlineComputers.com
  15. MarciaAkins

    Graph in Report

    If you want to display a graph iun a Visual Foxpro report, go to the tools and utilities page of my web site and download the white papaer and code samples from my conference session entitled "Creating Graphs With VFP". There are code samples that print the generated graph in a report. Marcia...
  16. MarciaAkins

    multiple table on single report

    If you are using VFP 9, I believe that you can do this quite easily using multiple detail bands. Marcia G. Akins www.TightlineComputers.com
  17. MarciaAkins

    VFP main menu

    The metadata for the VFP menu is stored in a table name <<menu name>>.mnx with an associated memo file called <<menu name>>.fpt. You shoould be able to access the metadata in the menu table using the OLEDB provider for Visual FoxPro. If you have a copy of Visual FoxPro, you can print this...
  18. MarciaAkins

    resizing forms

    Here is the code from my resizer class. To use it, add this code in the Init() of your base form class: *** Add the resizer This.NewObject( 'Resizer', 'stdResizer', 'stdCustom.vcx' ) RETURN DODEFAULT() and add this code to the form class's resize method: This.Resizer.AdjustControls()...
  19. MarciaAkins

    resizing forms

    ...the top of my head. LOCAL lnFiles, lcCurdir, lnCnt, lcFile lcCurdir = FULLPATH( CURDIR() ) CD ( <<Your forms folder>> ) lnFiles = ADIR( laFiles, [*.SCX] ) FOR lnCnt = 1 TO lnFiles lcFile = FORCEEXT( laFiles[ lnCnt, 1], 'SCX' ) USE (lcFile) LOCATE FOR LOWER( ALLTRIM( class ) ) ==...
  20. MarciaAkins

    Reading the content of PST files From VFP OR VB

    If you ever subscribed to FoxTalk magazine before it went down the tubes, Andy and I had an article about this in the October 2002 issue called Another look at Outlook. While Hentzen followed up the next month with an article called "Look Out! Its Outlook!" that gave code to extract all the...

Part and Inventory Search

Back
Top