subscript out of range problem

Question

0.00/5 (No votes)

See more:

this is th query in aceess

SQL

SELECT indents.pr_no, indents.issue_date, items.description, items.units, items.item_group, indentitems.quantity, indentitems.date_required, departments.system_name, departments.subsystem_name
FROM ((indentitems INNER JOIN indents ON indentitems.pr_no=indents.pr_no) INNER JOIN departments ON indentitems.department_code=departments.department_code) INNER JOIN items ON indentitems.item_code=items.item_code;

when i use the form wizard to make a form for this query the error box shows subscript out of range..
i dont understand what is happening
can anyone help please????
thanks in advance

Posted 28-Feb-11 20:05pm

execobra

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DaveAuld · Answer 1 · 2011-02-28T20:47:00

A subscript out of range error occurs when you are trying to move to a record which has an index about the upperbound of the collection.

e.g. if you have an array defined with 10 elements and you try to read element 11.

Without seeing code which is throwing the exception it is difficult to say the exact problem.

Suggest you step through your code until you find the line that throws the exception and then work out what you are doing with any index values.

A common error is forgetting that counts will be higher than index values and when iterating sets referencing the count, you need to subtract 1 from the upper limit.