Search results

Thanks RuralGuy, It was ascii 13. Working now! DubaiDave

I am importing a form field from Word which looks like this: 1/ Houses 2/ Trees 3/ Peanuts Once in the textbox it looks like this: 1/Houses(Little Square)2/ Trees(Little Square)3/ Peanuts. I have tried replacing the CR charactesr as follows: Haystack =...

Thanks Ben, I am a newbie and thought that I could display any column and not that it had to be in the first query column. Having moved it, it works fine. Thanks DubaiDave

Hello, I have a combo box with RowSource set to 'Table/Query'. The query has five fields, one of which is a concatination of two of the other query fields. eg Field 1 PersonID Field 2 David Field 3 Smith Field 4 = [David] & " " & [Smith] (David Smith) Column count is 4 Column widths is...

Mr B, Thanks for the tips. Explicit added and option turned on. Have also read that help note which clears things up. Cheers DubaiDave

Mr B, The problem was down to me. Once I saw your example, the answer was obvious... I had not declared the variables at the top (I guess this must preserve them outside of the Sub). Dim strSelectedValues As String Dim strEachVal As String Dim varItem, varLastItem After having done...

Mr B, I am a newbie VBA programmer, but it would seem that the routine relies upon strSelectedValues to contain a list of the selected items and if strEachVal is not in that string then it is deletd. But this string is empty (it is set in the second half of the code) - surely the contents...

Hello Mr B, I changed the multiselect property from extended to simple, but the behaviour has not changed. How does it behave in your application. Are all selections cleared or just the las one made? DubaiDave

Mr B, Thank you for your quick reply. I must be doing something wrong then because if I select more than three, then all selections are being cleared, not just the last one (i.e. leaving me with no items selected). I have cut and pasted your code and so it must be something to do in the...

Mr B, I am using this code. Reading your comments, it would seem that the intent is to unselect the last item selected (i.e. the fourth) leaving you with the first three selected once again. However, actual behaviour is to unselect all selected items once more than three items are...

Mr B, Just the ticket. Thank you very much. DubaiDave

I would like to limit the number of selections a User may make in a Listbox to say 3. Is there a way? Could not find anything on Google or a search here. Cheers DubaiDave

Hi Lagbolt, The subform property AllowAdditions already set as 'No'. Main form was set as 'Yes'..but setting to 'No' caused a blank form But I see where you are going with this.. I will experiment further. DubaiDave

Hi, Have been trawling the forums, but have had no luck.. I am using a combo with a filter to populate a subform. When I use a filter that retruns no records, the subform automatically enters a 'new record state' (Me.NewRecord = True). This causes some buttons on my form to wrongly...

Hi Bob, I have set all the sub from fields to Tab Stop 'No'. Would setting the tab order on the main form just affect the main from and not the subfrom? Dave

I have been playing around, and the setting (go to end of field) does work for the main from (you can see it highlighted in my jpg above - first field in red box). When I change the setting to start, it acts on the first field in the red box. It does not remove the grey highlight in the...

Hi MissIngLinq, I thought I had fixed this but the problem is back! I have set the access options as you mentioned (it sets for all forms yes?)- Keyboard / Behaviour/Go to end of field. Any ideas? David

BINGO!! Thanks MissIngLinq. David

Hi missinglinq, I have tried your suggestion ( there are three choices: entire, start and end) but it had no effect. David

The original posting resulted in an error, but still ended up on the forum. I did try to delete it. Sorry Dave