Search results

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

I actually ran into the problem the very first time I opened the db I downloaded from the discussion thread. I haven't even had a chance to put it into my own db and try it out, let alone mess with controls! Thanks for the advice though, I'll remember that if I get this error again after...

Hi guys, First, I should admit that I am dealing with VB code for the first time, and using a module that is WAY more complicated than I should be allowed to touch. :rolleyes: I just downloaded Kevin S's sample db (A97 version) from here in order to encorperate it into the system I'm...

Hi all, First, I'd like to say thanks to Jon K, Cosmo75, and everyone else who has posted on this topic. All the previous threads about running sums have been very helpful to me. :D I have been trying to use the optimized Running Sum by date from Cosmo75's sample database for Acc97...

solution Alright, it turns out that this error only comes up if I try to use the Link wizard. If I type in the Master/Child fields manually, it works fine, and the report is created successfully with no errors... :p Does anyone have any idea what the problem might be? Why won't Access (97)...

Hi All, I am building a database that has many reports which contain charts. I use the Link Master/Child Fields to link the charts to the main report. I am in the process of making a new report that also contains a chart, but every time I try to link the fields, I get the "Can't build a link...