Recent content by ctpoodle

Thank you so much plog! Yes, that is so much more efficient! :D Interestingly, I'm still having issues with the same ones I was having issues with before but now that tells me the problem lies somewhere other than the code here. Thank you so much for your help! :)

Sorry! Forgot about the code tags! I haven't used Select Case statements but I'll look into them. Thanks.

Some of my code is working but the bottom several ElseIfs are not. Is there a limit to the number of ElseIfs you can use? Here is the code. Thanks in advance for any advice. I'm not a pro as you can see. Function mcr_Produce_Issue_Escalation_Template_Templates1() On Error GoTo...

No worries. I think I've got it. Thanks for letting me talk it out.

Yes I do. That's why I was thinking I'd be able to do some kind of a lookup. However, if I need to do a bunch of If/then/else lines, then I'll just do that.

The form itself is driven by data selections. If A is selected then 1, 2, and 3 are auto-populated with certain data. One of those auto-populated is the RESOLVER field. We have approximately 100 Resolvers, not all of which will get their own report. Each report, while pulling in some of the same...

I feel like my brain is just going in circles and I can't figure this one out.:banghead: I have one form, Issue Escalation Screen, which has some data pulled from a previous table and some new data input. A key input field is RESOLVER. When a button (TEMPLATE) is pushed on this screen, a query...

This is awesome! Thank you! I'll try to figure it out! Thanks so much!!

I went back and tested just having the queries send in .xlsx (Excel 2013) format. Just that simple change worked! The only reason I can think of that I had problems before is that our whole company JUST switched over to Windows 7 and Office 2013 and we were having some glitches company-wide. I...

I'm running a couple of tests now and will keep you posted! Thank you so much for your help!

Frothingslosh you are awesome for going above and beyond and counting the number of visible characters! That is very interesting and definitely presents some food for thought. As for my results with Office 2013 vs your results, I'm not sure why I got something different, but I will definitely...

Thank you for responding The_Doc_Man. I did try just exporting from Access into Excel and was successful in keeping all the characters, as long as it was a 97-2003 format. Anything newer than that, and it doesn't.

I am working with a database that's been in use for years (pre-dates me). This is a multi-user database in which the user updates (among other things) a "Comments" field on an invoice in question, which is a memo field to allow for as much room as possible, and for multiple comments over time...

Thanks gblack! It seemed counter-intuitive to me as well but it worked! I had been having the issue of having my memo box cut off when exported to Word and it was driving me nuts! Thank you! This did the trick!

Thank you so so much! I knew I had done something stupid! I looked at this so many times and just did not see that! You are the best!!!:)