I have a db that record employee's transportation expenses.
If an employee being promoted or change department, I'd like for his/her old
transportation expense records locked. Then, the new transportation expense
record will refer to he/she in the new department.

I have a field setup as a hyperlink to internal pdf. files. Things work fine,
but I have to deal with that damn security popup asking me if this is a
secury site do I wnat to cancel.  What can I do to just click on that link
and get the file to open up?

I am trying to develop a form that does the follow in Access 2003:
Allows me to populate the underlying query which in turn populates a table.
I wish to allow the user to select the data to be inputted using a combo box
on the form.  The data is in 3 levels i.e. Level 1 is Section, ...

I've a database which is about 46mb big. I've 1gb of memory in my desktop.
When I try and open it I get a message to say there isn't enough memory to
open the file close all unneeded applications. There aren't any others open.
I've tried creating a blank database and importing ...

I am developing an Access 2003 application for sale to commercial
customers.  The pricing will include a flat cost plus a per-seat
charge (i.e., a one-time charge to authorize access to the product
from one customer workstation) for as many seats as the customer

Will users who have Access 2000 Runtime installed be able to run an
application created in the full version of Access 2003?  or do you have to
have the 2003 Runtime?  
If I have Office Pro 2003 (with Access) does that mean I have the Developer

Stupid question, but after some googling I still cannot find the answer.
How do I convert regular Access 2000 file (.mdb) to Access Project 2000
(.adp)?
I am talking about queries, forms, reports, modules conversion only - the

How do I get the Adober PDFMaker 6.0 toolbar to show in the dropdown list of
available toolbars in Access 2003? It appears in all of the other Microsoft
Office 2003 applications, but I cannot get it to show in Access, and I am
unable to print to a PDF using the Adobe PDF driver.

HI MAN WHATS UP ITS BLAKE

I have an old version of Access and it does not have all the up to date
versions of Avery labels, can I update the list that appears in my version of
Access?

I want to sort my column (Numbers) in a query ascending from 1 > to any
higher number, Blanks last

I prepared letters for the field with automatic date update and in the body
of my letters, I would like to add 15 and 30 day notices from the date of
receipt.  I am looking for a function that can add 15 to 30 days from the
date the letter is open (auto date update) to the body ...

I created a table with three fields: an autonumber, an integer, and a
date/time field. I set no validation rules or default values. When I
save the table and start entering data in datasheet view, it acts
strangely. If I put 2 in the integer field and press the tab key,

In Excel, it is very easy for me to write if statements based on a previous
row’s content. For example: if(and(a1=a2,b1=b2),”Yes”,”No”).  Is there a way
to write a similar statement in Access with regard to a field’s content in a
previous row?  For example: iif(and(row1 of field1 ...

I have a form in datasheet view which has a part number field,
quantity field, and a description field. The following code allows me
to choose a partn number from the part number field and when I choose
it, it will populate the proper descriptionin the description field as