Search results for query: *

The dropdown is a form control.

Many thanks for your help. The identification of a cell shape works well using the intersect method. I have now got a single drop down using a query to populate the data set in a seperate worksheet, and link this to the dropdown. One small problem is the control of the index line in the...

Thanks Skip. The spreadsheet that I have is used for project pricing. Materials are contained in a second sheet which is populated from a Sage accounting application using odbc link. The drop downs allow many materials to be selected and the pricing sheet has code to calculate line values when...

I have a worksheet with about 120 dropdown boxes.Is there vba code which I can use to identify that the current cell contains a dropdown box?

Thanks for your reply. The contents of this forum are very large and I do not appear to find the answer to my problem! Could I please ask you to dirct me to a specific item in the forum or advise the correct key words that I should use. Many thanks.

I have a worksheet with about 120 dropdown boxes. Is there vba code which I can use to identify that the current cell contains a dropdown box?

Using office 2007 for Word and Access. Tested query in MS Access which is working OK. Have set up an odbc link to the access database. Tried to set up the mailmerge in Word 2007 using blank document. On MAILINGS tab have used 'Select recipients', 'use existing list'. Presented with form 'Select...

Thanks Elvis72. Problem is that I cannot find the FORMAT menu to click on! Can you please point me in the right direction.

Using Access 2007 I have created a main for with 2 subforms using the form wizard. On the main form the fields as text boxes are grouped as a column. Can anyone tell me which property allows these text boxes to be un-grouped?

Thanks PH. the code now works correctly.

Simple main form and sub-form where a total of a field on the subform is displayed on the main form. This calculation and display works perfectly for inserting new rows or changing a field value on the sub-form. This is done using 'on dirty' vb code to requery the subform data and a simple...