In stock or Not in stock (1 Viewer)

[jeffreylewis]

The attached file is the current event coding on a Browser-form which reads a suppliers items
whether they are in stock = 1
whether they are Not in stock = 0

There must have been a change some 2 days ago because for the last 6 years it worked perfectly
As I see it either:

• The supplier's website has been changed
• My Access 2007 has changed

Grateful for any help
Thanks JEFF

 

[Gasman]

Well Access 2007 will have not be changed in years, so I would go with the other one.
Why not inspect the page?

 

[The_Doc_Man]

Jeffrey, let's ask another question... what is the specific symptom that makes you think something is wrong? Saying "Code blows up here" tells us WHERE it fails but not HOW it fails, and that failure mode is important.

And by the way, if your browser is any of the main suspects (Bing, Firefox, IE, Opera, Chrome, Safari, etc), your third option is that your browser has changed. Are you using something from your browser's library to help you scrape what you want from the page? I see you are using MS XML tools, but are any browser-specific tools in use from the main browser suspects?

 

[jeffreylewis]

Thanks Doc_Man I Am probably in a different time zone to you, so I won't see this until tomorrow
I have attached 2 other files to clarify. The website that is feeding is
Is a typical product /item

Jeffrey, let's ask another question... what is the specific symptom that makes you think something is wrong? Saying "Code blows up here" tells us WHERE it fails but not HOW it fails, and that failure mode is important.

And by the way, if your browser is any of the main suspects (Bing, Firefox, IE, Opera, Chrome, Safari, etc), your third option is that your browser has changed. Are you using something from your browser's library to help you scrape what you want from the page? I see you are using MS XML tools, but are any browser-specific tools in use from the main browser suspects?

 

[jeffreylewis]

I would like to have posted you the feeder website but I get "Your content can not be submitted. This is likely because your content is spam-like or contains inappropriate elements. Please change your content or try again later. If you still have problems, please contact an administrator.
Your content can not be submitted. This is likely because your content is spam-like or contains inappropriate elements. Please change your content or try again later. If you still have problems, please contact an administrator."

You can read what I am trying to send in the top left corner of the form starts Machine Mart

Thanks

 

[CJ_London]

we can see the line affected - so what is the error message?

Only thing I can see wrong with line is if the value is null then substitute 0 (what the nz function does). But then you would be trying to compare the number 0 with text - which I would thing would generate an error.

Other possibilities is the getelementsbyname array is itself null - so you cannot get element 0.

The error message should tell you which.

You say the code has not been changed for 6 years so I would walk the code and check you are getting values you expect.

 

[The_Doc_Man]

I would like to have posted you the feeder website but I get "Your content can not be submitted.

That is because, unfortunately, we have had bad experiences with folks who try to post inappropriate content. In the last three weeks I personally (as only one of a dozen moderators) have had to eliminate at least six or eight spammer accounts PER WEEK, mostly from either gambling sites or "escort services." We have had to impose limits on posting web links until you reach a certain number of posts. That is the origin of the message you described.

The last three weeks, it has been gambling sites more than anything else. Maybe 2/3 of what we get to deny membership are gambling sites from either Bangladesh or Vietnam. But sometimes we get other countries chiming in. All of them are looking for web sites they can hack to put up bad links or free advertising.

 

[Gasman]

I would like to have posted you the feeder website but I get "Your content can not be submitted. This is likely because your content is spam-like or contains inappropriate elements. Please change your content or try again later. If you still have problems, please contact an administrator.
Your content can not be submitted. This is likely because your content is spam-like or contains inappropriate elements. Please change your content or try again later. If you still have problems, please contact an administrator."

You can read what I am trying to send in the top left corner of the form starts Machine Mart

Thanks

Here is what you should be doing.

On that page you have

and the one below multiple times.

However as always, WALK YOUR CODE.

I seem to recall @Edgar_ and @arnelgp are the two webscraping gurus, or at least those that post the most about that.