Search results for query: *

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

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...

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 ?

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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!

* 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)...

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...

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...

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...