Company Photo Directory HELP needed

[javajeff]

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, displaying a
picture, name, title, and years in company. I need help in understanding how
to make rows and columns to display this information. If there is already a
template for this, please let me know where to find it. If using a program
like word or excel to design the layout is better, let me know. I need
insight!

 

[Mr B]

javajeff,

It sounds like all you have is a table and a query. Consider this:

For doing data entry, you need a form that you design.

Then for output you need your query alright, but you also need to design a
report based on the results of your query.

That's a quick overview of the process. As you begin to work though it, you
can post back with specific questions and someone will try to answer your
questions.

 

[javajeff]

javajeff,

It sounds like all you have is a table and a query. Consider this:

For doing data entry, you need a form that you design.

Then for output you need your query alright, but you also need to design a
report based on the results of your query.

That's a quick overview of the process. As you begin to work though it, you
can post back with specific questions and someone will try to answer your
questions.

--
HTH

Mr B
askdoctoraccess dot com

Sorry if I was unclear and did not specify that I tried to do this in a
form. I posted in the Forms Discussion group, which means I need help with
Form design or another solution like Word mail merge or a design idea for
Excel or something else. So let me clarify. I am having trouble with Access
97 forms. Thanks!

 

[javajeff]

I need help with the Form designer or another option. I posted in Forms
discussion, so I thought that would be obvious. Sorry for the confusion.

 

[Mr B]

javajeff,

There is no problem, I may have just misunderstood what you wanted.

Just FYI, just because someone posts to a peticular forum does not
necessarly mean that that is what they really need help with.

Ok, so I guess you want to view each person's information one person at a
time on your form. If so, have you placed any controls on your form? What
have you tried?

You should make your query the record source for your form. Then place a
control on your form for each field in your query. I would suggest that you
start with all of the fields except the picture and make sure that you can
then use the record selectors at the bottom of your form to move throught
each of your records.

Then, when you have this working, you can worry about your picture control.

 

[javajeff]

I was able to create the form. What I do not understand is how to make it so
the form will display something like 12 on a page? How do I make it so that
it will automatically take entry 1, then entry 2, then entry 3, etc. Do I
duplicate the layout 12 times and will it automatically populate each one
with a new entry?

 

[Mr B]

The default view for a form is "Single Form". This means that it will display
one record on the form. You then can move from record to record.

There are other options for how the form displays the data. You will most
likely want to use the "Continuous Forms" option.

Go to the properties of your form and change the "Default View" property to
"Continuous Forms".

This will cause each record to be displayed in multiple records. The number
of records that are displayed on each "page" will depend on the size of your
form.

 

[javajeff]

Great! Thanks! I now have the problem of getting pictures to display
automatically. They are just icons in the form, and say package in the
table. How do I get the picture to activate internally rather than through
my external program?