I have a database for my publishing company. We publish monthly magazines, 12
separate titles.
Currently my database stores the number of issues for an order by a number
(representing number of months) that is decreased by one each month via a

I have design one simple access database. Now I would like to destroy /
“disable to open” my database on or after the specified date.
    Also please note following things;
1.    database is very simple as it contain only some table, very simple query

Is there a 'best practice' when it comes to creating forms based on many
different tables? Generally I try to use as few subforms as possible, using
them when I can no longer create a single updateable query. (Often resorting
to code when I know I should use a subform).

I have a database with four seperate tables. Patient Demographics, Surgical
Information, Follow up and Patient Satisfaction. I used the patients medical
record number as the primary key in each of the tables since it stays the
same for the life of the patient and is unique for ...

I have 2 functions that find the user name and machine name. I want to set
these functions as the default value for the respective fields in the Table
design but it won't let me. However I can set them in a Form with the
respective fields on the form. Is this normal?

I have designed a database to track all my projects. I have a field that is
called recorded document number. When I receive copy of the recorded document
I scan it and save it in a particular folder. I would like to have a
hyperlink between this image and the document number ...

Is there a simple way to generate the next PK by adding 1 to the largest PK
when you add a new record?  I can't use Autonum because my order # starts
with the Fiscal year (i.e. 20090001, 20090002, etc).  I tried to use:
 =DMax([Sequence No],[Workload])+1

Can you create a field in a table that can only be filled out if another
field is filled out? For instance, you need to know how much somebody paid,
but only if they have already paid. Otherwise, how much they paid should be
left blank. Is there a way to do that?

I am creating a report and inserted a bitmap file from a table.
On the report print preview, the report is showing the image with the file
name.
I just want the image to show not the file name.  Please help.

Just starting out in access. I am trying to create a database for work that
shows:
1. Events (upcoming and past)
2. Attendees

Hi! My name is Hector and I been working on a Data Base I need to do for my
work the thing is we have to do an spread sheet so we can fill out some
information but im having some troubles creating it and this are they
the first one is that there is one field in wich i need to ...

I recently posted a question under general questions and was given great
advise, but I am still a little confused.  
I need to create a database for a college program that I am responsible for.
I currently work out of many spreadsheets.  A database will make my job

Does anyone know if Access could have subgroup items on the navigation pane?
Instead of using a subform, I am using the Navigation Pane wih a custom
category and group...I would like to be able to choose a subgroup froma group
item, just as you do with an expanding menu like on a ...

I have one table named Jobs and one named Customers.  We sometimes build
more than one job per customer and occasionally have more than one customer
per job.  I have created a join table to permit the many-to-many relationship.
    The problem I have is that I can only have one ...

I am looking to create a field for ad space that I can enter a few simple
fractions into (i.e. 1, 1/2, 1/3, 1/4, 2/3) for ad space size that I can add
in queries.  It seems that is a lot trickier than it should be.  I would
rather not convert to or from decimals if possible with ...