• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Getting error while trying to pull data
#1
Hello,

I am trying to fetch data for multiple clients. using a query. Since, the list of clients is huge. I am trying to use VBA to pull the data but I am getting this error. This is triggering for recordset which is open. Have added a sample file. 

Can anyone please help. 

[img]data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAWYAAADPCAYAAADGQnuEAAAYUElEQVR4Ae2dvW4budeHdU8BXPhSXKlyveXbpUjh1jcQIGUAYbsg7SLYD+xis8Z2/2Kr3IHvgC8Oh4dzSJGSrNFYZzxPAGNmKH6e89PDn2gH2gT+EQEiQASIgKsIbFzNhskQASJABIhAAMyIgAgQASLgLAKA2VlCmA4RIAJEADCjASJABIiAswgAZmcJYTpEgAgQAcCMBogAESACziIAmJ0lhOkQASJABAAzGiACRIAIOItAAvPXcL/ZhM391+b0/nu8DZvNbXj8L4Tw32O41ftm7Vco/HofNjLf28cgU+r9+3q/Cbdx0qaGtJV1zrIOiWOKkxkyhBRfmXP66YS6aLX3MMuc90ahgAgQgStHwID5NtzeHoJK67VrzH6A3Ai2HgxDCAphM02B9djWvHCR295cqvII2PvQ3gYvMhE6IQJEYMERKMB8f3/bcZj3HSd4jZVXkItutLNp7AFQ2s4JxHpuGp+6vH7WelyJABEgAkH/55+CQq4WXP+Fx+ii9XUJmb2XZ6lTf0Qf6gjoN9pfhGRdr9dej0zq+tLvWHb7+Fg87x/FDHPLDrlw0HYd/TWMJyG2vpjxcR7juGWdUWBVeTGPXl+nzKlVZxyVOyJABJYZgcIxC4SKj/oC03iOa8Fi7wcw7J3jpjPVsVzamCOECOnkcitIDWE8UH9vY7Dz2U+CnI/rPIq12X66c7BOvDeOLbf3di5SbkCum5WtEu9N+6Nz6sV+r1MKiAARWFgE9sAcfymWfqk2gswAwwJt76hAV2/rq/u1TtxsAMlJKzxjD41+23OR2tVYOgW9Sl9xPQKyDmhbc9jrtxpHwJlhq/1WdXQOdV9xPG2TzsLrvo7NKb5exjQPxw0RIAKLjsA+mOPRxG14/KpAk/VZ4Jj7LhxMHWneqDeCdojf8JcfyVUfrF/1XcytlYsE5GI99Zoac9jr14xbzM8C39QpplKXD243HrF0+zoyp6JdMRgPRIAILDwCDTCPDm50sRYs9n4AzFhPo2HrSJk810cZ+25vPHY4VL/Vt3GfOgVzVeiX86z7GRqMczDwjEsQh5zGEbesf6oXAanjt/ssNzbdqI71NS5gnJPtvxf7sR13RIAILDMCbTBH12zBaYFg72XR8jyenw6/aKvrKIy0noJs3ASGYwEzZgReo/6ekzW/PMu/5auSUcBTXzNzLI4lzBxs+b39y5QBisPfUt+H+3xEYvrUYeK1jFEGfHyt05cdO59J1/2X/faWX0yFByJABNxHIIHZ/TyZIBEgAkRgNREAzKtJNQslAkRgKREAzEvJFPMkAkRgNREAzKtJNQslAkRgKREAzEvJFPMkAkRgNREAzKtJNQslAkRgKREAzEvJFPMkAkRgNREAzKtJNQslAkRgKREAzEvJFPMkAkRgNREAzKtJNQslAkRgKREAzEvJFPMkAkRgNRHYPD8/B36IARpAA2jAjwYAMxsTGzMaQAPONACYnSUE1+LHtZALcnEtDQBmwIxbQgNowJkGALOzhFxrh2Zc3CEa8KMBwAyYcUtoAA040wBgdpYQXIsf10IuyMW1NACYATNuCQ2gAWcaAMzOEnKtHZpxcYdowI8GADNgxi2hATTgTAOA2VlCcC1+XAu5IBfX0gBgBsy4JTSABpxpADA7S8i1dmjGxR2iAT8aAMyAGbeEBtCAMw0AZmcJwbX4cS3kglxcSwOAGTDjltAAGnCmAcDsLCHX2qEZF3eIBvxoADCfA+anh3Cz2YbdOW1f0ua1xnnJnKiLu0QDs2ugCeabzSZs8s9NeHi64E4isLl5CE+SXHu/pGQX896FbY7VJmy2u5i0p4cbE8MUz/iard+G+267CRuJUTHOBXOwpFgz19khgFP2995qg1nBqfC8pDt8E7DZha3GaLcN250m9ik83LQ3MoHtzcNTkKvWj/BOINc3R6y33abNy4wDoAAUGliNBo6D+VkcXnJ2NVT1OV0fxOkl96jwUeAMVwHXWOdGARTbb8M2vbbdjfVyP1InO9M2/KIDr+sUc9uGXf2cNx+dV7nWYU1tZ1uuTeBsYmXfRHHu0kf1eppL/PTw/BwE1ALv5ieJ2Edn3XYs7lfz5t3XnxoErkuPzXEw77bDx2oFmDpF+xyhMTrBZ9umBoWFkd5b6EjbTQJQ7ucw0IYkdOrUc6ufIyzHuWcXu1fvkNh1I2kDXN3yPrjHOWco27ja2NkY2XLuATEaeHMaaIM5u8501qmJFzj0wNwqTy5QXfSeG9T+9CrjtO6lzM4p3lcQ7NWx/dX9957lE0LdTmNw8CqgrVxtnJfOdQRxuZko2NW1p6uN6cFxD20avLZ098T816fhNpgVCAVUKmhaqNUQq58tVOxreq9X26e9t6/bvux9r05dfsrz2WB+Ls6Q5Q01umURVwXmei66nl65vs71zTkk4Ls++B7K+WEwCwDi0UJyfAIMPW9WNywQr0FSP1uQ2D60nl6lXvNegDYeN7QX1Klj+6v7j/Mq2xVHGbpB2flX908PW/NXK9KXccwytomXglrPzfNYVZ9FDPS12JfpW8u5Amk08OY0cBzMCuAEnAiTdKxQ/vIu/QmciKSGYSUccZFyvNFsb9vW9/Y4owXNCC9zHHDqplG0M5tQa4xqLcPGNY6p0H1+Ho4n4vFN0WbYCIbjHT3iqNyCXbe2jXMEzO1NuYqfxozrmwPWWvLfBPNaFs86ARoaQAMeNQCYcVW4KjSABpxpADA7S4jH3Zs54SrRwOtqADADZtwSGkADzjQAmJ0lBGfyus6EeBNvjxoAzIAZt4QG0IAzDQBmZwnxuHszJ1wlGnhdDQBmwIxbQgNowJkGALOzhOBMXteZEG/i7VEDgBkw45bQABpwpgHA7CwhHndv5oSrRAOvqwHADJhxS2gADTjTAGB2lhCcyes6E+JNvD1qADADZtwSGkADzjQAmJ0lxOPuzZxwlWjgdTUAmAEzbgkNoAFnGgDMzhKCM3ldZ0K8ibdHDQDm1wKzfiuJXuce95xxzmnz0nXMMcYcfb50XafUn3Oec/Z9ytqoc9FPHV0w26+Qil8D9fB00YGbu5QVl70/N+mX6KM39kv71vp67fV7qfJzxjmnzSnztf3a+1PanlLnUJ+HXjvUd69dr/xQX/ralLbaR+86Z9+9MSmfjYlNMEcoF993N3xP3f731134Y9CSxPXSuWp9vc4t6nPGOafNKeuw/dr7U9qeUmfNfWp85oiB9s11NgA3Derzc2iCufimZ02KJj5et2F70/gCUnktf2Fq+uLQ1O4hfgHr8OWjpRvXLxgdvrx0+JJS80WtMn7Rb/llqUO/w1zGL0JNG0Ya+yl/oWyac7HpjF8e2+yrNXb6otU81+rTRHN9Ohe9HlmXzHlYt35hq8THrL2Oc64/5mXTWWe37zS343Fo5baTgzpW2224uXkIJ48h67I/rXzEeVtNpvnFb3jfhByHoq3qTvq3X5Ar38ZeadHmN8XoqKbinKt+Hx7i2sf4a640x8+h0I7mrzfvotys08aL+1I/C4lHE8zyxoniKRYhItuGXRSDEXUUvwgrva5tVMBJPHvQ1HrSfrsbgqdt5LV8P4hb20fhSv26X+mnnrf2EeuO4t9tx/v4pu/21Rm7mF8FDl2XXnV9di5xnr2+xzjKWrfbbRjWvgvb3M7MX/tNcNE4jfGz8zvS98E4NMbs1rdj2lzqZiPwS3Vy3sa55ZzU+azWWGph1GQs17ZFfBprSBtHno/mLbfrrCWufexvT1OtfnOfndw3++zFpeyjne9q7ro2ru5hfR6YVfQxwSKQm/Cws27ZOIEsRiOSKECtY3Z6W1fv9apiim3TBmHnUdeT+rlsEPFGNhbtx15zvTRHfdar1pVn7aN+TevINdar1qf166u2i22G+e22A2Tim13KdSPSa3bLOsaJ8Xh+Dkf7bsU0zk3H0uvpY455sDlpxLq1Lo2PxrWen5qFVrltc+oadDypb/vcK3+hpuq52L7j3CT3jT5PnXdvvjpvru5hbD8ZNsF8/CjDOmoDZis2FUItmCi00d1037TaTq+2v96bsR6/btsSvvRb19NnvdZjt9oUdRrr077qa9FuAHN0yjt1yOkIY5ecs7bXdnqty+vnVO9FfWsfetWx9FqX18+tenUdfdartmld6zry3NNCvYHWbbX/yeUNmErfrX61TK92DjrfWGb6rOvaNlbvvXpan+vywVx8FDRCib/8qwVQfBQ1H1FVCHX96rkYS15TgeZ6g0j1o2asr87xmDC1j6eHsM3nhAI6A06Zp9bbm3NnbG2jc9V2Wm7mldenY+i197E89bG9uQn6y9anh2080nh4EpdZzmncZaV8XFce187tWN95bpWb7Y3ZrZ/a69hST2PVbdNbl+2rrNPTQi5P6x2cb9l2jNtwnqz6yuV2zroO298xTZ15lLGv0968pbyT797c7Tq4dw3qpmMWcUZxm4+WWbgx6fpxVq7meKB+TQAlZQZU0vcu/iJw6OMm/TJIz7T1taK86DeNV/dbP9s3UXbKacwM6RpAjefW2EnUea5Vf1oe/8xQ16fz06vOL8fYxDHOd3zTPefNz8wvtzNHQVIvlRfxK96E5Ru66NvOTeenuSvikMY8VL8Yc8z53rxsH60xqn7iJprXbrSQy0w8TlmD1jHtVeuaR90gI7TzfAdg5nhXGsh1bb9Hf/nX6bMXl16+Y32rJ7u5cR9zU+vK2XMXzN3JZ2GS4G6MnCV51fOsNzVy49oprlqrRpuA2QQDUbylzVbdp/nkQa6B8kI08HIwL2RhQPYtQZa1oOd1aQAws9HgotAAGnCmAcDsLCE4o3U5I/JNvlsaAMyAGbeEBtCAMw0AZmcJae2elOGq0MC6NACYATNuCQ2gAWcaAMzOEoIzWpczIt/ku6UBwAyYcUtoAA040wBgdpaQ1u5JGa4KDaxLA4AZMOOW0AAacKYBwOwsITijdTkj8k2+WxoAzIAZt4QG0IAzDQBmZwlp7Z6U4arQwLo0AJgBM24JDaABZxoAzM4SgjNalzMi3+S7pQHADJhxS2gADTjTAGB2lpDW7kkZrgoNrEsDgBkw45bQABpwpgHA7CwhOKN1OSPyTb5bGgDMgBm3hAbQgDMNAGZnCWntnpThqtDAujQAmAEzbgkNoAFnGgDMzhKCM1qXMyLf5LulAcAMmHFLaAANONMAYHaWkNbuSRmuCg2sSwOAGTDjltAAGnCmAcDsLCE4o3U5I/JNvlsaAMyAGbeEBtCAMw0AZmcJae2elOGq0MC6NACYATNuCQ2gAWcaAMzOEoIzWpczIt/ku6UBwAyYcUtoAA040wBgdpaQ1u5JGa4KDaxLA4AZMOOW0AAacKYBwOwsITijdTkj8k2+WxoAzIAZt4QG0IAzDQBmZwlp7Z6U4arQwLo0AJgBM24JDaABZxoAzM4SgjNalzMi3+S7pQHADJhxS2gADTjTAGB2lpDW7kkZrgoNrEsDgBkw45bQABpwpgHA7CwhOKN1OSPyTb5bGgDMgBm3hAbQgDMNAGZnCWntnpThqtDAujQAmAEzbgkNoAFnGgDMzhKCM1qXMyLf5LulAcAMmHFLaAANONMAYHaWkNbuSRmuCg2sSwOAGTDjltAAGnCmAcDsLCE4o3U5I/JNvlsaAMyAGbeEBtCAMw0AZmcJae2elOGq0MC6NACYATNuCQ2gAWcaAMzOEoIzWpczIt/ku6UBwAyYcUtoAA040wBgdpaQ1u5JGa4KDaxLA4AZMOOW0AAacKYBwOwsITijdTkj8k2+WxoAzIAZt4QG0IAzDQBmZwlp7Z6U4arQwLo0AJgBM24JDaABZxoAzM4SgjNalzMi3+S7pQHADJhxS2gADTjTAGB2lpDW7kkZrgoNrEsDgBkw45bQABpwpgHA7CwhOKN1OSPyTb5bGgDMgBm3hAbQgDMNAGZnCWntnpThqtDAujQAmAEzbgkNoAFnGgDMzhKCM1qXMyLf5LulAcAMmHFLaAANONMAYHaWkNbuSRmuCg2sSwOAGTDjltAAGnCmAcDsLCE4o3U5I/JNvlsaAMyAGbeEBtCAMw0AZmcJae2elOGq0MC6NACYATNuCQ2gAWcaAMzOEoIzWpczIt/ku6UBwAyYcUtoAA040wBgdpaQ1u5JGa4KDaxLA4AZMOOW0AAacKYBwOwsITijdTkj8k2+WxoAzIAZt4QG0IAzDQBmZwlp7Z6U4arQwLo0AJgBM24JDaABZxoAzM4SgjNalzMi3+S7pQHADJhxS2gADTjTAGB2lpDW7kkZrgoNrEsDgBkw45bQABpwpoEmmH/55ZfAz+EYTHEwP//8c+DncAymxFfabv7vf/wcicGUGKPfw/qV+EyJbxfM379/D/y0YyCb1pSgS9J+/PjBTycGU0UNmE/blNDwfO/BqRoGzGdsQIB5PkHLhjVV1BbMbID7udJPE4B5PzaX0stUDQNmwOzOuU8VNWA+DBzAfDg+l4DzVA0DZsAMmDtHKpd4g3rsAzAD5jd5Ts1RxrzCnuo2cMyH8wOYD8fnEpvpVA3jmHHMfcf87X149+59+PbKjnKqqN2A+UrxOwaWNw1mJzGfquF5wPzlY/jw4cP48/HLec752+fw+Pg5fBN42vszYHrJvzBZjGMWkW42YVP8vAvvv53oGK4k8qmingXMjVjefToSxyvF782AuRW/Vpk1Dsdet3VnvJ+q4YuD+dvnx/Dhw8fwxcDzy8fy+WRIOoKxnfOiwDzF8V5J5FNFPRuYbSwlNptNOAjnK8UPML/+p7w65lM1fGEwfwufHx/D52/tv/+Nrjc76QTrBN/PH0eH/fGLtJe+xrLHjx8H99yrX0PcPst9HvfA/MxmYkFc3y8ezAkY7+9GN50Bk4CTXbaF0YwOwwp7qqhfBcwSCwveIm7pU0l8/S7cvdM423IDj24/m7CZIf6LOcqwcVHt2TK5z58Gq9jGejb2RzZR7f9C16kaviyYIwB77vhL+PjhQxig+z1EZy1HHAmaWv5djkFaxxcK2l59fV3hmp9lXDOnXN7ZPLT9geuiwJyFm+Agb/Qk6AzjT3cJAJ/CnXWB9k1wIcFaAPfup4r61cD8Q+J1Fz7lazra0LjFOI9HR9/evxvirK9rTPPz68R/UWCu9SvPcbPS2DdinjU+xv6HaDzm6sjxk+Zk4nWqhi8PZoVqDbYaiPIswGyVax/2Nb3Xq/avz3ptlWe3rA7cgFrrv+C6KDC3HFcGQUfUKsq6npbPfJ0q6lcHs8RpDyB34VMdv1ivU64wsfmq218o7osCs42HrF9jEmOpn0T0amKr9XLMBOQG1Ll8HlBP1fBlwfxd3GnnqKAFztcCs4L+BfCtjy/sM2CeR8zqoKeK+tXArG9+vdZv9rpcnsW1tcoFQPmTS7Vh1v1OfH4zYK6hLXHR2Oo1x2rVYE5HFPbo4Pv3MPzy78BRhgWnBbjca19arleFrD7but/TPGK/5bgWsOfev1kwx4/ko6vIH72zuOcF8rLAbI8d7L2JUQWHGM+7TwM8zMfqMc4VPKr2Gp+p1zcB5qjVxrmxxkyvqt1609Pyma5TzcWFHfNwbjv8ZYYeG3wIH/TP5SI8tbz85V/8kziBrYI2gfdL+qVg/cu/Vn07bq6vfdrjDLsRKOBfcF0UmPc+Yr8L7z9Vf59sRRzP4oaPhu/u7vg7Zn3jSoyKWI4bWARl/bq4uVZZ6i/COPVXxNnEP/4CtuUKdU5nXt8GmJM7tjnRmOvVvmY2wqkb2yntXYL5XCe6lHaLAfOZb9xThDdnnaminuUo4xqxFEiLw77w2IsB85R1W7MxpZ8z207V8CyOeSmAPXeegNl8XD9TuIdgM1XUSwbzJ/MnjHP9FQFgnle/ou2pGgbMLzjCUJAD5nmFPVXUSwbzoQ3rUq+tAswzGIaXxH+qhgEzYL74R+WXCLhVd6qoAfPhjRMwH45PS5MvLZuqYcAMmN80mBVCXPe/1UQ2sHN/BDwvhdWa6s8GZvm4zk8/BucKWtpJ0vg5HIMp8ZW2gHgfxHVMpsQY/R7W7yxgnpIw2p7vQogdsUMDaEA00DzKQByIAw2gATRwPQ0A5gnnbAj3esIl9sT+LWsAMAPms38B9JbfGKwN8F9TA4AZMANmNIAGnGkAMDtLyDV3acbGJaIBHxoAzIAZt4QG0IAzDQBmZwnBsfhwLOSBPFxTA4AZMOOW0AAacKYBwOwsIdfcpRkbl4gGfGgAMANm3BIaQAPONLD56aefAj/EAA2gATTgRwObv/76K/z555/hjz/+CL///nv47bffwq+//soPMUADaAANzKQB4azwVrgr/BUO//333+Gff/4J//77b/h/4YYNjdj8TJkAAAAASUVORK5CYII=[/img]

Thank you,
Rinku Sharma
  Reply


Related Topics
Topic Author Replies Views Last Post
  Error Handling showing error Sanjeev Gupta 2 2,011 28-May-2018, 12:31 AM
Last Post: sanj_edu
  Mail showing error Sanjeev Gupta 3 2,252 29-Apr-2018, 06:52 PM
Last Post: Vivekananda Sinha
  Formula Error in VBA code Sujeet Singh 1 1,608 23-Apr-2018, 05:46 PM
Last Post: Vivekananda Sinha
  User Form date format error Parmeshwar Maddheshiya 1 1,632 17-Jan-2018, 11:18 AM
Last Post: Vivekananda Sinha
  Error Handling Showing error as excel found unreadable content Gurpreet Singh 1 1,754 06-Dec-2017, 06:51 PM
Last Post: Vivekananda Sinha
  Error Handling showing Error Sanjeev Gupta 1 1,711 23-Nov-2017, 09:17 PM
Last Post: Lovedeep sharma
  Error Handling How to Solve Error " Can't find project or library Mohit Sharma 1 1,926 27-Oct-2017, 10:23 AM
Last Post: Vivekananda Sinha

Forum Jump:


Users browsing this topic: 1 Guest(s)