January 9, 2009 12:23am pst

11.21.2008 at 08:25AM PST, ID: 23925544

	[x] Attachment Details

VB 6 Error - multiple step operation generated errors. Check each status value

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.0

Zones:

VB Database Programming, Windows XP Operating System, Microsoft Operating Systems

I have an application that works well with all users exept one who has the error 'multiple step operation generated errors. Check each status value' on 2 machines.
The same user can run the program fine on other machines. All the PC's concerned are running XP service pack 3 and Office 2007.

The code point that the program is crashing on is in the code below.
It processes the first part of the sub - the airport cost record. It finds the record in the underlying table of the recordset and if it is not there it will create a new record but crashes when it moves to the second part - the Fuel record. I thought it might be a MDAC problem so got the user to install MDAC2.6 and still the problem persists but only on 2 machines.

I have tested the program on all combination of systems - XP and Vista with all versions of Office installed on these computers and can not reproduce this error.

Is there any Expert out there that can shed any light on this mistery

Code snippet
Public Sub AirportCosts1()
' --------Find Airport Cost Record-------
AirportCostRS.MoveFirst
AirportCostRS.Find ("AcIata = '" & SectorAircraft + TxtApIATA1.Text & "' ")
If AirportCostRS.EOF Then Call AddNewAirport1 ' Create new record if does not exist
TxtHandlingChargeMethod1.Text = AirportCostRS.Fields("HandlingChargeMethod")
TxtRampHandlingDayC1.Text = AirportCostRS.Fields("RampHandlingDayC")
TxtRatePerKiloDay1.Text = AirportCostRS.Fields("RatePerKiloDay")
TxtFixedOneWayHandlingDayC1.Text = AirportCostRS.Fields("FixedOneWayHandlingDayC")
TxtComOneWayHandlingDayC1.Text = AirportCostRS.Fields("ComOneWayHandlingDayC")
TxtCateringCargo.Text = AirportCostRS.Fields("CateringCargo")
TxtTerminalNavCost1.Text = AirportCostRS.Fields("TerminalNavDeparture")
TxtTaxiOutTime.Text = AirportCostRS.Fields("TaxiOutTime")

'-------Find Fuel record-------
FuelDataRS.MoveFirst
FuelDataRS.Find ("[iata]='" & TxtApIATA1.Text & "'")
If FuelDataRS.EOF Then Call NewFuelRecord1 'create new fuel record
TxtFuelPrice1.Text = FuelDataRS.Fields("FuelPrice1")
TxtFuelDate1.Text = Format(FuelDataRS.Fields("FuelDate1"), "dd-mmm-yy")
Exit Sub

Start your 7 day free trial to see this answer

Answered By:	Aerocom
Expert Since:	06/20/2001
Accepted Solutions:	14
Computer Expertise:	Advanced

Aerocom has been an Expert for 7 years 6 months, during which he has posted 248 comments and answered 14 questions. Aerocom is just one of 625 experts in the VB Database Programming Zone. 1 expert collaborated on this answer, which was graded an "A" by the asker.

#	Title
1	Trouble Updating MDAC
2	Data provider...returned an E_FAI…
3	Custom MDAC Garbage Collection?
4	MDAC setup
5	Which MDAC to use
6	Determining MDAC version