Search results

Wow - you have just hit the nail on the head!! It turned out to be a firewall type of problem. The A2013 machine I'm testing on sits behind a proxy. I honestly had no idea that it would have an effect on the routine. I feel a bit like a cake now since there was not really a problem with the...

Good morning My results are still the same as in post #20 What version of Access did you test it on? Thanks

@arnelgp - I tried your code and at least did not get an error but MsgBox nPos = 0 MsgBox sResult = Lots of text but not what I was expecting. Not sure where it is coming from MsgBox strResult = Null I created a login for you in case you want to test in on your side strUserName and strPassword...

@JHB - Tried it thanks - not working

If I do the same on the A2003 machine it gives me this: - <api_result> - <data> <credits>12</credits> </data> - <call_result> <result>True</result> <error /> </call_result> </api_result>

I replaced the "IF" clause with the single line: xml_doc.Save ("c:\test.xml") The resulting file is empty inside...

As to your question about the xml structure. Not sure but here is the entire Function (I left out the bit bit in my OP): The code "log in" to the Bulk SMS service I'm subscribed to and checks the credits on my account. Works 100% in Access 2003 & 2007. Developed in 2003 and tested with Runtime...

Nope - did not work. Still getting err on same line I found a post here: http://stackoverflow.com/questions/20032610/vba-excel-selectsinglenode-syntax about the topic that it is a new thing in A2013 and after with ref to this site in Answer 1: https://support.microsoft.com/en-us/kb/313372 Also...

Same error...grrr - gosh this is mind boggling hey

Yes as per my OP - It is the line: If xml_doc.selectSingleNode("//api_result/call_result/result") = "True" Then Also note that if I debug the code there is no error - only when I execute it Hope that helps

@arnelpg Thanks for the reply. I now have it as below but still getting the same error. I also tried late binding but still same err. Like I said - only getting it with A2013

@Ranman - thanks from what I could Google I noticed there is some change to version from 2013 and up with regards to SingleNode but I couldn't figure out how to fix it. I would appreciate it if you could guide me with some details on how to do it Thanks

selectSingleNode Hi all, I'm getting a "Object variable or with bock variable not set" error in the "If xml_doc.selectSingleNode("//api_result/call_result/result").Text = "True" Then" line for the code below. I'm not getting this in A2003 - only my PC running A2013. I'm referencing to...

Hi all, for what it's worth I;m going to give feedback. It turned out that a few weeks ago the lady with the "3rd PC" went on leave but after a few days decided to work form home. She then called the IT guy and he helped her to setup a VPN connection so she can still work and connect to the...

@marlan - thanks for taking the time to answer. My setup is as you suggest. We currently waiting for the Client's IT dept to create another shared folder for us to test with to see if it resolves the issue.

Hi all, I picked up the following at one of our Clients. They have 3 PC connected to the same Inhouse LAN Server. All 3 PC have the same Front end and all linking to the same BE mdb file on their server On 2 of the PCs, changes made to the data can be seen from either side. But the 3rd PC is...

@ByteMyzer - thanks for the advice. I have way too many menu items to convert them all to vba. Will take me ages. The one item I wanted to grey out for some Users I will block via code before opening the target query Thanks

Hi all, I found some code which is suppose to display all menu items: Dim CB As Commandbar, crl As CommandBarControl Set CB = CommandBars("Menu Bar") For Each crl In CB.Controls Msgbox crl.Caption Next However the code displays the default menu items and not my custom menu which I defined...

Hi there, The code I'm using don't seem to work in WinXP (yes some of my Clients still run XP!) From my Google search it seems like SchTasks was introduced in XP so no reason it should not work. Any ideas why it is not? Thanks

Ahh - so I fixed the problem. I opened the mdb file in A2013 and did a compact and repair and then shipped it back to the PC with A2003 on it and did the same that side. Afterwards I made a MDE file on the A2003 machine and shipped it back to the A2013 machine. Now it works on the A2013 PC as...