I'm sending a email via Access 2000 and don't have a problem with the
basic format.  What I want it to automatically grab the email of the
tech and insert it in the TO.  I have a combo box which lists the
techs name and in a seperate field has the email addresses.  I also

Hi - On a data entry screen with misc. input boxes, such as for Name,
Telephone Number, etc., when tabing down the input screen, Access will
highlight whole contents in that box.  Sometimes I'd like to be able
to jump to the end or the beginning of that input box to start typing

Hi Guru's,
   I am trying to disable certain command buttons based on a users security
level using the Dlookup function. However, I must be missing something as
the results are not what I expect.

I have a process that is currently in 4 separate steps that are operated by
individual buttons on a form in Access.
In Access:
Button 1. Select the csv file to open (filename gets stored in text box)

My computer is using the dd/mm/yyyy date format. Is there a simple
input mask for a date field that will accept just the month and year
eg. 08/04 and maybe default the day to 01?  I presume that Access
would need a full date to be able to store it.

I've been teaching myself VBA but I'm wondering if it's more worthwhile to
be learning VB.NET instead?  I'm learning the VBA to help me with
programming my Access database but I've read some articles recently which
basically imply that VBA is on its way out.   Is it worth my time to ...

Anyone know of a RECENTLY written, well proven SMTP engine module for
VBA code for Access 2K apps?  I've tried Ostrosoft.  It's OK but I'd
like to see some others that are reasonably priced and supported.
Any help would be much appreciated.

Is there a 3rd party utility out there which can convert plain ol' SQL to JetSQL?
Thanks,
amy
===

Is there any way how create an expression in query which is
corresponding to rankings (meaning in second row expression would be 2)?
Is there anything what can identify in query next field. I mean if query
returns 3 values John,Peter and Richard in a row with John another field

I have a student table with studentid as pk and an enrolment date field as
date.
I have made a qry to group on date and count the number of enrolments for a
particular day.

I have an app written in Access 2000.  In that app I have a form with
a button that allows the user to transfer the current record from one
table to another table.  This procedure works perfectly when run under
Access 2000 or 2002.  However, in Access 2003 it croaks with an SQL

This all centers around an Access Data Project
I have a stored procedure that aggregates events stored in a table
based on intervals I specify. I have a form that supplies parameters
for the stored procedure. My procedure creates a temp table to

Can I add/code a button on my form that will print only the selected record?
Thanks
Grant Dayton

I work for an architecture firm, and am setting up a
database to track hours worked on various projects.  
The three first tables are fairly simple.  Each
project has many employees, and each employee works on

I was wondering what the acceptable naming procedure is for a text box on a
subform when using VBA.  I have always used.
[Forms]![frmMainform]![frmSubform]![TextBox].
Why I asks is that this has let me down lately in Access 2003 and I seem to