I have a text box on the form that i set to run off of a macro. The macro
runs a query that takes the sum of an attribute called meeting_actcost from
the meeting table where the employee_department matches whats put in the
prompt.

I posted a question on 7/1/05 In the Access Import/Export Data group. One of
the three suggestions from a very kind person named John was to "write VBA
code to read the text file line by line, assemble records, and append them to
a table." But I am looking for example of such ...

I have written the following code (I am new at this so bear with me Please).
Basically I want to first Close the form "Bibliotheca" and then reopen it
showing the record that it was on before it closed. When I run it it tells me
"Mismatch", the field BookID is a number field so I ...

I have a field on a subform showing a prikey.  I want another field on the
form that uses that prikey to lookup a name from a query.
I have this set to the name's data source:
= DLookup("[Name]", "Qry_FamilyMember_Attendance_select", "[RFS_ID_NO] = "

I hope someone can help me.  I need to create a text box on a for
that will display a running 30-day average of a field.   How would
code this so that each day the maximum number of days it use t
calculate the average is 30.    :?

I been trying to used a  FORM Called ' FMainTD' "BeforeUpate" and
"AfterUpdate" feature to keep a history of record changes in the table. In
the Table
Table TD

I have a form in an Access database. When I click on a button I want to open
a particular form in a (different) particular Access Database. Is this
possible with some VBA code?
Thanks in advance,

How do you set the grouping level for a report through code?  I want the user
to be able to choose the field they want the report to be grouped by
Thanks
Ian

I have a function that calculates time, with the function result displayed on
a report.
The report is bound to a Query and this all works fine.
What I want to know is, is it better to run the function from the report or

I want to automate some functions of my current jobs role. I run multiple
apps/windows, some of which are 3270 or 5240 emulators. I need to read/submit
commands using sendkeys or alternate method prefer without requiring focus
for action to perform. This is similar to the screen ...

How do I make a macro or some other function that allows user to choose any
row from a database which is then automatically cut & pasted to another
pre-speficied table (which acts kinda like an archive)?

Hi, I receive a run time error 91 (object variable or with block not set) on
the openrecordset line of the following code, can anyone correct it for me
please? I am trying to step through a recordset to ensure the user is not
trying to book a duplicate activity. It is called from ...

I'd like to add a "search box" to my form that allows for searching the
table of names and addresses by one of the fields I've created (lastname & "
" & firstname) to see if the person is in the table.
I need to be sure that what appears in the search box does not in any way

I use a command button on a subform to add a record to the query suppoting
the parent form.
I don't see that new record unless I requery the parent form.  But that
brings me back to the first record.  How do I get back to the record I just

I am using VBA to insert a new record in a table that has an autonumber as
the primary key. After the insert, I do dlookup on the table to retrieve the
primary key of the newly inserted record so that I can add it to a relation
table. However, the issue I am having is that when I ...