Need help changing a line of vb code

R

Rob

Our programmer is on vacation for a couple of weeks and I can't wait that
long to fix it.

This should be as simple as changing one line of vb code from
ProductAvailability to PackQuantity and I was hoping someone could tell me
where to find that in my file so I can make that change. Because of this
glitch (my fault I told programmer to update using the wrong field) i really
messed up some stuff.

The problem exactly is a field in the mdb CaseQty is being updated by the
wrong field in the xml
It is updating from
<SupplyDetail>
<ProductAvailability>40</ProductAvailability>
</SupplyDetail>

But it is supposed to be updated with

<SupplyDetail>
<PackQuantity>16</PackQuantity>
</SupplyDetail>


Thanks a lot.
Source file is located here. It is access 2002 I believe.

www.buggyonpurpose.com/random/UpdateProductWeight.zip
 
S

Sharkbyte

There is reference to an XML Tag labelled "ProductAvailability", and
associated to CaseQty, in the tblAdmin table. However, there appears to be
no reference to any factor similar to "40"

*Do the following at your own risk*

You could attempt to change the value of XML_UpdgateTag, on record w/
AdminID 10, to "PackQty" (or whatever the correct name is).

This may or may not be successful, and I accept no responsibility for this
suggestion.
 
R

Rob

The values 40 and 16 were just example values for the fields PackQty and
ProductAvailability.

I'll give that a try.
 
Top