I have a quick question.... I would like the currentuser to populate a field
in a table. I have tried using the =currentuser() function without effect. If
i add it on a form then it defaults the whole table to that user. I would
like the current user to be recorded against each ...

I have a main form for customer head office details with CustID, CustName,
CustAddress etc which has a subform for invoice addesses. There is also a
command button which will take you to another form which is for delivery
addresses. Now some customers have an apostrophe in their ...

How difficult is it to convert a database of Access tables to SQL that can
then be linked to an access GUI.

I’m not a database designer, yet find myself writing the specifications for a
new database (Access now -> SQL in 2008) that will be used:
1) Internally: To manage a fairly simple business (one user, 8 to 10 tables),
and

I have a table with the fields COUNTRY and DESP NO.
I want every time a new country is enter in the field COUNTRY the DESP.NO to
be increased by 1.
Example:

I need a library to hold Standard Operation Procedures.  There is appx 1200
SOPs that we use.  Whenever an SOP is updated, the reference number changes
(example:  AB.01.0.1 CHANGES TO AB.01.0.2) on the implementation date and the
old one is archived (archival date may be different ...

I am importing data into Excel and wish to use Access for reports.
This is an example of the data I am importing.
Me      177      Alg        1/1/03     496
Me      177      Eng       5/5/05     400

How can I create an evaluation table for a group of researchers to
concurrently assess each other without any of them seeing how their team
member is assessing others?

I'm trying to create custom menus in MS Access 2003. I've figured out how
create the menu bar, add 1st level commands and written the code to support
them. I can't find how to create a subcommand and place it on the menu. Nor
have I been able to determine how to disable or "grey ...

I have just merged with another company and we want to combine our
databases. They are both Access 97 and each have a table with the same data
fields.
However both have primary fields using Autonumber starting with 1 which are

I have about 300 tables in my relationship view.
Because a number of tables are used in more than one "portions" of the db,
to make the view more comfortable, I duplicated these tables in the
relationship view, such as tbl1, tbl1_1 (_x is a suffix by access).That way

Having made a conversion of the database between A2000 and Access 2003, the
details of all objects are no longer visible. I can see the objects under any
other icon view mode but I need the details and I need to be able to sort the
objects.

I have a db I am developing and I am at a impasse.
I have a agency table that stores a unique ID for each agency.
Each agency has multiple program names unique to an individual agency,
and each user is assigned to an agency but can be part of multiple programs

Hi I have a table which has the fields PolicyHolder (Primary Key) and
PolicyNumber plus other fields.  I need to allow the same PolicyHolders name
to be used but only to one policyNumber.
i.e. Smith policy number 1234, Smith policy number 4321 and so on but never

How do I retrieve a list of the last 100 email addresses used?