I have tried to use Arvin Meyer's GetBusinessDay function to calculate a due
date from a recieved date. It works fine except for one problem:
The function reads dates from the holiday table as US dates but all my
region settings are in UK Date format. So if I have a holiday date ...

I was assign to develop an Admin Forms database for my office. It consists
of 20 or more form. Our HR personel adviced us not to allow browsing staff
information. Is there a way to capture login name of the current user from
AD? I want to bing this login name to the name of staff ...

I have a query with criteria in 2 fields:
FieldA has criteria: [forms]![MyForm].[Field1]
FieldB had criteria: [forms]![MyForm].[Field2]
So I need an exact match on those 2 fields.

fairly new to access. I have about numerous pdf files that i would like to
convert into an access database. what would be the easiest way to go about
it, factoring into the equation that  I am still learning this program?
The pdf file is already set up in a excel chart like format ...

I was wondering if it was possible to disable a check box once another check
box has been selected.
Eg. I have a Walk-in Assissted and Walk-in Self-selected - obviously they
cannot both be selecte and I dont want staff to be able to select both

Hello Sirs,
I'm new to this community.
I have a problem & need help.
In Access Form, how do you make a link to PDF file, so if you click on the

Hi - I am using Microsoft Access 2003. When importing a csv file into an
Access table I am having problems importing when my "location name" fields
contain an apostrophe in the name such as Northwest Women's Group.  For that
rows data the information to the right of the ...

I used the "Mid" function in a query to extract a single integer from a long
part number field.  I want to use that field (the single integer field) to
return a value in another table.  I used Dlookup without success:   Expr1:
DLookUp("[Description]","[Unit type]","[Type] = ...

Im creating a contact database for our marketing person. Most of it I
can handle, but I have one issue. A contact can belong to one or more
organizations in the architectural world, ie, AIA, AAMA, etc...
What I want to do is have a check box for each of these orgs. Then our

I posted this in the Queries section and got a good start but I need to close
the loop (as it were).
I have a table (I cannot change the layout) with the following structure
(strID is the Primary Key):

We recently upgraded to Microsoft Office 2007 and I'm using Windows XP SP2.  
I previously programmed in 2002 for about 4 years so I'm not new to Access -
however, I don't know why I'm having the following problem.
When I toggle via Alt F11 to VBA and upon the first key stroke I am ...

I have a check box and a text box. I want to disable the text box if
the check box is not checked.
Im using:
If Me![MBE].Value = "-1" Then

HUGO JOEL IS PK

"I have 5 years of data which has a hiredate".  I would only like to retrieve
the current year's data.  How do I do this in a query?  I tried date(), Now()
but am drawing a blank.
Thank you.

Newbie here and I need some help.
I am setting up a database for members who want to be on our mailing list. I
have fields: ID # (primarykey, assigns automatically for new entries), Last
Name, First Name, Address, Zipcode, etc.