I'm amending the contents of a bound subform after the user changes a
selection in a combo box on the parent form.  This means invoking
recordsetclone, looping through it and performing the required updates.
In order to see the newly updated form I Refresh it but this causes a Write

I'm a novice at VBA. I have a table with 2 fields, "Category" & "
"Amount". Using a form, I want to find all of the instances of an
entry in "category" (ex,"Groceries") and total the "Amount".
I'm not sure if I should use "While...Wend", Do While...Loop, or a Sql

I recently made an update utility, i.e. another mde that is shell to if an
update is detected.
On one pc however Access rather rudely complains:
(first in Dutch and then I will more or less translate...)

once upon a time I read that the communication with the back end would be
faster if one table there was kept open.
For that purpose you were supposed to make an otherwise useless table in the
back end, link to it and open it when opening the front end, keeping it open

I'd like to click on a control in a crosstab query, say Col 4, Row 3, and
have the On Click event open a report showing the underlying data making up
that summed # in Col 4, Row 3.
Is this a complicated thing to do or relatively easy?

Help!  I'm a relative novice (compared to all of you!) re Macros and VBA.
I'm trying to track commissions earned from the sale of insurance products.
When someone pays an annual premium, my commission is earned immediately and
can be allocated to a particular month.  But when ...

I have created a database application that uses a macro, activated by a
button click event, that runs a query which returns a recordset
consisting of a subset of the matching database record, and displays the
data within a form.  The query on the table produces a recordset based

I know how to export whole tables as follows...
<elsnipo>
  'Export This Table
   strTable = "tblthis"

I have spent more time than I am willing to admit trying to figure
this out...
I'm trying to use a form to manage the criteria in a query.  This one
query feeds to numerous other append queries as part of a monthly

I have a table (tblStatus) with three fields (CustomerID, StatusType
and StatusDate). I use an unbound form with three text boxes to enter
data into the table when a command button (cmdSave) is clicked.
CustomerID, StatusType are values that are manually entered by the

Using A2003
My db has main form [frmStakeholders] with stakeholderID & other main
details.
When there are a number of detail subform records it often requires

Two questions ............
1.  Can VBA be used to create the procedures in a dll file?
2.  Can anyone give me recommendations for free downlaodable tools for
compiling a dll file?

Hi I am attempting to build a small pasture management database in my
spare time to improve grazing decisions on the family dairy farm.
I have a table that stores a list of the farms paddocks and their
related data. I have a table that records farmwalks which are done

I wanted to turn this...
SELECT [AddnlOwnrFName] & " " & [AddnlOwnrLName] AS Recipient,
"Additional Owner" AS Position
FROM tblVehicleJobs INNER JOIN tblAddnlOwnrs ON

I have a table with the following fields; Zip, City and State. I want to be
able to select a Zip code in a combo box on a form. On click, it should fill
the text boxes with corresponding City and State. Can someone help please?