Recent content by BCNicki

Found the error in my code. I dropped the 's' in the array name in part of my code! My eyes are getting too tired for this. Time to pack it in for the day. Thanks for your help!

I've added the () so now my statement is correct. I can't believe I missed that! I am now getting "Run-time error '9': Subscript out of range" when I try to use: for i = 1 to UBound(arrWebIds) in the function where I am trying to call the values out of the array from.

Hi SOS, I've added this to a Standard Module - not a form, report or otherwise. Thanks for asking.

I'm reposting above with the missing details. Sorry I somehow hit Post before I was done typing. I've created an array that I created and declared as a Public array in my module. I created a function that populates the array so that I can use the values in another function. I've gotten the...

I've created an array that I created and declared as a Public array in my module. I created a function that populates the array so that I can use the values in another function. I've gotten the array to populate but when I go to use the values in the array in another function, the array appears...

Hi All! I've been working with MS Access since version 1.0! I've seen a lot of changes and hope to keep working in Access and developing my skills as things change and evolve and hope to find better ways of doing things, new features to take advantage of, etc. I've been working on version...