Search results

Ok, then maybe its just my understanding. I use the .RemoveItem and .Additem to move data up and down the list box and to transfer items between list boxes. AFAIK, I can only use those two methods if the row source type is set to value list and I don't know another way to do this. So the row...

There is actually only two issues that access doesn't recognise. in the sub declaration and

Thanks for the reply :) Unfortunately the listbox row source is a value list and not a query. The list box is populated from a query via the recordedset method but as I need to move rows from one list box to another, this can only be done using a value list. So normal sorting isn't available...

I'm trying to sort a multiple column listbox. The listbox is a value list. I've found some code (listed below) which may work but it was written for Excel and I get compile errors when trying to use the code as I don't think Access recognises MSForms.listbox & the .list property Can anyone...

I've had a play around and still can't get it to work. The only thing I thought of is that as I am in an access form (not programming in VBA) then maybe there is some property of the form I could work with. But so far nothing. I can select the item, I can even move the item to the next list box...

Ok thanks, I will try the code later. But I don't think it is a problem with the list index. The list has over 100 rows but even if I just remove one row somewhere near the top of the list the problem still happens. Also, when I use the row is highlighted no problem. So it looks like it should...

Yes the bound column is 1 but it still doesn't work :confused: EDIT: I can set the iPos to any number but every time I press the down arrow the cursor moved back to the top of the list. What I might try is setting a key press event to select the row index, see if that works. But I shouldn't...

Ok sure, code is below. Just for reference, ListboxA is called lstOpenStrips and ListboxB is lstPriorityList

Thanks for the reply. Unfortunately that does not work. The cursor still jumps to the top of the list on the first press of the down arrow key.

Hi All, I have 2 listboxes (set to value list) which I transfer data between. After I move a record from ListboxA to ListboxB for example, I want to keep the selection on the next record down in ListboxA. This isn't a problem as I can use Me.ListBoxA.Selected(i) = True where (i) is the index...

Thanks to both of you. The record source for the form already has a WHERE clause, but I think you've shown me a way to edit the combo row source when I apply and remove the filter. Thanks!

Hi All, I have a combo box which is used to find and select records in a continuous form. I'm to figure out just how to populate the combo box with records in after a filter has been applied to the form, so the combo box only shows the records being displayed and not all the records. I am...

Ah ok. Thanks for the tip. It all adds up.

The SQL looked fine and worked fine for records that were populated. However...after putting the SQL back into a normal query and playing around with it, I noticed it changed the SQL to using HAVING and GROUP BY instead of WHERE. strSQL = "SELECT Max(Tbl_ScanResults.EndTimeStamp) AS...

I'm using the DOA.Recordset method to open a recordset based on a SQL statement. (SELECT * FROM ....) I then use 'If Not (rst.EOF and rst.BOF) then' ... to check if the recordset is populated. This normally works fine except when I use some sort of Group by, Max etc. in the SQL statement. In...

Thanak for the help. But the open form already runs a timer even to update charts as well as a few other controls. Hence why I'd open another form. It's just cleaner that way but basically I'm going the in a similar way to your suggestion.

Unfortunately the scanner is set up using a virtual com and not keyboard wedge. So it doesn't emulate a keyboard. There is an ondata event triggered by an activex control I use to listen to the virtual com port. Once the event is triggered it starts some code to check and manipulate the data...

Lol, sounds an interesting rabbit hole! I might join you when I get some time. Thanks for the link.

Thanks for your post and link. I do have one form open but I already use it's on timer event for something else. I suppose I could make it shorter and have a duel purpose I suppose. But opening another form in the background which is hidden seems better to me. I've not come across doevents...

Hi and thanks for the reply. Yes I think you may be right from what I've read so far. I think I have a way around it by exiting the code, opening up a hidden form and setting a timer event. But it's messy and I have to hold all the variables and re-hash my code so I am jump back in at the point...