MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Form Design help

  Asked By: Jalal    Date: Oct 21    Category: MS Office    Views: 1315

I am pretty new at this so I will explain what I am trying to achieve
as best as possible.
I need to send info to practices on a weekly basis with patient
information. There are 22 practices and each will receive 2 reports. I
really do not want to create 44 speadsheets every week. What I had in
mind to do was to assign a password to each record based on the
practice. Then creating a user form?? where they select their practice
and enter the password which would then show only their data. Is this
the most sensible way to do this? Is it possible? How can I do the
latter part?



1 Answer Found

Answer #1    Answered By: Mona Wagner     Answered On: Oct 21

No. Don't even consider it. Excel passwords are not secure, and this
sounds like information that needs to be kept secure.

Why 44 spreadsheets, not 22? At least put all the information for one
practice into one workbook.

OTOH, if the information is not confidential, why not just let the practices
select their appropriate sheets from the sheet tab, or some navigation
facility on a front sheet? (Passwords wouldn't be needed.)

Didn't find what you were looking for? Find more on Form Design help Or get search suggestion and latest updates.