thanks for the help on my question on how to get the employee name to
automatically come up after loging in using the statement that you ave me
below:
EmployeeName = CurrentUser()

I am hitting a brick wall with this problem. I have 3 tables. Table 1
contains last name as primary key along with fields of skill level,mastery
level and other fields. Table 2 contains last name as primary key along with
memo fields. Table 3 contains performance standards along ...

I have two tables, same heading. I need to update the records in one
depending the values on the other.I have an unique ID.
I can´t work it out.
Thanks

Hi. I want to create an input mask for e-mails in order to force people to
insert the @ and the . (dot).
Any one can help me?
Marco Silva.

We make a db in Access but since the db increase the size almost a 2.0 gb is
down, so we need to compact db every 3 days, there is a patch in order to
Access can manage more then 2.0 GB of size ?

Can someone guide me as to how I can write a piece of code which would
enable me to do the following:
1.    Display the name of each table in the MDB.
2.    Count the number of records in each table of the MDB.

I already asked this question yesterday, then thought I had solved it myself,
only to find out that I hadn't.
Bummer.
I have 3 tables - Activity, Questions and Answers.

I'm sure I've seen this option but cannot find it.

I have a "Deliverables" form.  Each deliverable has a command button to open
a "Tasks" form (that shows all the tasks for the particular deliverable -
Each task record has the associated deliverable ID number ).  The code for
this command is:

I have an Access 2002 database consisting mostly of linked tables from a SQL
Server 2000 database. I was hoping to import a SQL Server user-defined
function from the SQL database into Access. It's not one of the commonly
requested functions (calculate working days between two ...

Two of us are sharing a MS DB...if we create duplicate queries, she has
the sort option and I do not...my little "AZ-->" and "ZA -->" buttons
are grayed out. Why is this and how can I get the sort to work for me?
I have tried to right click the top of the query window, choose "Apply

Hi, at the moment im using
=DateAdd("d",[Days],[Starthire]) to calculate a date using an ezxisting date
and a number of days, however in the field that this is entered in the
control source of, it doesnt seem to put that date into the table, can anyone

I am trying to set up a simple pto datbase tracking which parent signed up
for which committee then sorting the parents with all the pertinent info by
committee.  example - all those who signed up for fundrasing.  not sure if i
know even how to begin!

I have a situation where I have a master list of about 2000-2500 entries and
then there are few lists of varied number of entries. I want to compare this
master list with all these other list and at the end, get an excel sheet
where one column will have all entries from master ...

I imported an excel spreadsheeting into a local table in Access 2003.  There
are ~1400 records (dates, text, and integers).  I verified that the date and
integer fields contain only that type of data.  When attempting to run an
append query to a sql 2000 database table (with the ...