show multiple results and links?

D

Duckforceone

Hiya.

The other day, i threw myself out into learning parts of access very fast, as
i needed it for a user project.

The result has become this
http://dl.eve-files.com/media/corp/duck/eve-ccg_spoiler_database.zip

But in wanting to make more functionality, i have a few things i would like
to include in the database.

Is there any way that i can get a form to show multiple names on one page?

I can get them to list as this

name 1
name 2
name 3

but what i would like is
name 1, name 2, name 3
name 4, name 5, name 6


on the same note, is it possible to make it so that you can click on the
names and make it open up another form that shows all the entries for that
name?

and lastly, partly form related, is it possible to embed some sort of search
field on a form, like
[ enter name ] (press button to search)
[ enter number] (press button to search)

hope this doesn't sound too bad... and hope someone can help
 
M

Michel Walsh

Hi,


About the searches, use the wizard (for buttons), to search (based on the
content of the previous control), or something similar; or the wizard for a
combo box (on a bound form), through its option "Find a record on my form
based on the value I selected in my combo box.".

As for displaying 3 records per row, I would use a query, but that would be
not updateable, since I would need to "rank" the records among themselves
(first, second, third, ... )




Hoping it may help,
Vanderghast, Access MVP
 
Top