Recent content by Ingeneeus

Thanks, snueberg -- I will give this a try when I get back into the office. I'll leave the thread open for now and post what I find out for the benefit of future viewers. Have a good weekend!

Sadly, no joy with the DLookUP, even with the added brackets. I will try the subform route. Thanks again!

Thanks, sneuberg! I will give that a try later this afternoon if I get a chance.

Thanks, sneuberg You're probably right. I was hoping to do it nice and neat on the same form and avoid adding yet ANOTHER (sub)form to my database. Still open to suggestions if anyone has any ideas on how to do this without the subform :)

I'm sure the answer to the question above is yes. I just can't seem to make it work. I've got a form titled Line-Item PO Search. On this form are a couple of fields in which the user can input the following information: CustomerID, PO#, Start Date, and End Date. These fields serve as the...

Hi, Gasman -- That's exactly what I did; it's a trick I use often ;) I was more than a little surprised when it didn't work. It eventually led me down the rabbit hole of "late binding" and having to define the constant for "xlTop" I think this may be the first time I've ever actually...

I figured it out! Huzzah! For anyone else in this situation, here's what I was missing: Const xlTp As Long = -4160 xlObj.ActiveSheet.Rows("2:20").VerticalAlignment = xlTpIt appears to be working like a charm. :)

Hi -- I've been banging my head up against this all morning. I feel like I'm really close to cracking it, but just can't get the last step. I've managed to cobble together the code below. It exports the results of my query to an Excel workbook and plants it on my desktop. So far, so good...

OK, update. I'm afraid I couldn't get MarkK's code to work for me. I got an "object not supported" (or something like that) error when I placed the me.CmdClearFlag.visible = Forms.[View Orders].lblFlag.visibleline in the Form's On Current event. I will guess that I missed something. I had...

Thanks, MarkK -- I did not know that (obviously :) ). That's just much cleaner. Thanks for the tip! ~Gene

Hi, Galaxiom -- Thanks for your reply; I had a feeling my idea wasn't going to work, but I thought I'd throw it out there. It occurs to me now that I've been over-complicating this. All I need to do in the On Current event is determine whether the warning flag is visible in the form, and then...

Hello, all. I think I already know the answer, but I really want someone to tell me I'm wrong ;) Here is my issue. I've placed a command button on an insanely complicated form named View Orders. The command button, which we'll call CmdClearFlag for our purposes, clears (hides) a warning flag...

Hi, sneuberg Thanks for your willingness to keep helping! I'm afraid I'm not able to upload my database. Not only is it ginormous, but it also contains customer info and I don't feel comfortable putting that up here. If I could figure out how to put up a stripped down, "redacted" version, I...

Got it! Evidently, DoCmd.RunCommand acCmdCopy won't copy a trailing hard return as such. I'm guessing because there's actually nothing in the next line. It just copies out to the end of the text. So I tried Me.HiddenControl = Left(StringPart, Len(StringPart) - 1) & vbNewLine & "."which got...

Hi, JHB. Sadly, that doesn't do it. After a bit of research, I also tried & Chr(10) & Chr(13), since I had seen something that indicated I needed both. That didn't produce the intended results either. I'm starting to think the issue might be occurring when we Do.Cmd.RunCommand acCmdCopy...