Search results

It works Thanks Wayne, that did it. Totally forgot about those pesky date identifier thingies. Arch

Hi again ... Thanks for your response. I have implemented what you have suggested and am stumped as to why it is not giving me the expected results. Here is my query now: Select * from tblIssueIncident LEFT OUTER JOIN tblIssueUpdate ON...

Hi Wayne, You are right that I do not want to retreive ONLY the ones closed, with an IssueClosedDate within the last week. I want to retreive as follows: A) SiteID = 87 B) StatusID IN (1,3,99) C) StatusID = 2 D) IssueClosed Date within the last week Retrieve IF (A and B) Or (A and C and D)...

Hi, I have the following query that I cannot get to work. Select * from tblIssueIncident LEFT OUTER JOIN tblIssueUpdate ON tblIssueIncident.MyIssueIncidentID=tblIssueUpdate.IssueIncidentID where [tblIssueIncident.SiteID]= 87 AND [tblIssueIncident.StatusID] IN(1 , 2, 99) AND...

Thanks Jon, What you say makes sense, if that was the entire query. The confusion would come when other part of the query potentially conflict with this part of the where clause. For example, in the dynamic query search form the user can select status(es) from a list box. (This is an Issue...

Hi All, I have a dynamic query (below). I would like to add one more criteria to the where clause... but it is a combination of 2 different criteria in one and I'm drawing a blank as to how to do it. How can I add the 2 criteria so that they are not taken individually I want: If StatusID = 2...

Hi All, I have read quite a few threads here as well as some of the online help in Access but I'm still a little confused about grouping and sorting via VBA. I have so far been unsuccessful at making this work on my DB. The part that is particularily confusing is the difference between setting...

I am experiencing problems with the dynamic query and am hoping I can get another set of eyes on this. Or perhaps this is a limitation of Access in which case I could use some fresh ideas. With much help from this forum I have a set of 3 related queries that give me the data I need to fill some...

Thank you so much Jon. You the man! That worked beautifully. I was on the right track but I can see the error of my ways. I'm not quite there though :-) To complicate things I need to Join your Query3 to a dynamic query to acheive my goal. When I try to do that it asks me for...

Yup, that's exactly what I'm saying. It still does not work. Thanks

Hi All, I have an issue that's driving me crazy because logically, to me anyway, this should work... Access 2002 doesn't see it that way :-( My goal is this: I have a parent table (IssueIncident) and a child table (IssueUpdate). I am making a summary type report that should display all issues...

Yes, the code is in the form's error event. That part is definetly working because when I put a MsgBox(err.Number) before the IF statement, that part runs and returns a value of 0 in the Message Box. So, when I think of it, the code is likely fine (albiet obsolete in parts). The question is why...

Hi All, For some reason the following code is not trapped when I get the error message (3201) 'The field 'whatever' cannot contain a Null vaue because the Required property for this field is set to True. Enter a value in this field.' This is my code and it actually works fine in a different...

Got This To Work Hi Again, I spend more time on this and finally found something that works. Thanks anyways... It was complicated to explain. FYI for any future readers that have a similar issue. What I did was to modify my SummaryQuery (which previously simply retreived the latest update)...

Hi All, With help from this site and the Microsoft site I have created a dynamic query that I use as a recordset for a report. However, there is one thing that I have been unsuccessful in doing thus far and would appreciate an expert's opinion :-) To summarize by DB, here are the applicable...

Hello again all, I have a form with a combobox. The combobox has a Not In List event that triggers another form to get info from user and to add a new record (and hence a new item to the list). This works fine. What I would like is to have a dialog box pop up and ask the user if they would...

That Did It! Hey Pat, Good one... that did the trick. Thanks very muchly! Rich - thanks for the response. I had tried it previously to no avail. Still doesn't make a whole lotta sense but as long as it works. And now it does. Arch

More subform weirdness in my DB adventures! Actually I did find an old post with my same problem but there was no resolution posted :-( Here's what I have: I've got a main form with an embedded subform. The subform is being displayed in datasheet view. I would like the subform records to be...

Found it I had a bad query attached to one of my bound comboboxes in my main form and this was the reason my allowedit property was not working. Go figure. It is nothing really related to the problem but little things like that can have bizarro implications. Thanks again Arch

I'll Play With It Yeah, good call. I copied my main form to a new form and removed ALL code behind it and it worked just fine. So something in my code is causing this. I need to take a close look at what is happening in my code. Thanks for pointing me in the right direction. Arch