Recent content by nuke_girl

That sure feels good! Mod, Thanks so much!! It now all works perfectly. And I think I actually learned something in the process (which is always a nice bonus!) Thanks again, ~ N ~

It didn't work. :( I created the code as you suggested, but modified it so I have two different SQL statements for my two separate subforms. When I select a location from my combo box, I get a compile error ("Method or data member not found"). It seems to have a problem with the first...

I know this is an old thread, but I think it's along the lines of what I'm trying to do. I have a form to track users currently signed on to the system based on their log in time and lack of (null) log out time. This is the only way to track if they are in or not due to the nature of our...

Thanks, Mod! Do you think that it would still work if I set up two strings (eg. strSQL1 and strSQL2) so I could have different record sources for my two subforms? Both are dependant on the same combo box, but contain different data.

Hi everyone, I've put together bits of things that I've been working on learning from this site and created a form that almost works. The user selects a location, or "---All Locations---" from a combo box (used AddAllToList to add All). This is supposed to update two subforms on the form. I...

Wayne, I wish you could see the little dance I just did around my office. Ok, so I didn't really dance, but I wanted to! :D That worked PERFECTLY!!! I had actually thought of doing that. I don't know why I didn't try it. :confused: THANK YOU SO MUCH!!!!!!! This has been driving me nuts...

I am trying to create a list box in a form from which you can either select multiple criteria or, if it is left blank, select the whole list. I got help from Mile here to build the code: Option Compare Database Option Explicit Private Sub OK_Click() On Error GoTo Err_OK_Click...

It appears that my problem is in the datatype needed for the "For Each" control variable is either Variant or Object, but the list box data is text, and is being used as criteria in a text field of a query. So when the code runs, it places, for example, In(2, 4, 7300) where I need it to be...

Thanks, Rich. That's exactly what I needed.

Hi All, I seem to remember reading another thread about this problem once, but I can't find it now, so if someone knows where it is, could you direct me to the right place? My problem is that I have a grouped report with a group header and subreports/charts in the detail section, and each...

Almost there... I think? Hi again Mile, I've got the code working for the first part of the If...Else (when no selection is made), and it's FANTASTIC! However, when I try to run the query with one or more selections, I get the error: "This expression is typed incorrectly, or it is too complex...

That looks like it'll probably help... when I can make the error messages go away! But I'm off now for the weekend, so I'll take a look at it again on Monday and let you know if it's what I need. Thanks, Mile. ~ N ~

Hi guys, First, Jay, thanks for posting this code (eventhough it was quite a while ago!). I'm pretty sure it's exactly what I'm looking for. The report I've built pulls a "Group Code" from a combo-box in a form and creates the report based on that single Group. I've been asked to change it...

Hi Everyone, I was just asked by my supervisor about the possibility of live tracking of action within the Oracle database that we pull our data from. Our system involves employees logging in, at which time a new record is created in our access history data table with a blank field instead of...

Thanks Rich! Worked like a charm. :p