Recent content by feathers212

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