943,878 Members | Top Members by Rank

Ad:
You are currently viewing page 3 of this multi-page discussion thread; Jump to the first page
Dec 18th, 2008
0

Re: most urgent

Grd_LeaveCell() in this procedure
If FlexGridEditor.Visible Then
strOldValue = Grd
Grd = FlexGridEditor.Value FlexGridEditor.Visible = False If Grd.Col = cItemCode Then
Call SetProductValues
End If
how you are putting Grd = FlexGridEditor.Value
Reputation Points: 7
Solved Threads: 1
Posting Pro in Training
firoz.raj is offline Offline
415 posts
since Dec 2008
Dec 18th, 2008
0

Re: most urgent

Referring Grd if same as referring to the Current Cell which is active.
u can even write

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1. Grd.TextMatrix(Grd.Row, Grd.Col) = FlexGridEditor.Value

When you press enter in the Product Id Column the FlexGridEditor control becomes visible populating all ur Products. When FlexGridEditor needs to be made Visible = False then the Value in the cell is temporarily stored in strOldValue and the cell is updated. Lest any problem, the old value can be replaced by

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1. Grd = strOldValue

Hope this solves ur doubt.
Is it working anyway?
Reputation Points: 26
Solved Threads: 40
Posting Whiz
aktharshaik is offline Offline
316 posts
since Aug 2008
Dec 18th, 2008
0

Re: most urgent

Sir
Same error method or data member not found.
Reputation Points: 7
Solved Threads: 1
Posting Pro in Training
firoz.raj is offline Offline
415 posts
since Dec 2008
Dec 18th, 2008
0

Re: most urgent

Can you not remotely access my pc through Goto My pc if i send setup of Goto my pc Since it is urgent that is why i am so hurry ?
Reputation Points: 7
Solved Threads: 1
Posting Pro in Training
firoz.raj is offline Offline
415 posts
since Dec 2008
Dec 18th, 2008
0

Re: most urgent

Ok. Send me the setup
Reputation Points: 26
Solved Threads: 40
Posting Whiz
aktharshaik is offline Offline
316 posts
since Aug 2008
Dec 18th, 2008
0

Re: most urgent

I think i identified ur problem. plz wait another 30 mins
Reputation Points: 26
Solved Threads: 40
Posting Whiz
aktharshaik is offline Offline
316 posts
since Aug 2008
Dec 19th, 2008
0

Re: most urgent

Reputation Points: 7
Solved Threads: 1
Posting Pro in Training
firoz.raj is offline Offline
415 posts
since Dec 2008
Dec 19th, 2008
0

Re: most urgent

Here's the solution for your error problem.
Attached Files
File Type: doc Solution.doc (96.5 KB, 10 views)
Reputation Points: 26
Solved Threads: 40
Posting Whiz
aktharshaik is offline Offline
316 posts
since Aug 2008
Dec 19th, 2008
0

Re: most urgent

Sir ,
Now Moderror.bas has thrown a error while run the form:
An error has occurred in the application in module
‘MR’ at procedure ‘grd_leavecell’.

Error Number :13
Type Mismatch
Please Contact Your System’s Administrator.
Reputation Points: 7
Solved Threads: 1
Posting Pro in Training
firoz.raj is offline Offline
415 posts
since Dec 2008
Dec 19th, 2008
0

Re: most urgent

When this error shows up, without clicking the OK button,

Press Ctrl + (Break/Pause) button and debug each statement execution by pressing F8 key (executing one line at a time for each press of F8 key) till the line of error in Grd_LeaveCell event is highlighted

and post the highlighted line in Grd_LeaveCell() event


Also change the following statement in RED your MR form.

Private Sub SetProductValues()

    Dim rs As New ADODB.Recordset

    On Error GoTo SetProductValues_Error

    rs.Open " SELECT ITEM_CODE, PRODUCTNAME, MAXOFUNIT FROM PARTDETAIL WHERE ITEM_CODE = '" & Grd.TextMatrix(Grd.Row, cItemCode) & "' ", con, adOpenKeyset, adLockReadOnly
    If rs.BOF = False Then
        Grd.TextMatrix(Grd.Row, cItemName) = rs!ProductName
        Grd.TextMatrix(Grd.Row, cUnit) = rs!MAXOFUNIT & ""
    End If

SetProductValues_Done:
    If rs.State Then rs.Close
    Set rs = Nothing
    Exit Sub

SetProductValues_Error:
    Call Process_Error(MODULE_NAME, "SetProductValues")
    Resume SetProductValues_Done

End Sub
Reputation Points: 26
Solved Threads: 40
Posting Whiz
aktharshaik is offline Offline
316 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: removing cell value at runtime
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: combining diacritical marks





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC