Recent content by gray

Yes... working fine now thznks

Hi Thanks for the replies. I tried various nomenclatures for the form/subform/controls which in this case did not turn out to be the problem. Your questions re- the relationship between the form/subform prompted my memory from about a year ago when I put the original form together. The...

Hi I have an unlinked form/subform (i.e. no master/child fields set up). Whenever I try to access any of the subform's resources from the main form in vb code I get an error I have done all the usual: - checked the names of the subform and it's controls, - compacted and repaired, - deleted...

HI That's worked a treat thanks!! I had a feeling I'd need some more commas in there somewhere ! :) Cheers

Hi WinXPPro Sp3 Access 2007 After some research I thought I had found a neat way to SELECT records from a table based on an 'IN' clause and sort them in the same order as the values for the 'IN' clause... i.e. SELECT Unique_No, Table_Name, List_Order FROM My_Table WHERE Table_Name =...

Hi… Sorry for the (very!!) delayed reply…. Thanks for the suggestion… mine was already set to double-click so, in my particular case, it did not resolve the problem….. but thanks for trying to help… cheers

Thanks for pushing me in the right direction… I actually found this handy tip for dealing with comparisons where NULLs might be lurking… in my case I amended my query as follows:- SELECT * FROM Table_A AS Tgt LEFT JOIN Table_B AS Src ON (Src.Col1 = Tgt.Col1 AND Src.Col2 = Tgt.Col2)...

Ah yes, I see..... Thanks... What I am ultimately trying to do is sync my target table (A) with my source table (B).... So I had something like this...... UPDATE Table_A AS Tgt LEFT JOIN Table_B AS Src ON (Src.Col1 = Tgt.Col1 AND Src.Col2 = Tgt.Col2) SET.Tgt.Col3=Src.Col3...

Hi Thanks for the replies.... Sorry CJ, I probably used a bad example there... a better explanation would have been if I had said .... Hmmm... interesting... so if I understand what you are saying the JOIN sometimes might return NULLs in cols3 and 4 where they have "" values? So I guess there...

Hi I am comparing the columns in two tables in a JOIN to see if there are differences. The columns, COL3 and COL4, are "Text" fields. They are declared as: Field Size = 255 Default Value = "" (an empty string) Required = No Allow Zero Length = Yes Indexed = No I use the SQL comparator <>...

Figured this out... so if you too are trying this... 1) Do as above, 2 image lists (1 x small icons, 1 x large icons) 2) Associate listview image lists as: normal=your_large_imagelist_name, small=your_small_imagelist_name 3) Add your list items as: your_lv_name.ListItems.add(, yourKey...

Hi Access 2007 WinXpPro Sp3 I've set up an SP6 Listview. I have two imagelist controls associated with it, one for small icons and one for large; thay are associated using normal = my_imagelist_large small = my_imagelist_small I have added the icons for small and large so that they have the...

Hi Well I think I've resolved the main part of my issue... i.e. clearing the focus highlight down from a Treeview. This can be cleared whenever you deem necessary by simply Dim Tv As Treeview Set Tv=Me.tvTreeView.Object Set Tv.SelectedItem = Nothing Set Tv.DropHighlight = Nothing...

Hi Allied to this problem is an associated ListView. This Listview is populated ith respect to the selected node in the treeview. In this Listview, the first record added becomes the selected item (by default). This is indicated by a grey highlight. Since this could be confusing to the end...

Hi I think when I added mine, I could not find how to add an imagelist to the treeview for love nor money.... I stumbled across the 'extra' properties afforded by the double-click method (as per my footnote) purely by accident.... In fact I still can't see a way to do that from the 'Other' tab...