I am setting up emailing for an all Access contact management app and
DO NOT want to use Outlook.
Aspemail.dll (aspemail.com) works fine, but...
Unless you pay the licence fee for the premium features, you cannot

I'm just getting around to using pivot tables and charts.  I find the
Pivot table interface to be INCREDIBLY frustrating.
When I view a table in Design view, then choose Pivot table view, I
get the PivotTable Field list, from which I can choose to add fields

I was wondering if anybody could help me with 2 questions.
1) I am making a simple form that will display only some of the fields
of my db. I want there to be a button next to each field
that when clicked shows the complete info for the record in a pop up

Hi I have a survey to build on access 97 with 21 questons all of which
have a intial form being displayed with a yes/ no response option,
then depending on the answer go to another form to give more
information , ask another 5 / 6  fields worth of information both memo

I frequently find myself wanting to use class abstraction in VB/VBA code, and
frankly, with the tacked-on class support in VB/VBA, there are some problems
with trying to do that and have any type-safety as well.  I thought I would
share some of what I've come to think about this ...

I have a problem with my SQL-Statement:
SELECT *
FROM [Excel Export Query]
WHERE (((Year > 2003) And (Month <= 6)) Or (Year = 2003))

I am pretty new at this so please bare with me.
I have a page working perfectly but I just want to ad a column that will
show the time it was entered into the database. I think all I need is the
syntax for writing the server time to the TimeStamp field in the record. I

I need to fill a table with values.  The table has about 6000 records
but the records will not have the same value in this field.  I thought
I had figured out a way to do this easily but it is giving me an
error.

On a form I give information on produced invoices, sorted by date. Now
I want to have the user be able to choose a range based on the
dat-field. So I make two textboxes (FromDate and ToDate) and have the
user enter a range of dates in these within the dates given in the

Hello ppl:
I am facing a problem that I ahve never experienced before with the
secured database. I created an MS Access 2000 application (.mdb) using
MS Access 2002 and secured it using exactly the procedure described in

I want to Count the number of members in my database that have specific
criteria, such as Blue eyes, or Brown hair. I have fields named Hair and
Eyes, and others ofcourse, but I just want my VBA code to count the
number with the specified value, ie Blue Eyes, and assign it to a

I have an Access table with hyperlinks to a VB module.  Is there a way
to pass variables from the hyperlink clicked to the VB module.
Thanks for any Help
Michael Monk

I have a query on one large table. I only add one condition, i.e. a
date (the SQL reads like 'where date > parameterdate'.
This query is rather quick if 'parameterdate' is either explicitly
written into the query or if it is a 'normal' access parameter value

Hi, Access officionados,
I'm new here, so please cut me slack/gently tell me off if I'm out of line
or in the wrong place.
OK, here's something that seems silly (and is also problematic to me).

Hello, hope somebody here can help me... I have a query that lists
defects recorded in a user defined date range. That query is then used
as the source for a Cross Tab query that cross-tabs count of defect
type by calendar month. Defect types are stored in one table, defect