I'd like a maketable query listing ClientID, and E-mail from another
table. This is simple, BUT I'd only like to get only the part after @
in the E-mail.
How would this work in MS Access 2003?

In a form I'm trying to make a search field to be able to quickly find a
record on ID-number. User enters a number and presses enter to move to that
record. How do I trap for the enter-keystroke and where should I put the
code?

Most suggestions on this topic recommend to use a page footer and make
it visible only on the last page. My problem is that the footer is half
of the height of a page which means the detail would show on only the
top half of each page with whitepace at the bottom of each page.

Just want you all to know (just in case you have this issue) that some
standard sql doesnt work by default in MS ACCESS 2003 anymore (I didnt
know this, not sure if others do or not - and I couldnt find an answer
to my problem anywhere else on the internet)

I tend to code everything.  So I'm trying to set the recordset of a subform
in code and then set the .ControlSource property of each field.
The data is displaying correctly, but the subform isn't allowing me to update
any of the fields or delete or add new records.

I'm using A97 and I'd like to keep about 30 informations concerning the
logged in user, in order to prevent hundreds of DB access per user to
get these informations (mainly rights + email, name, login, ...). So I
would like to load and keep these informations only once. I know I

-if the Subtotal is equal to or less than 25000, multiply subtotal by
12%, if not set to 0
- If the Subtotal is greater than 25000 but less than or equal to
10000, multiply subtotal by 10%, if not set to 0

Dear Access friends,
How can I load a string with his own folder address.
The following code addressed to the system folder of MS programs.
Application.SysCmd(acSysCmdAccessDir)

Can someone give me some advice.
I run a sporting event which involves 55 athletes/runners going around a 400
metre running track for 24 hours.
I need to:

Dear Access friends,
If I install an application on an aliens PC the connection to a model
library in VBA seems to be OK.  But by running there are some problems with
the query instructions Left(), Mid() and Right() and also with Date() and

How would I get a query to calculate hours?
if "Starttime" = 10:00AM
   and
"Quittime" = 04:00PM

I am trying to decide what would be the best program to start a
vacation selection calendar in.  I am in a group of 60 employees and
the current software we have, which I believe is written in PERL, is
going away.  I have been talking to my supervisor about creating a

I am trying to assign an ID number from one table into another table
through forms.  Is it possible to create a command button on a form to
feed a new record with this existing number?
For example,  I have multiple tables each with its own autonumber.

I've imported a very large Excel file into Access and because it needed
to be slightly reformatted in Excel I had to split it into three
separate sheets first.  I then imported the sheets separately into
Access - how do I now re-combine the three into one big table?

Has anyone tried to set a reminder in MS Outlook from with Access? I want
to, when a checkbox is ticked automatically set a reminder in access that
takes information from the current record i.e "Required: <<Current Date>> -
Single Line Diagram for <<Site Name>>