I'm new to Access.  I want to store pictures as part of
each record (JPEG files). I would like to find the most
efficient and easy way to see the pictures when viewing
the form of a record.

I have posted a few questions and got some very interesting replies about
how to place pictures into a 1600 record database. That means I need to
insert  1600 different pictures...!!!! Each of the pics I have is only about
30K.

I am creating a student attendance table:
Start date Field 05/01/2004. I wish to create a formulae in the table that will automatically calculate 7 days from the start date and insert the calculated date in the Week2Date Field.
Can this be done in the design view of the table? Any ...

I am Using Visual Basic to modify an ACCESS Data Base. My
quest is to modify (Add, Change and Delete) data from an
ACCESS database.  I can read without problems using the
DataEnvironment, from Designers, but I can't seem to get

I would like to use the "update" VB statement.  Is this a
valid VBA statement??  I am a novice in VBA and have
books on VB, but haven't really used it!  I would like to
update a couple of Y/N fields on a table, based on

I have a field in a table that has a list box lookup
based on a query.  In the query, there are 2 columns, A &
B.  When I select a value from column A in my field with
the list box lookup, I want the corresponding value from

I am running my DB on Access 2000. I need to open a
recordset, but have not been able to do it yet.
The code I am using like this:
 Dim rstEmployees As ADODB.Recordset

How can I allow duplicate records in Access 2000?

I'm looking for an Access template which can
be adapted to use for volunteer contact mangement
and event scheduling.
Thanks, Chas

I am having problems getting my select query to allow me
to add records to it.  I made a database to keep track of
inventory.  I have a "prototype" system to aid in the
transition and also another system (exact same) that we

I'm trying to export a table into dbf form and I'm doing
this with the use of TransferDatabase function.
How do I export a table by agreeing with some conditions.
 a. FieldAmount must be nine (9) numbers or characters

I have aphyscians combo box on my main client form.  I placed a command button on the form that will open a physicians form to enter the proper info in case the doctor isn't already on the list
I entered a Dr. using this method and when I go to the form and use Ctrl F to pull him ...

I am using Access 2000 and have am using a database I got
as a student file. I need to rename the tables but when I
do the source properties of the queries, forms and
reports are not updated. I did have to enable

I have a combo box on a form where we can choose from a list a physcian for a particular clien
I had the combo box set up and then realized that I had set all of my primary keys of the names of clients or employee
I went through and added CustomerID and EmployeeID and changed all ...

In my Autonumber fileds there some gaps between numbers - probably because
of deleted records - how do I compact the table? The database
utility-compact does not do this