Search results

It's working great!! And, the data issue was due to a typo.. so, no problem on that.. Thanks everyone!! I hope you all are paid back for this a 1000 times over! Chris

------------------------ Brian! You are too good!! I was just submitting a post and didn't get it out before yours.. Don't let anyone tell you that you are NOT quick enough or have lost a step.. :D Thanks for the help!

Ok.. I've been playing with the DB and have been able to parse out the additional column (BUC_ASC) into two columns (AltSub_Num & AltSub_Name). I added the code for the column input and column outputs as I did before and changed "recordnumber = 1 to recordnumber = 2". When I ran it, I started...

Thanks, Brian, that makes me feel better that at least the approach was on track.. I used String over Long because that field will contain alphanumeric data. Anyway, you can see the format in the DB I just uploaded. Chris

Ok.. here is some data I threw together really quick.. while it is all fake.. it is in the same format as the real data. I hope it helps.. and, please feel free to let me know if there is anything you may need. Chris

Hi Brain and Alan, I am working on getting a sample DB with some relatively realistic data for you. And, I apologize for not being able to give you a sample of the real data but, it's a confidentiality thing. In the meantime and to clarify, I am getting the data handed to me in an Excel...

First off.. Brian and Alan.. you both ROCK! This is great and you saved me a ton of time and headaches! Like you Brian, I have been scratching my head trying to figure this out. Only difference is you know what you are doing and I don't. :o So.. I've tried the module and it is working. Now, I...

Thanks again Brian.. these are all good suggestions and I will keep working at it. At the moment, I'm thinking about attempting the code option. I'm thinking that a count/loop function on that one field would be good since the amount of plans to one process will vary so much. Now I just have to...

Thanks Brian! I will play around with this and see what I can come up with as well.

Hello.. First off, please know up front that I am NOT a programmer and know enough about VBA to be rather dangerous. So, I truly hope you may be able to help. So, I have an Access database that I am using to combine business processes used with the client plans that use them. The...