Question 1. You've had a solution both from Marcia and myself, in the thread "Grid White Space"
>hi all,
>
>i need to insert two things at mycode under.
>1. if not found()
> =messagebox("not found")
>else
>....
>endif
>2. if i want to sum columns at the same code as
>sum t1 to thisform.pageframe1.page2.tex1.value
>
>any idea ,help
>
>with thisform.pageframe1.page2.Grid1
> .RecordsourceType = 4
> .Columncount = -1
> .Recordsource = 'select * from mstr'+ ;
> ' where UPPER(inname) = UPPER(TRIM(thisform.pageframe1.page1.text1.Value)) ' + ;
> 'and nam1 = thisform.pageframe1.page1.text4.Value'+ ;
>' into cursor crsMyCursor'
>
>ENDWITH
>
>thisform.pageframe1.page2.Grid1.refresh
>
>thanks
>m.qasem
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.