Search results for query: *

Thanks. Multi-select listboxes were the most feasible option for my form. I'm try to create multiple records by 'multiplying' the # of Sizes selected by the # of Colours selected by the # of Destinations. eg. 10 Sizes(listCtl) x 3 Colors(listCtl) x 4 Destinations(tabCtl, each Dstn has...

Anyone know how to scroll a listbox control to the row index of the 'first' selected value?? For example, a listbox with 200 items, displays 8 items at any one time (scrollbar down side): Selected items at (say) row# 99, 140, 150, and 155. I do not want to display row index# 0 thru 7, but...

Anyone know how to scroll a list control to the row index of the 'first' selected value?? For example, a list with 200 items: Selected items at row# 99, 140, 150, 155 rowIdx = 99 ' item to scroll to ctlListName.Selected(rowIdx) = True ' some code here to ' force ctlListName to scroll down '...

Ed: Don't really need you to state the obvious now, do we? I do give credit where its due, but Ive been too busy with this problem, amongst others.

Roy: Nice commentary on ADO/DAO. cheers L.

Rolliee: Can't be doing that 'Exit Sub' for the reasons I originally posted here, and latterly for my further explanation to Ed. Nevertheless, I've come up with a workaround. The rs.MoveLast: rs.MoveFirst is not required at all, in the context of your example. I don't know enough about Access...

Ed: Exit Sub won't do - that would escape from the rest of the conditional tab tests. This procedure is for each tab so If tab1 ... do the proc elseif tab2 ... do the proc elseif tab3 .... and so on Rolliee: Your suggestion is welcome but the original error trap with Movefirst: movelast is not...

I have a form with a tab control (each tab reprsenting a country) and two lists: Size and Colour. When the user selects size and colour combinations, the selected size and colour list ids are populated to their respective temp tables. The temp values are later recalled when the user clicks a...

Thanks will try that. And YES (... must ... get ... cofffeeee) I did a search. It's just a shame some of the subject lines are so obscure, the search engine ends up some anonymous looking posts. cheers L.

I have a problem with the behaviour of the OnClick event in a tab control. I'm not familiar with tab controls at all - this is the first one I've used. The main problem I encounter is that I can't get the OnClick event to function on the visible "tab" portion of the control? Am i...

Har-de-har-har I've sussed out a workaround. L.

Does anyone know how to make Access think it needs to perform an OnCurrent event, without any user intervention? L.

Thanks. I lurve it when the best solutions are the simplest!! strFullNumber = "+" & cstr(clng(IntSTD)) & "-" & cstr(clng(AreaSTD)) & "-" & cstr(clng(Number)) thanks L.

I wondered if there was a shortcut to this problem. I started writing a function to do this but I've lost my way a bit... I believe there must be an easier way!! I have three text fields: IntSTD - max length 3 AreaSTD - max length 4 Number - max length 8 Together they would form an...

Thanks gol. I used the Me reference in front of your code, on the subform and it worked fine. If Me.Form.Recordset.RecordCount = 0 Then ... End If

Sorry gol, that dont seem to work. Got the error message about the "object not being in the collection", which kinda was my original problem with the mainform. Something to do with the availability of the objects as event load up. hmmm. L. [ponder]!?

I've checked the Forms() collection in the form_open and form_load events and the subform is not even there. (The subform must load at a later stage...) Guess that's why I can't do a recordcount! Anyone got a workaround for subform recordcounts at the mainform loading stage?? L.

I have a kind of general question on recordcounts. The situation is my main form: Company has a subform: Contacts. In a global variable I am passing the company ID, so that the mainform will load with the company details as well as any associated contacts in the subform. In the Form Open event...

Thanks Bob. Works like a charm! L.

I have a continuous form (actually a sub form, but you get the idea). On each record row I want to put an Edit button that kicks the user to another form. What I want to do is pass the record ID of the row whose Edit button is clicked. Is there an easy way to tie the each Edit button to its...