I'm using a Treeview control for the first time. I found some code to load
the control. It works but all it does is load the control. One problem is
that it does not display the '+' for any root node that has children. It does
do it for lower level nodes. Any idea how to fix ...

Hello, Im sure this has been asked several times but Im having trouble
figuring this out. I have eight check boxes and one of them has to be checked
before the form is closed. I have used the included code for two boxes in the
unload event on another form and it works great but ...

I have two different questions, but all related to the same continuous form.
1 - I'm creating a database that tracks pending orders (orders not yet
billed) as well as completed orders (orders billed).  I want to create a
form that calculates both the pending orders separate from ...

Trying to populate a second combo box in a Form based on the user data input
into the first combo box in the same form.  
The all combo boxes are bound to text fields.  The statement I’m using is:
SELECT DISTINCT [SubCategory] FROM tblSubCat WHERE

In MS Access 97, I've initiated a shell command to launch an external
application.  
E.g. Shell(run_string, vbMinimizedNoFocus)
Is there a way to set Access to wait for the application to finish?

Error 2113 on a ComboBox -  wrong data type for control
I have a form with an unbound combobox that displays a list of projects
(text key field).  Based on one of two option buttons selected, I switch the
projects list to a list of internal orders (number key field).  The combobox ...

If I have an unbound combo box  with a Rowsource
that includes an "autonumberd" ID field, AND, I want
to update one of the other fields in current row, how
do I go about doing that?

Access03/WinXP
I have a form with a combo box (cboMemberYear) with a data source of SELECT
MYear, Type, StartDate, EndDate FROM tblMembershipYears.  "Type" is a field
from the table and is a list box with values

I am using ADO and I need to get the record count for a subform within a
main form.  I see lots of appends using the recordset clone when using DAO
but recordset clone is not supported under ADO.  Does anyone know how I can
do this?  Thanks,

I am fairly new to VBA programming.... I need help with a function
which calculates days based on a 5 day work calendar. The cut off time
is Friday 07:00 PM EST to Sunday 07:00 PM EST.
Example:

I have a bibliographic database that stores book information. My client would
like to add a new table to the database that stores individual authors. One
book can have many authors.
At this stage, I'm thinking of having an Authors dialog box the users can

I have a Client Database on a Laptop which has a Macro to link to the Master
Database on a server.
A table is created in the Client Database only if it can connect to the
Master Database. I want the Macro to exit (StopMacro) if the Table doesnt

Is there a way I can keep the status bar enabled in my program, but remove
if for a few select forms?  I need it most of the time, but one a couple of
forms I want to hide some of the information that shows in it.
Thanks,

I have a main form that has a combobox, and a subform with many textboxes.  
Depending which selection I make from the combobox, its AfterUpdate event
code disables several of the subform's textboxes.   What frequently happens
when I use the combobox is that I get error 2164: "You ...

On my main form I have a print button that generates a report based on the
data on my form. However if the user makes a change to the data and then hits
print the change is not reflect until he closes the form and then open it
again. So I added the DoCmd.Save to the Print button. ...