I have a form with a subform.  In the subform I have several fields to
which I am assigning links to documents on the file server.  I learned
(from this list :-) how to add the links.   Because I will be executing
the code for four or five fields, I would like to have a generic

I am trying to write a Data Definition type query that will add a new
auto-numbered column to an existing table.
Typically, I would set this up with the following syntax:
"ALTER Table XXX

I'm trying to calculate the median of some numerical data. The data can
only be found in a query (henceforth query 1) field I previously made,
and I would prefer to calculate the median in a new query it without
making a table out of query 1. I can't find a median function in the

I have computers setup with A97 runtime with mde's. Work perfectly.
I've written an app in 2003 and purchased the Developer extensions.
When I load A2003 runtime with my app on a computer that has A97
runtime, I cannot open the A 97 mde's.

I have a database of employee data in access and I am trying to create
a form with combo boxes for criteria (ex. gender, office, position,
etc.) that let the user select criteria from drop down menus (ex. they
may select Male, New York, Manager) and those criteria will be used to

I have an problem.  I made a small auction using .asp and access2000
where the user bids and a table holds the following information;
table - bids
ID

Hello,  I'm working on a database project were I am getting an error
message saying that I can not delete or change a record because the
table includes related records eventhough there is not a relationship
between the two. Any ideas would help!

I wish to create a report with a chart, but I want to use a SQL
statement as the source of the data, using VBA code in the reports load
event
I found the following snippet

Thanks for your previous post. I've run into another hurdle, and would
greatly appreciate any help you may be able to offer. I have revenue
data sorted by month and years for a number of distinctly labeled
stores (imagine a Center ID). I would like to find the percentage of

I've got a report that has a subreport on it.  On the subreport I've got a
label and control printing.
I'd like to have both the label and the control print only if it's not the
default for the control.  The label/control is a lblDrLicNo/DrLicNo.

I have an Access 2003 database application that I split into an
application component MDB file (i.e., forms, etc) and a data component
MDB file (i.e., tables, etc.).  I used the 2003 developer extensions
Package Wizard program to create an installation package.  (Note: I

I'm trying to EXPORT the results of a query to a CSV file.  I've been
doing this, using different queries, for WEEKS, with no problems.  This
file always thinks that the resulting export file is already opened,
but the file resides on my hard drive, and I get the error even if I

I am trying to figure out if there is code to move a PDF file from one
folder to another in Access 2003. Just wondering if anyone has any
suggestions?
Ken

Hi, I'm new to Access so this is probably a stupid question.
I am creating a patient database.  I want to create a form in which you
enter a SSN # and that person's name and ID number will appear. The
purpose of the form would be to see if the patient has a previous

How can I clear the selection from a multi-select list via code?
Thanks
Regards