I am trying to design a Company Photo Directory in Access 97 and need
suggestions or help.  I currently have a database table with names and
information, and have a query with just the information that I need for the
photo directory.  I want to have pages, like a yearbook, ...

I have a simple database of products and suppliers and a couple of small
lookup tables.  The products and suppliers tables are linked in a
relationship using the supplier's Sage code and this field is also used as a
lookup from suppliers when adding data to products.  When I set ...

I wonder whether someone can help me please.
Through the knowledge I've gained from this and other sites I'm now able to
design a query that asks the users for parameter information to return the
desired matching records. e.g. colours that match a certain colour code or if

My form is used for entering records.
When a user clicks a button to submit one, I want a pop-up box to load up
saying "Would you like to enter another record?" with Yes or No options
listed below. If yes, a new blank record loads up, if no, the form closes.

I have a form that is has several memo fields, so it is more than one page.  
But there are several key fields that I want to remain showing on the top of
the page, as I scroll down to fill in the other fields.  In essense, it would
be as if the key fields are remaining stagnant ...

Any Ideas?
Thanks in advance.

I have a field called next monitor where I have another field called over due.
In the overdue field, I am using the following code to make a yes/no
determination.
overdue: Iff(dateadd("m", [audit_len], [NextMon])<date()"yes","no")

I develop software for schools.  Some of them have old Window 98 computers
that are used at 800 X 600 resolution and some are newer and kept at 1024 X
768 resolution.  Some of my forms have design controls that go from edge to
edge.  It I set them at the 800 X 600 resolution they ...

background info - my table includes the following categories: Last name,
first name, Document number, document title, date trained, training status
I would like a form where I can have the user enter in a new document number
and document title and then be able to select the ...

I'm having a time with a form that I need to be able to add new records to.
Here's the sinario.
Form name: frmMyEmployeeMilestones
   Record Source: A query named qryMyEmpMilestones

Sorry for the newbie Q!
I need some VERY basic info in the simplest of terms to enable me to have
the cursor positioned in the second field regardless of which field it was
on the previous record prior to going to "new record".

Hello and thank you in advance for your help.
I am looking to add records to a table with patient information via a form.
I've created an Add Record button, and what I want is when it is clicked, for
it to automatically generate the next primary key in the table sequence.

Is it possible to create a subform that does not appear at all on the main
form? I want to be able to record identification detials against personal
records (the reason I would like it to run as subform using Peron ID as the
link) but i dont want the subform to be open/visible ...

I have two subforms sitting on a form that I am attempting to write to the
same table.
On the two subforms (A and B) exists the same/identical fields from the
single table (table 1).

I have insurance forms that we usually fill out by hand. I want to fill them
out using my database of patient information. However, rather than printing
the information onto preprinted forms, I want Access to print the insurance
form, with the data inserted into the appropriate ...