Could any one help me figure out how to make my treeview control
(tvwReviewers) to scroll when I drag an item near the bottom of the control?  
I have tried many of the samples on the web and can't seem to convert them
just right.

In my access 2003 i have a call to my sql server
and use ado
but when i run my access 2003 on my vista
i get a Class error

dears
how to insert an excel worksheet on access form and get the excel
functionalitys

I visit the newsgroups of Office Solutions Development often.   I have been
trying to view the threads particularly Access and Excel, but I don't see
them anymore.  
I am just doing what I used to do by just entering keyword in search and

I'm looking for help on the problem:
I hae a table with a date field. howere the data source only supply the
month and year with the following format 12008(Jan. 2008).
I would like to run a comparison on the date field however I don't know how

I have a form with a subform on it and it’s link to a combo box for
locations, when I pick a new location name from my combo box the subform
index pointer stays in the last place it was at. I would like to set the
index on the subform to go to the first record when a new name is ...

Hi:  
I have this code, below wherein I am attempting to delete, then re-add a
series of records in one table, based upon an "input" table record set.  At
the line noted, below, I get an error:  Item cannot be found in the

This may be already answered somewhere but the search function on this
webpage isn't working properly today.
I have a form that is used to add new records to a few different tables.
Everything works fine, except when you go to add a new record and enter the

I'm trying to take a table that has two fields (Apart Unit Amenity +
Comments) and join them as a memo field.  There may be several lines per
record so here is my question.
How can I change the data from:

I have two records in a table in two seperate fields
Table 1
                      Record
Field 1             123456

open a Recordset based on the table and loop through its
Fields collection.
I got this answer after i asked a question yesterday. can anyone help me
open a record set bassed on the table and is it possable to open it based on

I have a main form which pulls down data based on the form it was open from.
What I want it to do is to look at a field it has just updated, and
depending on its result, either make AllowEdits = false or true (and a couple
of others).

Please help.
I created a template database to use for summary survey questions.
In the data entry form, I have 10 questions
EX:

Hi!  I am making my first foray into arrays and am running into a problem.
WHen I run this code, I am getting an error:  Runtime Error 9, subscript out
of range (I have noted the point where DEBUG is pointing to the error.  Is
the problem my user defined datatype?  Do I have to ...

if in Access 2007 "acCmdLinkedTableManager" opens dialog box of Linked Table
Manager, then what closes it?