the row i need

Posted on 2002-06-30
Last Modified: 2010-05-02
'Grade is initalized
Grade = .txtGrade.Text

'step is initalized from RSGrad table
'as the first value in field grstNumber
step = RSGrad!grstNumber

'when the row is the initalized Grade row, get the other
'fields values which are grstStart and grstIncrease
Do Until step = Grade
   step = step +1
   StartAmount = RSGrad!grstStart
   StepInc = RSGrad!grstIncrease

OK i know my loop is ilogical but i don't know how to use the step as an index or something so i can get the values of the other fields.

Question by:almaha
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
LVL 75

Expert Comment

by:Anthony Perkins
ID: 7119871
Please maintain your open questions:

more than one plot Date: 05/02/2002 05:03PM PST
GD module Date: 04/21/2002 03:39PM PST
imagecreat Date: 04/20/2002 05:31PM PST
charts! Date: 04/18/2002 06:52PM PST
checkbox Date: 04/15/2002 06:50AM PST
Check Boxes Date: 04/06/2002 08:33AM PST
Open a pop-up window Date: 04/05/2002 06:56AM PST
Underlined link Date: 05/16/2002 08:09AM PST


Author Comment

ID: 7119878
none of them is solved and none of the comments is an answer! what shall i do.
LVL 75

Expert Comment

by:Anthony Perkins
ID: 7119889
Re-read the EE Guidelines ( and / or post a comment in Community Support.

You can chosse not to finalize your questions, just be aware that experts are less inclined to help in this case.  It is your choice.

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 7119919
OK Done will you please help me on my question?

Expert Comment

by:Mahdi Mansour
ID: 7120011
i don't think that i understand ur question ,,,,,
u want to get the values of the other fileds from the same row ...???!!!!!!

plz clerify ur question more....


Accepted Solution

PNJ earned 100 total points
ID: 7121750
It looks like you're using a Recordset (RSGrad) so why can't you find the record you want by using a SELECT statement?

eg using ADO: SQL = "SELECT fields FROM table WHERE grstNumber = " & Val(txtGrade.Text)
Set RSGrad = New ADODB.RecordSet
RSGrad.Open SQL, connection, adForwardOnly

and then

StartAmount = RSGrad!grstStart
StepInc = RSGrad!grstIncrease

Expert Comment

by:Mahdi Mansour
ID: 7127085
Ya i agree with PNJ , use a select statment ...

Author Comment

ID: 7130844
it didn't work :s but at least you gave a solution :) thX

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…

734 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