Search results

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...

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...

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...

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...

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...

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...

Hi All, I having a problem that is causing much grief because I can't understand what is happening. I don't get the logic here. I have a form with a subform. The subform is displayed in datasheet view. I want to make the entire form (inc subform) read-only unless a user clicks a button. To...

Hi, I was hoping someone could explain why the following code does not work. Hopefully it is enough to go on. I would like a form, on opening, to run some code if there is an OpenArg value. In the code below me.MyIssueID is the OpenArg. I am trying to populate an unbound control with table...

Hi All, This seems like a really simple thing and that's why I am pulling my hair out because I cannot get it to work. I have a simple form with 4 comboboxes, 3 of them are cascading. All 4 boxes are bound to the same table - no join. And in fact, these are the only 4 fields in the table...

Hi All, I'm having a problem getting my multiple criteria query to work and was hoping someone could shed some light. I have a form with three unbound search fields (Product, Category and Issue Name) and an unbound combobox (Issue ID) that would contain all matching records, based on what's...

Hi All, After reading many threads in this most valuable forum, I tried to set up a combobox in my form to automatically add a value that a user puts. It's not quite working. I have my LimitToList property set to Yes and have added the code below to the NotInList event. However, when I try...

This is really driving me nuts! I have a cascading combobox (2 combos). The first one works fine... let's me choose values from a table in my DB. The second combobox values will depend on what is entered in the first one. I have a query with 3 fields: MyCategoryID - Bound Column CategoryName...

Hi All, Does anyone know if it is possible to change the default location of the navigation buttons on a form? Thanks! Arch

Hello All, I'm having a small yet highly irritating problems and am hoping someone can help :-) I have a form with a subform. When I tab from the main form to the subform the display shifts so that I can no longer see the main form, only the subform. There are workarounds... I can enable...

Hello All, I have a caption on my form that is attached to an option button. I have the form coded so that this caption has it's value depend on a field on the same form. I actually got it to work but if I change the value of the control field that the caption depends on, I would like the...

Hi All, I'm having this problem... hope you can help. Or perhaps this is a known issue with Access (2002). The problems is with 2 comboboxes on a form that I have. The first combobox gets it's values from a table and presents it to me in the dropdown list. Simple enough and this works. The...

Hi All, I have a form in which I am having some trouble achieving my goal of auto populating a date field based on a condition determined by a different field. The condition is stored in a field called 'status' and one of the status' is 'Closed'. If someone selects close I would like the...