Search results

Apologies for bumping this but I still have the issue.. it's incredibly distracting... anyone else experiencing this?

Hi Office 2007 Enterprise SP3 WinXpPro SP3 I have a scrolling issue. Whenever I try to select an object from the Access navigation pane, the pane automatically scrolls further up or down its list with the result that I click the wrong object. I have tried viewing the pane with all 3 options...

Hi Still struggling with this... anyone have any samples/examples please? Thanks.

Hi Bryan Thanks for the reply... sorry, though I didn't explain too well. Rather than in design mode I was looking to permit end-users to be able to resize these two controls (a treeview and listview) at runtime... Windows Explorer-style. Thanks

Hi All Access 2007 .mdb WinXpPro SP3 I've two controls on a form which are adjacent to one another. I'm trying to recreate what happens in Windows Explorer whereby placing the cursor over the centre of the shared border first changes the mouse to East-West and then by permits dragging to...

Ahhh ... found it For anyone else out there... double click the Treeview to get the TreeCtrl properties box.... make sure option for Style is set to 7 (tvwTreelinesPlusMinusPictureText) ..... cheers

Brilliant!.... you are a superstar! ... so was I missing something obvious? Edit ... I've just copied the image control from your version into the treeview I've been developing for a few days and the images do not show? The Treeview does know about the control though cos' if I deliberately...

Hi All Sorry to bump this but I'm still unable to get the icons to display.... any ideas please?

Hi Thanks.... Yes, I gather that's the Access equivalent of MouseOver . i popped some code into that which initially changes the cursor (as above) but it does not seem to fire as one leaves the control? LostFocus will fire but only if the control has been clicked in....

Hi Access 2007 .mdb WinXpPro Sp3 I'm trying to permit user-resizing of a treeview control and adjoining listview.. I want the cursor to change to a N-W or N-S pointer when moving near the border of the treeview and to switch to normal when leaving it. I've cracked the first part by :- Private...

Thanks JBB! I looked on the property sheet for ages... they'd hidden it well...! :-)

Hi Access2007 .mdb WinXpPro I have a form that is not a pop-up or modal, single form, form-view only, auto-center=no, auto-resize=no, fir to screen=no. My Access Options has overlapping windows set. I want to be able to resize the form (as is possible with, say, the design properties sheet in...

Hi The attached is the sample I'm teaching myself Treeview from. If you search the VB module for "nodes.add" you'll see where I'm adding indexes from the imagelist control... I had a horrible feeling that the problem was some obscure needle-in-a-haystack requirement of my Windows XP...

Hi All Access 2007 WinXPPro SP3 I have a treeview control which I'd like to pretty up with icons. I've added an ImageList Control, added .bmp icons into the project's folder, imported the icons into the imaglelist and initialised the imagelist by adding it to the TrreCtrl Properties. The...

Hi I did find one or two good examples but they were a little over-engineered for my needs. But I'm gradually getting my head around TreeViews and, actually, they are not too difficult, if a little labourious.... nothing new there! :) Thanks again for the input.

Hi All I'm most interested to read all this... if gents of your calibre have done/are doing this then I must be going in the right direction...:) BTW in terms of Msys tables, rather then a name string test, I use an attribute check... For Each Tbl_Obj In Db.TableDefs If...

Hiya I hoping to populate a treeview control.... so for example... list all from customers table... check for 'links' to other tables... such as Orders or Employees then list records within those... I'm hoping that using the relationships will cut down the amount of hard-coding of links...

Hi Thanks for the reply. I'd read Allen's tips but couldn't see what I was after. I did find this on the Bytes forum however:- Dim db As DAO.Database Dim rel As DAO.Relation Dim fld As DAO.Field Set db = CurrentDb() For Each rel In db.Relations MsgBox "Table Relationship= " & rel.Name & "...

Hi Access2002/2007 Any idea how I can programmatically read the relationships for a given table? That is to say read the names of the tables it is linked to and whether it is the one or the many in its relationships? I've seen plenty on how to create and delete them e.g...

Ah... sussed it... In main-form button_click event, set focus to the required subform then call RunCommand acCmdRecordsGoToNew Seems to work fine! So many ways to skin a cat! :) thnx