Report forms have a running sum property for calculating a running sum of a
total field.  I took a stab at writting my own RunSum procedure for a form
but just shows the total all the way down the form.  This form is connected
to a Query with a one to many relationship of Stock ...

Quick question. If I declare a recordset variable (Dim rst As
DAO.Recordset), but due to the conditional logic of the code don’t actually
set it to a recordset (e.g. Set rst = CurrentDb.OpenRecordset(SQL), does the
recordset variable contribute to bloat? Should it be released ...

A2003
I have people who loose track of how long they are on a call.  
1) They would like to have a timer on the form showing how long it has been
since the user pressed the DialButton - counting up the min:sec would be

I have a field OLE Object.  Using VB, how do I insert a link to an existing
Word doc? My database cycles through a folder and inserts the document name
and filepath into their respective fields, but I don't know the sytax for
inserting a link.

I have a subform. When there is no data, I can make the
subform.visibale=false, but that leave an ugly blank area on the form. How
can I hide it?
Also on the sub form, I have trouble make it looks right. I have used third

============
The Short Version:
============
Input Field 1 has a value of X.  I would like Input Field 2 to automatically

I am trying to do a count query on multiple check boxes that have been
checked.  In a SUM query, the result is a negative number and I cannot used
that.
Ok, this SQL Statement works fine:

I have a combo box double click event that's giving me fits:
Private Sub SupplierID_DblClick(Cancel As Integer)
If IsNull(Me!SupplierID) Then
               ' no supplier ID selected;  show all ...

I have a form where the user enters a new record.  In the form's AfterUpdate
event, I create recordset that retrieves the same record that was added.  The
problem is that the record count is 0 which means it's not being found.
For example:

I am trying to find a way of determining programatically whether a control is
on the page of a tab control or not. I have set a reference to the object,
objControl and started off by trying.
If objControl.Parent.ControlType = acPage Then

Hi;
Using Acc2K & VBA6.0
Have been searching, for quite some time, for the code:
"How to Programmatically Determine installed applications?"

I would like to have dropdown menus that link to an option group, so that
when the option is selected the dropdown becomes active and can then
Print/Preview a report of the info entered.
Any help would be very grateful.

I am using a form in DataSheet view and I am having trouble refreshing the
data after an udate.
I am coding in the Delete event and instead of actually deleting records I
am setting a 'Deleted' cloumn to 'Yes'. The query that the form's data is

I've created a query and included all the fields from two tables, but have
hidden the ones I don't want to see on the form. The form updates the 2nd
table by inserting a new row, but I want it to update a row that's already
there. e.g. Table one contains vehicle details, with the ...

Hi I have a text box on a form and when trying to change the control source
it keeps reverting back.
I need:
=[quotedetails].Form!tqdsell+[quotedetails].Form!Tqdgst