Recent content by vShaneCurtis

When I come into a forum looking for help I also spend some time looking around at other people's posts and offer assistance where I can.

I stated my issue VERY clearly from the start Gents. I needed a code snippet/function to deal with a subscript out of range error caused by an unallocated array. I don't know how I could be more clear. I am not a newbie I have three college degrees in the field and I've been doing this stuff...

Minty, Your the only Padawan I see. I asked if anyone had a code snippet that handles an unallocated array subscript our of range error. Instead you blocks want me to check variables and every other thing. I know what the problem with the code is and I asked for assistance in solving that...

The problem with my code is not because of an undeclared variable, it is because the array is unallocated and I'm attempting to add an element to the array which you can't do. I was hoping that someone here had a code snippet that could determine if an array was unallocated. Instead I got...

thanks for the help or lack thereof. Not wasting my time here. Cheers

Mark, Thanks for the reply. I understand what you are saying, but in this case it will not solve anything as the code I am using is a simple stop gap measure. I had found a function that works but lost it when my DB got corrupted. I am looking for a code snippet that will basically do what...

Thanks for the reply. When a variable is not defined Access does not give you an error number. It simply tells you that it's not defined. I get error 9 subscript out of range. In this case Access shows the error number and the message. I have temporarily fixed the problem with a redim...

Hi Guys, I'm having a bit of a problem and could use some help. I am using an empty array in conjunction with a for each loop to store files names in a directory. The names in the array will then be used for further processing. As expected I am getting error 9 subscript out of range. I...

Hello All, I am hoping you may be able to help me with a code streamling issue. I am creating a card database. My main table has three OLE Object fields that will be used to store the card images as BLOBs. There are three images of each card. A large image a medium sized image and a thumbnail...