Results 1 to 2 of 2
  1. #1
    Heatshiver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011

    Question Password ideas w/o using VBA on Sharepoint?

    I know that I can't use VBA on Sharepoint (althought states there's a way!), and must prepare a DB accordingly because of that. I was wondering if there was anyway to go about including a way to use a password of sorts without VBA? I had a few ideas but wasn't sure where to go with them:

    1) Use a macro to some how ask for certain input? Didn't find an obvious macro that would do this, but maybe someone has some ideas?

    2) Use the RunCode macro? I was thinking if I wrote a function to ask for a password that the macro could run the function, but I assume that since VBA is still needed it wouldn't get very far...

    3) Queries? Is there a way I can use the Criteria of a Query to ask for some sort of specific input (or at least something that wouldn't be obvious to the user) that would be needed to move forward?

    4) Validation? Can I somehow use validation to require a specific term or number, rather than just a specific format?

    5) Maybe a combination of the ideas above?

    This is all I could think of. I am aware that use can set permissions on Sharepoint, but I don't think you can specify which forms/reports a user can see or not. If I am wrong, please tell me as this would save me the trouble of finding another method.

  2. #2
    Heatshiver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Just thought of something, what if I have a query parameter for a number between two fields of an unused table, in which the number between the two fields is only one number. Would this work in terms of not allowing a person to move forward without providing the correct number?

    If so, I was thinking it could be used by a macro, and the next event would allow them to go to the relevant form/report...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Weather Database Ideas
    By bigroo in forum Database Design
    Replies: 4
    Last Post: 01-19-2012, 09:43 AM
  2. New to access, need ideas!
    By phenicie in forum Access
    Replies: 1
    Last Post: 12-27-2011, 05:55 PM
  3. Ideas for database creation
    By randolphoralph in forum Access
    Replies: 1
    Last Post: 08-31-2011, 02:08 PM
  4. Any ideas?
    By eripsni in forum Access
    Replies: 9
    Last Post: 08-25-2011, 08:33 AM
  5. Need some ideas
    By amauricio2 in forum Database Design
    Replies: 0
    Last Post: 03-02-2009, 11:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums