Solved

Run-time error '30009' Invalid row value

Posted on 2003-10-26
4
3,163 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

914 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now