Recent content by ellehcsim

i have a MSFLEXGRID and a TEXTBOX on a form. on DESIGN TIME, i put the textbox on top of the flexgrid. but everytime i RUN the form, the flexgrid is always on top of the textbox making the textbox impossible to see. is there some activex issues on VFP8 that i should know? thank you very much!

tnx guys!

hi guys! is there a special function in VFP6 that checks if the user inputs a valid date. >>> function that works something like this. if IFDATE(thisform.text1.value) = .t. ... do something ... else messagebox("Invalid date.") endif thank you!!

hi guys! this is my code... ON ERROR do errorHandler lSqlString = &quot;update a_item_masters set a_field_her 'a'&quot; && This code should produce an ODBC Error SQLEXEC(g_connHandle,lSqlString,&quot;item_query&quot;) < 0 MESSAGEBOX(&quot;if this messagebox appears...

yes, does that PROCEDURE can be placed inside an EVENT? let say for example, can i include that PROCEDURE inside the BUTTON CLICK EVENT? THANKS AGAIN!

hi guys!! is there such a thing like this in VFP...? (start of code) ... ... ... (do something here) ... ... if (condition) GOTO LABEL sample_label else ... ... ... (do something again) ... ... endif...

thanks!!! it works!

i want the textbox to have a DATETIME format. is there a way to do this. or is there a way to put an empty DATETIME value in a textbox. coz if i do... &quot;thisform.textbox1.value = {}&quot; i only limit the textbox to DATE only for input. thanks you guys!

hi.! the code didn't actually work, but it gave me an idea. i got it working with this one.. ThisForm.grd1.Column4.DynamicForeColor = IIF(itemdetails_pr.qty_apprvd=0,&quot;255&quot;,&quot;0&quot;) Thanks KONUK! you did great!

hi experts, is it possible to change the font color of a specific column (not the whole row, just a record in one of the columns) depending on a certain condition. ive already tried this command but it didn't work...

Thanks! works perfectly fine!!

first of all, thanks.! But it didn't worked, sorry. it got all the data messed up in the combo box. :( this code.. select * from cur_hold_code into array ar_holdcode thisform.cbohold_code.clear thisform.cbohold_code.rowsourcetype = 5 thisform.cbohold_code.rowsource = &quot;ar_holdcode&quot...

i have this code... select * from cur_hold_code into array ar_holdcode thisform.cbohold_code.clear thisform.cbohold_code.rowsourcetype = 5 thisform.cbohold_code.rowsource = &quot;ar_holdcode&quot; is there a way to insert another item into the combo box? Please help. Tnx!

done.! thank you very much guys!

Hi, You can use create a view against free tables. The only thing that has to be in a DBC is the view definition. You can create the DBC and the view definition on-the-fly, and delete them when you're done. - ok, thanks for the info. but i guess this is my last option cause it might cause a...