I've been searching here and on other places on the Internet but I just can't
find a solution to how to calculate age and gender from swedish
"personnummer" (yymmdd-xxxx where the first two xx is birth location, the
third is gender where 0,2,4,6,8 is female and 1,3,5,7,9 is male) ...

This is probably very simple, but I just can't seem to figure it out.  I
have an amount field on a form which is based on a table with a date field
(ChequeDate) for the amount field (ChequeAmount).  What I need is to have the
amount appear in the control only if the date is later ...

As part of a Uni project I've built a database which holds records of
animals for a local shelter. Each record has a field which i would
like to contain or link in some way to an image of the animal.
I've created a form which allows the user to enter new animals data

I need some advice with a design decision.  Customer wants to track people,
along with various means of contacting them.
The easiest way is to have the fields CellNumber1, CellNumber2, EMail1,
EMail2, FaxNumber built into tblPeople.

On completion of the installation, a message box entitled "Workgroup
Administrator" appears with the message:
"An error has occurred at changing workgroup database"
On clicking the OK button, another message box with the same title appears:

Is it possible to create letter templates from access DB? If so how.
For example I want to create an insurance letter regarding the medical
necessity of bariatric surgery. I would need to be in the patients record &
would like to choose a template that would place the PT name, ...

6565

I have a strange problem with Access 2007. Made a database in Access
2003 years ago. This database uses many sub forms (containing one text
field, based on a query and the text field showing a calculated value
(SUM(..) from the underlying query) .

I get this error message when I tried to import a table: An error occurred
trying to import file ... The file was not imported. And access didn't say
what the problem is, how to I fix the problem?

I sent a Front-end to another city to relink to a Server using a different
letter. My city has "S:", while the other city uses "N:".
The User tried to save/ detach the Front-end mdb by a Copy to the Clipboard
(on a wireless connection laptop) and it stayed as an hourglass.  He ...

Hello all. Here is the problem I have an Access 2k3 db size approx 1.4GB, was
doing a compact/repair on it when it said there was not enough disk space to
complete the operation and to remove or move some files...... After this the
datbase shut down and now cannot be opened. ...

A User in another City is running an Access FE (works fine for me), and is
getting "File already exists" while running this code..
DoCmd.OutputTo acOutputQuery, "PTField", acFormatXLS, _
"C:\Documents and Settings\All Users\Documents\SelfAud\PTField.xls"

I am creating a database and need some help. I have several tables with forms
to input information. I have a main table that some of the information from
the forms is inputted. What i want to do is put a control button that when
clicked it puts an auto number in a field with a ...

Could someone please lead me in the right direction to get instruction on how
to do the following (NOTE: I have both Outlook 2007 and Access 2007 loaded on
my machine):
I have a query that pulls certain contacts based on a set of criteria.  The

When datasheets are used as subforms in Access 2007, column headers/labels
have a dropdown menu, the opening arrow of which takes up space which could
have ben used as part of the label in earlier versions of Access.  Can these
drop down menus be got rid of in Access 2007?