Search results

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 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 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 <>...

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 Access 2007 SP3 WinXPPro SP3 A Treeview's focus and selected item are not always one and the same. This is because the Expand/Collapse symbol can be clicked whilst leaving the focus on another node in the tree. What I would like to do in these circumstances is to "clear" the focus from the...

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 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...

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...

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 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 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...

Hi I want my users to use a custom 'New Record' button. Consequently, I have allowadditions set to false on the form. Note that my form is opened in it's own workspace so that SQL transactions can be used My custom button calls Frm_WrkDAO.BeginTrans DoCmd.GoToRecord , , acNewRec...

Hi Access2002/2007 WinXPPro SP3 I've a form with a tab control and 4 or 5 tabs. Each tab has a subform on it which is populated as its tab is clicked. This causes quite a lot of screen flicker as scroll bars and the like set themselves up. Just wondered if anyone could advise the best...

Hi Access 2002/2007 WinXPPro SP3 OK, OK, I give up... how do I get the extended ASCII character 192 as the caption in a label control.... or even displayed in a textbox please... I'm sure I could have cracked the Enigma code with pencil and paper for all the time I've spent on this... :) Thanks

Hi Access2002/2007 .mdb WinXpPro SP3 I know this is a popular question because I've read quite a lot on it but each time I think I've cracked it yet another failure comes along. I run the following tests in the Current Event of a Main Form (in this case after a filter has been applied) to...

Hi Really sorry to need your help again so soon.... I am utterly befuddled by the syntax and order of actions here!.... I am trying to open a bound form in its own workspace so I can later use Transactions. Every example I've seen has a peice of the puzzle but I just can't quite put it all...

Hi All Access2002/Access2007 WinXPPro SP3 Here's an interesting one. I have an unlinked Main and Subform; Master/Child Links can't be used because they are wrapped in SQL transactions. To replicate those links, the mainForm Current event reloads the subform with a new SQL recordsource (SELECT...

Hi I'm just about to begin adding some more complex filters into an ADO RS based form (subform actually) and I have an architecture question please. In the main-form open event, I build an SQL String, apply it to an ADO RS.Open, open the subform with the RS. I then use filters in the main-form...

Hi Access 2007 .mdb file - Split FE/BE Can anyone tell me the correct (reliable) sequence for the opening of mainform/subforms?I have been plagued by problems for months. My Forms as ADODB RS based. As we know, opening a main form automatically fires the opening of the subforms first. In...

Hi Access 2002 BE / 2007 FE .mdb files I've a form which I populate with an ADODB RS... I add filters to the RS as in:- Dim Where_Str As String Where_Str = "xxxx yyyyy" etc With me.form.recordset .filter = adFilterNone .filter = Where_Str set me.form.recordset =...