Search results

I found my solution: In the criteria section for the queried field, I enter "In (SELECT [CostCenter] FROM tblPosition)". Or in SQL view: "WHERE ((([TablelMasterEmployee File].COSTCENTER_NUM) In (SELECT [CostCenter] FROM tblPosition)))" tblPosition is the table with [CostCenter] being the...

I was hoping to avoid the use of a list box. I will need to use this dynamic list of criteria in multiple query scenarios. I understand the concept of concatonating the list into a string, but I'm stuck on how to make that happen. ~Heather

I have a table called tblPosition that contains a list of cost centers (some cost centers are repeated on this list, so I have also created a crosstab query called qryPositionCostCenter that summarizes the list). I want to use either the table or query list values as criteria within other...

Note to self: turn brain on at beginning of week. Thanks Craig. Everything works perfectly now.

I have played around with the suggested changes (some of which I should have known better). I still cannot get this to work. Now I'm getting empty fields. Could somebody take a look at this (Access 2003) and let me know your thoughts on how I can determine the Remove_Date? Thanks a bunch...

I have a table (All_Dyer_Belt_Transactions) that I am querying. In this table is the [Install_Date] for each the dyer belt location installation. In the query, I am attempting to create a [Remove_Date] field for each dryer belt; this field is should be equal to the next install date at the...

Thanks for the idea Mutdogus. I used the following and it gave me what I wanted (recordset was already sorted in order): Dim dbMaterialTrans As Object Dim rst As Object Dim L_Name As String Set dbMaterialTrans = CurrentDb Set rst =...

I have two tables (one that is linked to an external data source that I have no edit control over [SAP] and another that is hosted within the access database I am working with). The "internal" table is just capturing additional records that are not captured by the "external" table database...

Finally, I found the line of code that I need (after much searching, trial & error, and aggrevation!!!!) Me.subform1ControlName.SourceObject = "subform1 Form Name"

Anybody have any thoughts? I've tried 'Forms![Main Form]!Subform1.Form.Refresh and still no luck

As an FYI, all of the listboxes (3) and subforms (4) are unbound controls.

How do I go about determining child links? I create the MainQuery. CrosstabQuery1 (and 2, 3, and 4) are then created from information in the MainQuery. Subform1 (and 2, 3, and 4) were created based on the CrosstabQuery1 (and 2, 3, and 4) (just simple datasheet forms). And then Subform1 (and...

Thanks to kidrobot for sharing code created in a similar problem. The following code creates a query who's criteria is based on multiple selections from multiple listboxes on a form. Sub CreateAllForms() Dim ctlSource As Control Dim i As Variant Dim intFilterFlag As Integer...

I have 4 subforms, each on its own page in a tab control. The tab control is on a MainForm along with several list boxes. The items selected in the list boxes create the Where criteria for a MainQuery (a select query based on the MainTable). Queried off of the MainQuery are 4 individual...

Me.Detail.BackColor = RGB(255, 0, 0) for red Me.Detail.BackColor = RGB(0, 255, 0) for green

Why not set the subform's "Locked" to true in the properties option and then, on clicking the command button do: Me.subform1.Locked = False

I have a form with list boxes and several subforms. Multiple items can be selected from each list box. Based on the selections from the list boxes, the subforms (based on one main query) display the proper filtered information. The problem is that I need to be able to select multiple items...

I don't want to build the query on the fly. The query is already built. I just want to update the criteria for one field of the query. I need to keep this as simple as possible. I have additional list boxes and subforms on the Main Form that I want to end up doing the same thing with.

I see that it works no problem with a single select. That is what I figured was the problem. Before I found this post, I did build a for next loop to capture the criteria: Private Sub CategoryList_AfterUpdate() Dim ctlSource As Control Dim strCriteria As String Dim intCurrentRow...

Sorry to steal this thread, but this is exactly what I have been looking to do. I have a Main Form with a list box called CategoryList and a subform called UsageSummarysubform. The list box is setup for simple Multi Select, and its values are based on a query called Categories. The subform is...