Solved

Run-time error '30009' Invalid row value

Posted on 2003-10-26
4
3,193 Views
Last Modified: 2013-12-25
Hello!

I know this error has been talkt about here earlier but I can't still figure out what's wrong with my code. Suddenly I started to get this error message though I didn't touch anything. The program has been running without this problem. So, here is a part of my code. Don't know if this helps anyone.

Public Function Change_wrinkling_capacity()
    'FACE 1 SEARCH WRINKLING VALUES FROM WRINKLING GRID AND PUT THEM INTO     RESULTS_FORM CAPACITY VALUES
     
      Materialfactors.Row = 2   'get materialfactors wrinkling in the span  THIS ROW WAS HIGHLITED
     
     
      For i = 1 To Wrinkling_grid.Rows - 1
        Wrinkling_grid.Col = 1
        Wrinkling_grid.Row = i
           
            If Wrinkling_grid.Text = country_combo.Text Then                'check for country
                Wrinkling_grid.Col = 2
               
                    If Left(Wrinkling_grid.Text, 8) = Left(face1_type.Text, 8) Then         'check for face1_type
                        Wrinkling_grid.Col = 3
                       
                            If Wrinkling_grid.Text = wool_type.Text Then    'check for wool_type
                                Wrinkling_grid.Col = 4                      'wrinkling in the span
                                Materialfactors.Col = 4                      'materialfactor for serviceability limit state
                                calc_capacity = Val(Wrinkling_grid.Text) / Val(Materialfactors.Text)
                                calc_capacity = Format(calc_capacity, "0.00")
                                calc_capacity = Replace(calc_capacity, ",", ".")
                                results_form.capacity(1).Caption = calc_capacity
                               
                                Wrinkling_grid.Col = 4                      'wrinkling in the span
                                Materialfactors.Col = 3                      'materialfactor for ultimate limit state
                                calc_capacity = Val(Wrinkling_grid.Text) / Val(Materialfactors.Text)
                                calc_capacity = Format(calc_capacity, "0.00")
                                calc_capacity = Replace(calc_capacity, ",", ".")
                                results_form.capacity(13).Caption = calc_capacity
                               
                                Wrinkling_grid.Col = 5                      'wrinkling at the support
                                Materialfactors.Row = 3
                                Materialfactors.Col = 4                      'materialfactor for serviceability limit state
                                calc_capacity = Val(Wrinkling_grid.Text) / Val(Materialfactors.Text)
                                calc_capacity = Format(calc_capacity, "0.00")
                                calc_capacity = Replace(calc_capacity, ",", ".")
                                results_form.capacity(3).Caption = calc_capacity
                               
                                Wrinkling_grid.Col = 5                      'wrinkling in the span
                                Materialfactors.Col = 3                      'materialfactor for ultimate limit state
                                calc_capacity = Val(Wrinkling_grid.Text) / Val(Materialfactors.Text)
                                calc_capacity = Format(calc_capacity, "0.00")
                                calc_capacity = Replace(calc_capacity, ",", ".")
                                results_form.capacity(15).Caption = calc_capacity
                            End If
                    End If
                End If
            Next i
           
0
Comment
Question by:HLEA
  • 2
4 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 9623688
Check out this article from MSDN:

PRB: Grid Custom Control: LeftCol/TopRow Valid Values
http://support.microsoft.com/default.aspx?scid=kb;en-us;80911

Anthony
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 125 total points
ID: 10141523
Do you need any more help with this question?
0
 
LVL 1

Expert Comment

by:ayufans
ID: 10390700
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- answered by acperkins

Please leave any comments here within the next four days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

ayufans
Cleanup Volunteer
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ms access #TYPE! error on report when no data 4 77
Access query that references subform 5 47
How to read File Date Created using VB6 8 40
Excel Automation VBA 19 74
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question