The db I use has code (below) to send an email to an individual, based
on the completion of an action with the record. This many happen for
one record at a time, or 25 records at a time, some sequential, some
not.

I have a main form and a subform.
The subform contains several records wich have the field Date.
Using a combobox that groups the dates, I intend to filter , in the
subform,only this or that date, so I can see only the records wich have the

I am new to VB and Access reports.
Is it correct to say that VB and Access have the same report engine or
method?
After I do all the dragging and dropping, is there a way to see the

Why doesn't this code work:
-------------------------code snippet-----------------
Dim categorysource As String
categorysource = "SELECT [KSTUDY_KSTUDY].[KSTUDY_ID],

I have a table that provides all the details necessary for the line
items of the report.
I would like to use some other information in the header of the
report.  This information, like getting the invoice number for this

Just a general question here re VBA.
Can anyone explain the differences between "!" and "." when refering to a control?
eg Me!TxtBox and Me.TxtBox.
What is difference between "+" and "&" when working with strings.

I'm trying to create a change log for database
I get a runtime error 438 while tying to get the type of a bound
combo-box (table/query) control.
How am I supposed to get the type. It even works for other combobox

I need a way to programatically change the width of a textbox to display all
the data knowing the font, font size and number of characters. Does any oone
know of a reference somewhere ot a way to determine the width in twips for
say Times New Roman 12, 35 characters or say Arial 11, ...

I am having trouble creating a query that ouputs each of the children
associated with a parent.  Here is a simplification of my tables:
tblParent
Parent_ID

What would be a good way to keep track of how much time a form was opened to
each individual record?
Thanks

I'm not sure whether I'm being silly and its really obvious, or
whether I'm being over-ambitious.
At the end of each month I run a report. A pop up dialog box prompts
for the dates and station ground I want to run the report for. I then

I have an Access 97 database in which I am running an Excel macro through
automation. The macro in Excel is as follows:
Worksheets("Sheet1").Protect Password:="****", DrawingObjects:=True,
Contents:=True, Scenarios:=True

Hi
I have a table with several fields i.e
          Area   OP Num    Date    Reason  Quantity
I query the table to return Date as month, year and week number

I am currently attempting to write some code which will connect to a
seperate db, identify all the objects (table, queries, forms, macros,
modules etc) and create a clone of these objects in the host db.
This is effectively a programmatic method of the 'Import'

Our company is an independent Voice applications solution provider with
number clients using our suite. We have a CT application suite which is
running with Application Server and SQL Server 7 / 2000 as DB Engines
at the back end.