Search results

If anyone wants to test this out to verify its a true bug it would be helpful: Create a tab control. Place a treeview control (with checkboxes = Yes) on one of the pages. Populate the treeview. Check some boxes. Move to the next page of the tab control. Return to the page with the treeview...

Hi all, I used the MS KB example to add Drag-and-Drop functionality to a treeview control that I have. It works pretty slick. But (and there always seems to be a but), when I drag a node to a different location the Index property doesn't change. Quick Example...

I'm not sure if anyone has come across this but here goes: I'm creating a custom shortcut menu in which I'd like to maintain some of the filter functionality that comes with the standard Access shortcut menu. The customize menu window allows me options for "Filter By Selection", "Filter...

Access 12 will have a "split" window view where by the user sees both a datasheet view and single form view simultaneously (see attached picture). Has anyone ventured to create a similar beast in Access 2003? I'm running into great difficulty updating one view as the other is editted.

The users of this forum are, in general, a really bright group. It seems only fitting that there should be a category in the forum called "Access Wish List" whereby users can post ideas that they would like to see within future versions of Access. Even if the posts do not strike the ear of...

Is this more tab control problems? Many may have seen my post about the improper rendering of the tab control in Access 2003 with Windows XP SP2. Now I seem to have run across another "error". ControlTipText only works on controls listed on the topmost tab of a tab control. You can set the...

I haven't seen this problem defined in the forum so I'm going to throw it out there... I'm using Access 2003 on Windows XP Home. When I create a tab control the background color is a subtle blend. The top of the working area of the tab control is the same color as the tabs and then the body...

Not sure if this is a "duh" question, but I can't find an answer in the archives: How can you hilite the record selector from code (as if the user clicked on the record selector himself/herself)? Thanks for any help, Jeff

I'd like to have a shortcut key (Ctrl+O) for my custom menu. I can functionally achieve this by creating a macro "AutoKeys". What I can't do is have the caption of the menuitem have a right justified "Ctrl-O" appear. The Access Help file says you cannot assign shortcut key text to a custom...

I just wasted 3 hours of precious sleep only to discover the OrderByOn property!!! I must have gone through every macination of object.Requery, DoCmd.Requery, and SetFocus on my form and subform only find that there is an OrderByOn property!!! Now why would Bill ever think that if I go to the...

I have a database of contacts (tblContacts). One of the fields is fldZipCode. I have a database of zip codes that contain fields fldZipCode (pk), fldCity, and fldState. I'd like to create an updateable query (to be used by a form) that joins the Contact information and City/State. The...

I can't find the answer to this simple question in the archives: I have a listbox based on a "value list" (for example): Red Green Purple How do I change the second item to read "Yellow": Red Yellow Purple Thanks for any help, Jeff

Question about parameters in a querydef Pat Hartman has stated that it is more efficient to use a querydef than dynamic SQL. I've read over his post of HowJetHandlesQueriesAgainstODBCDatasources.doc, but I have questions. I have a form "frmCustomer" and I have a querydef "qryCustomer" based...

I couldn't find an answer to this in the archives, but it seems fairly straight-foward to me: How can I use a field value as criteria? Example: Let's say I want a select query to return all records where the person's first name is the same as the person's last name. In a querydef, the...

Does anybody understand the vbMsgBoxSetForeground parameter in the MsgBox function? MSAccess help says: "VbMsgBoxSetForeground: Specifies the message box window as the foreground window" But isn't the MsgBox always the foreground window? Thanks, Jeff

I get an error, "The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing MyDatabase from saving the data in the field.", when I run the following code: Private Sub txtHeight_BeforeUpdate(Cancel as Integer) If Instr(1,txtHeight.Text,"in") then...

I have a query that returns a list of appointments. Some of the appointments are listed twice because of a one-to-many relationship in one of the associated fields. If I try to loop through the query results to delete the duplicated appointments, I get an errror "Insufficient key column...

How can I get the name of the option group that a particular control belongs to? Example: Option Group Name = grpChoices A control's name within the option group = chkDaily Is there some syntax to obtain the name of the option group given the control's name? Like ...

FYI- Many of you may have noticed that you cannot SetFocus to a control within an "option group" -- you will get the following error: "Run-Time Error '2110': Microsoft Access can't move the focus to the control xxx" Your work-around is to SetFocus to the Option Group and not one particular...

I'm merging about 10 strings from a form to a number of different Microsoft Word templates. The problem is that a particular template may not need all 10 strings and therefore doesn't have all 10 bookmarks. I get an unexpected error if a particular bookmark doesn't exist. My code looks like...