Search results

Folks, thanks for your input. Got me moving in the right direction. You can see the fruits of my labor in another post here at this form if you're interested: http://www.access-programmers.co.uk/forums/showpost.php?p=1209092&postcount=32 Thanks again. Now for my next big challenge which I may...

Okay, so this is for anyone else who ever must face this headache for any reason and who actually wants to accomplish something viable in doing so. Note that the name of my multiple-select Listbox is "Submissions". The name of the table I get the titles from is [Poems], a query for which is...

I think I'm making progress, folks. Just putting nothing inside ListBoxName_Enter seems to do the trick, letting me manage the behavior I want for Enter in ListBoxName_KeyDown or KeyUp. You know? It is extremely difficult to get Access 2007 forms to behave exactly the way you want them to. :D

Oh wait, never mind, there seems to also be an ListBoxControlName_Enter routine I can play with. I'll report back if I manage to get things working the way I want.

I can catch and change the behavior of the Space bar just fine, but the Enter key seems to be a special case that has some inner workings associated with it that just can't be bypassed. I've tried various evaluations under KeyDown, KeyUp and KeyPress, and combinations of the same, but the...

Hi Folks, I want to control the behavior for pressing the Space bar or the Enter key in multi-select ListBox. Is it possible to do this? For instance, the default behavior for pressing the space bar is to select/deselect the item currently in focus. I want to move this behavior to the...

I'm beginning to see light at the end of this long dark tunnel: Public Function MoveTo() Dim TitleData As ADODB.Recordset Dim SubLookup As Variant Set TitleData = CurrentProject.Connection.Execute("SELECT [Poems].[ID], [Poems].[Title] FROM Poems ORDER BY [Title];") SubLookup =...

Okay, it worked, but because of MS's tendency to create random and unpredictable restrictions, I can't actually iterate through the SubmissionLookup Listbox when it's invisible. It has to be in focus. So it's kind of weird, slow, and flickery. But, I'm supposing I could create an items...

Maybe I can create a non-multi-select field that's invisible and use it in a way similar to the way the invisible text box is used. I'll explore this idea later, actually. Somehow I think this idea has merit. Yeah iterate through the non-multi-select ListBox while setting the index for the...

Alright, good to know. However, if the idea is to be able to jump around in the list box by typing in a few characters to get to the next selection, this kind of defeats the purposes if all you can look at are already selected items. :-/ It seems like MS has created a lot of unnecessary...

They all return Null. 0, 1, 2, 3, 4, 5, 6, 7, 10, 1000. Always Null. I think "2" was just the last one I tried. I stepped through the For loop about 30 cycles, too, changing the column index to see if I could find the one that wouldn't return Null. :-/ No luck. :banghead: I've been feeling like...

It's a ListBox in its present configuration, made to hopefully work with the code I've shared. Here it is: SELECT [Poems].[ID], [Poems].[Title], [Poems].[Year Completed], [Poems].[Blog Location] FROM Poems ORDER BY [Title]; I'm creating this database largely as an exercise to help me get to...

From what I can tell, the search utility you're sample creates wouldn't work with a multi-select ListBox. Or would it? Would it let me type in the a portion of the text in a given search field so that it would show up in the listbox as a multiple-select item with a checkbox next to it, let me...

Needless to say, I'm merely in the testing phase right now. I added a case for the arrow keys to let me navigate up and down the list entries without triggering the rest of the code. I added a case for the Esc key to use for resetting the field quickly and easily. This code actually works. The...

Well I just used "ListBoxName" to indicate the name of the control. But, it's actually called "Submission". Not sure if this makes a difference though. Here's the code I've got: Public Function GetLetter(KeyCode As Integer) As String Dim isLetter As String 'If shift = 0 Then KeyCode =...

This looks like a great solution, which I've tried to implement. But for me, in Access 2007, Me.ListboxName.Column(1) always returns Null. Actually I want .Column(2), but any column returns Null. I can't figure out why. :banghead: