Search results

Hi, I have a button that current just exports the results of a query into a text file onto the C:\. The output code I'm using now is: DoCmd.TransferText acExportDelim, , "my_query", "C:\results\output.txt", 1 The results of this is a table that looks like: 1234 1569 1478 1524 I'm trying to...

I don't believe that it's the model. I think it really just has to do with the visible field displayed in the combo box vs the field captured and the fact that the combo box's row source is potentially different on each record.

Well sort of. In the sample you can see the two fixture types: - E1 - G1 Of the 73 selectable items (from qry_maxkey2), it breaks out as: - E1 = 24 possible choices - G1 = 49 possible choices Depending on the type of each record, the combo box list changes to the appropriate group. Each...

It's more of the 2nd, the type of fixtures within a building. It's giving a place to select what goes into each of the fixtures but restricted that list due to its type.

Attached is a very stripped down version of the file. You'll notice there are two forms in there: frm_wrong: this form replicates the problem I'm trying to overcome. In the third column is a ListKey. As you click on records with different keys, the fourth column will update & only show...

That's what I'm thinking, but here's the curious part. The query has - DBKey (PK) - POG_ID - POG_Name - List Key (not shown) When I do: - bound column = 1 - width = 1";1";4" I see the DBKey repeating properly on every row on the row. When I do (and this how I want it to be) - bound column =...

By tinking, I've found the problem & I had a hunch this was it. The query being to populate the combo box is made up of four fields: - POG_ID - POG_Name - DBKey (PK) - List Key The old way I was doing it bound the table back to column 1 (POG_ID). Due to some design changes, it needs to be...

The parameter in the query essentially says: ListKey = Form(List Key) So that when On Current hits & refreshes the query, the combo box selection is always right. I'm just stumped on why the value is vanishing when a record with a different list key is selected. The one change I did make...

Unfortunately I don't think so. The list for the combo box is bouncing off a table of 400+ records. And the list changes often so I want to keep as it a live query so its always right.

In my form, I have a combo box tied to a field in my table. The combo box is set to allow certain values based on the results of a query. The values allow for each record are different depending on another field in the table (let's call this the List Key). In order for this to work properly...

The form pulls in multiple records into its detail section. For each record, a combo box is used to select other data. Unfortunately, the "list" available to each record via the combo box and is driven by the On Current refresh. I've tried putting this line just about everywhere else (before...

In a particular updating subroutine that is based off a form's recordset, its getting really slowed down due to having: Private Sub Form_Current() Me.cb_pogdbkey.Requery End Sub Is there a way to disable the on current event, run my sub & then re-enable it?

Turns out I was pointing to the wrong table in the dcount formula. Got it mixed up bouncing from various versions of the file. Nevermind!

The recordsource of the form is a query that pulls up the available locations & selected pog_id's for a particular branch. The rowsource of the pog_id combobox is a query that pulls up the available pog_id's that can be selected. Its based off a query because due to a few different types of...

The pog_id combo is bound to the pog_id in the table. On the same note, the list of pog_id that show up in the combo is restricted to certain id's based on the location. In the table, the PK is a combination of branch + location. It seems like with the same id selected 3 times, it shouldn't...

Let me try again. The form is opened based on a branch selection & the selected branch number is shown in the form header. In the detail of the form, combo boxes are used to select pog_id's. I'm trying to use dcount to count the number of time each selected id is chosen. I've attached a...

Hi, I currently have form that based on a branch number (in the header), the detail pulls in a series of pog's. I'm looking for a way to use dcount to check for any duplicates. I've tried using: =DCount("POG_ID","tbl_POG","POG_ID = '" & Forms!qry_load_branch!pog_id & "'") ..but each line...

From another board, someone linked to this code in an older post. After modifying & testing it, it looks like it works. Any issues with going this route rather than the MS route? SELECT CategoryID , UnitsInStock FROM Products as x WHERE UnitsInStock in ( SELECT top 3 UnitsInStock...

In a table I have: - Category (A, B, C) - Family (A1, A2, A3, B1, B2, etc) - Item - Sales I'm looking for a way to get the top 10 items in each category + family based on sales (ie: top 10 in A-A1, then A-A2, then A-A3, etc). When I try using the top function, it doesn't treat each...

Resolved This is the route I went, works perfectly. Thanks!