I am designing a database that tracks usage of corporate jets for personal
use.  This is considered income to the employees that use the company planes
for personal use.  The IRS has come up with a formula that hits the
employee's W-2 as income when they fly personally.  The part of ...

Is there a way to specify a "From" email in Access?  I want to send this from
a specific mailbox.  I am using Outlook that does not support seperate
identities.  
This is the code I'm currently using.

I have a table with too many fields and im wondering what some of your ideas
are. I am tracking employee training and there is a field for enrollment
date, completion date, comments, etc. The problem is that there are over 20
classes. So i have fields setup like this and i know ...

I am setting up a database that will track the awards that personnel are
awarded.  The relationships will be many to many I think?  I want to see how
many awards each person has.  The awards table will have approximately 140
awards.  Another twist is that some of the awards are ...

The value you entered isn't valid for this field.
You may have entered text in a numeric field...
The table I am drawing the list from is a single list of alpha numeric ( 123
ad) values .

I am new to Access and working to create an automated way for our service
reps to track their calls.  Can someone take a look and provide some feedback?
CUSTOMERS TABLE
Customer ID (primary key)

Can anybody help?
I have been upgrading an old payroll system in Access now that we have
Office 2007. The original system that I inherited calculated the Notes and
coin requirements with manual input for each employee, a long and tedious

I "inherited" a database, and the person who created it turned a feature off
that I need to turn back on. When you click on a combo box, a message appears
saying "This feature is disabled until after the grace period" I think she
used a macro. If I delete the macro will it break ...

I am designing a database for a client to track budget data.  The labor data
is entered by FTEs (Full Time Equivalent Employees) and the dollars are
calculated by multiplying the appropriate labor rate by FTEs.  The labor rate
is based on job role, fiscal year, and month.  The ...

I need to do a simple match query in my database and I have not been able to
figure out how to do it.
I have:
Column a

I am trying to build a database that will serve as an inventory dbase for
Investments.  The main events taking place will be buys and sells of the
securities.  The part i am having trouble with are the Tax Lots.  Since the
FIFO (first in First out) Method of inventory will be ...

I've put fields in a new table that ZI've created to start a database
tracking biopsy slides for a doctors office...the first field must be a
unique number in order to track the slides and i want every number to begin
with the last 2 digits of current year..for exemple the first ...

I need to hold an inquiry to sick persons.
I have:
T_QuestionsGroups: IdGroup (with a primary key) and NameGroup fields;
T_Questions: IdQuestion (with primary key) Question and IdGroup.

Hi Damian,
When I run this function I get an error saying "This action requires an
Object Name Argument".  Is it ignoring the "acQuery" ?

I have a timesheet that is an excel workbook, it contains graphics and data
that needs to stay in the format to be printed out. I have a few input areas
that I record the employee, days, times, week ending, etc. I want to use
access for my employees and customers, I would like to ...