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: *

  1. johan3000

    simple vfox9 program MAIN (template)

    all people in this forum are very helpfull. Thanks alot... Happy Valentine!
  2. johan3000

    simple vfox9 program MAIN (template)

    Hi MikeLewis, in a form, I let the user do the entering/editing in journalEntry table and also inside this form, there is a commandButton to do the sorting/packing unused record of journalEntry.... I think this is a mistake... should let the user exit the journalEntry form then do the...
  3. johan3000

    simple vfox9 program MAIN (template)

    thanks so muck Mike, on the subprogram (in vfox9 we called it FORM/documents) do we do the : open database use table1 use table2... .............. close databses most form have this kind of activity ? and can we reindex and do the sorting/packing anytime ?
  4. johan3000

    simple vfox9 program MAIN (template)

    hi All, is there any example the proper way to write the MAIN program of vfox9, where it includes menu and many form ? How do you break down the program (sub program) ? what is the main window style ? etc... PUBLIC.. ON KEY... SET command ... WITH _screen .Caption = ..... ENDWITH DO...
  5. johan3000

    how to handle different screen size

    thanks bro markftwain mwResize50 work perfectly. thanks bro MikeLewis (Programmer) Anchor is the solution.' here is the posting og bro danfreeman, also very useful danfreeman (Programmer) 22 Jan 11 1:15 What version of VFP? If it's VFP9, explore .Anchor on each control. Then, in the...
  6. johan3000

    how to handle different screen size

    Hi All, If the window screen could be one of : 800x600 1024x768 1280x768 1. Then how to write the code to get the current screen size and determined the grid, row, fontsize in that form ? 2. how to max the window/form size ? 3. if the screen size is bigger, then allow the user to change the...
  7. johan3000

    how to rotate excel object ini powerpoint2003 ?

    Hi all, I prefer printing excel worksheet (mutliple region) in powerpoint because it is easy to layout. The problem is some worksheet need to be print in portrait or landscape... so is it any way to rotate the excel objdect in the powerpoint ? While I have not find the solution, I setup 2...
  8. johan3000

    Form within a form

    main form with grid (all records) text (search text) filter (search button) the grid is use to entering the data and if the user do the filter, then the grid only display the filtered records this scheme work well for me. to emphasize in filter mode could change the backgroud or frame...
  9. johan3000

    how CTRL+UPARROW to copy above cell in a GRID ?

    thanks MikeLewes n danFreeman, your answers are very helpful. Here is my code (tested) in the in the grid object:text1, procedure:keypress LPARAMETERS nKeyCode, nShiftAltCtrl LOCAL cInfo, nRecNo * This part allow the user to copy above/below cell * using ctrlUp or ctrlDn * * nShiftAltCtrl...
  10. johan3000

    how CTRL+UPARROW to copy above cell in a GRID ?

    Hi ALL, in inkey() : Key Alone SHIFT CTRL ALT UP ARROW 5 56 141 152 DOWN ARROW 24 50 145 160 where and how I can trap the CTRL+UPARROW n CTR:+DNARROW to do the job? (is it using INKEY or what?) this is what I have in VALID clause in a...
  11. johan3000

    how to lock some record in BROWSE window ?

    Thanks so much, MikeLewis I will try to work it out....(although that is hard for me) Happy new Year 2011. and Merry X'mas too
  12. johan3000

    how to lock some record in BROWSE window ?

    bro Olaf, I had been trying but still not working... Is there a way to set the journal.dbf such that the only last 100 records can be modify in a grid ? would you mind to show me some hint (code) ? thanks...
  13. johan3000

    how to lock some record in BROWSE window ?

    thisform.grid1.ReadOnly bro Olaf, your suggestion is there will 2 grid object on the form ? and the grid will split by 2 1. upper part grid1 old data 2. bottom part grid2 editing current data But is there possible just to have one grid doing the job? so the user will have bigger area...
  14. johan3000

    how to lock some record in BROWSE window ?

    So I should set all the object in the grid as follow ? thisform.grid1.oAccNo.txtAccNo.ReadOnly=currentMonth(journalDate) where : function currentMonth(xDate) return year(now())=year(xDate) .and. ; moth(now())=month(xDate) please help!
  15. johan3000

    how to lock some record in BROWSE window ?

    * get the date begining of last month 01-lastMonth-YY zdBOL = DATE( YEAR(zdJnlLast),MONTH(zdJnlLast ),1) * Current month in zebra color (diff ref_no diff color) * any other month with white color (to prevent miss input) thisform.grid1.SetAll("DynamicBackColor", ; "IIF(EMPTY(journal.ref_no)...
  16. johan3000

    how to lock some record in BROWSE window ?

    MikeLewis: let them double-click on the row they want to edit johan3000: doubleClick will decrease the efficiency OlafDoschke: I'd take two grids, a normal one for the current month and a readonly one for previous data. johan3000: this would be a good idea... I just thinking only one grid with...
  17. johan3000

    how to lock some record in BROWSE window ?

    thanks bro Olaf n Mike,... I think here is the example that I search : dynamiccurrentcontrol http://www.tek-tips.com/faqs.cfm?fid=1939 all of you are very helpfulll long live the VFOX...
  18. johan3000

    how to lock some record in BROWSE window ?

    Hi All, I wrote an General Ledger program, browsing a list of record (date,refno,accno,info,Debet,Credit). While browsing that data, it would be nice to protect all the previous month entries not to be modified. 1. Is they any easy way to protect some of the record in browsing (specify by the...

Part and Inventory Search

Back
Top