Link to second form for read-only users? Possible????

R

ReadReadWrite

We have a lawfirm library catalog in Access and we want to make it available
to the attorneys here, so I created another form (changing the properties so
that it does not allow editing) for the same table. How can I link to this
second form? From other Access forms I can hyperlink directly to the second
form, but every other way I can find to create a hyperlink or shortcut, I can
only choose the database, which defaults to the original form. I would like
to link directly to the new form for the attorneys from a posted Word
document, and keep using the original form myself. Currently I can get to
the second form only by opening the database which defaults to the original
form, closing the original form and then choosing the second form.
I don't think the attorneys would have any patience trying to use a Data
Access Page, and I find them to be alien and overwhelming myself (where the
heck is the binoculars search icon?).
 
C

Cheese_whiz

Hi RRW,

This may not be the best way, but you COULD make a separate front end for
the lawyers (assuming your file is split). You could import the second form,
link the tables from the back end, and make the second form the one that
opens when the database opens.

CW
 
R

ReadReadWrite

Although I don't think anything is "split," I've created a new database (new
front end?), imported the second form, and linked a table there to the
catalog table. I was then able to hyperlink from Word. Great so far. But
when you click from the hyperlink you get the new database menu (Tables,
Queries, Forms, etc.). Nothing opens! Attorneys wouldn't know what to do
from this point. How can I make the form open on opening the database?
 
C

Cheese_whiz

Hi RRW,

Glad you got it working!

CW

PS: You might want to do a google on splitting an MS Access database. There
are some significant advantages to doing it, particularly if you have
multiple users.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate Form 0
only showing Switchboard on startup 5
Form only has first entry 2
Access Command to run access, open to specific form and specific record 1
Access Manage Attachments linked to a SubForm 0
Special view of form for users 1
How can I link tables with a form? (2007) 0
Excel Export Filtered Form Data To Excel 0

Top