Solved Secure Info (1 Viewer)

[sctb0825]

I am using a Tabbed Subform, I need a popup window that I can secure, so I can put account number information into the database.
What is the best way to do this?

I would like the popup or tab inside the main tab. ie tab inside another tab.
(hope you understand what I mean)

example: I have a Financial tab in a form to record the info to collect and pay customers. I only want this info available to authorized users in the accounting dept.

I want it so that when a user tries to access this info or enter the information they have to first enter their password.

 

[bastanu]

There are many ways to do this kind of thing, you could use a subform control on the protected tab that you empty (meaning you don't save it with a SourceObject) by default (and reset in the Current event of the main form when moving to another record). Then in the Change event of the tab control you check if you are on the protected page and if yes you prompt for the password and, upon validation you set the subform's control SourceObject property to the desired form. Another way, usually of the fields to be protected are on the same recordsource as the main form, is to use the tag property of the controls to make them invisible and again in the Change event of the tab control to turn them visible if the correct password was entered.

Cheers,

 

[The_Doc_Man]

If you have a tab-page set aside for this, there is a click -event associated with the Tab-page control. You could trigger your password from there via a form using a modal dialog. You can make the form big enough to completely cover the screen so that nobody can get to the stuff on the Tab-page until they close the modal dialog. Our member theDBguy has a nice article on this.

Pop-up, Modal, or Dialog Forms

This article is an excerpt, reprinted with permission, from the book " Professional Access 2013 Programming ." Pop-up, Modal, or Dialog F...

thedbguy.blogspot.com

Here is a useful event for Tab controls that will help you decide WHEN to pop up the modal dialog.

TabControl.Change event (Access)

Office VBA reference topic

docs.microsoft.com

And of course, it is possible to force a different page if your password popup says "wrong password."

Open Access form to a specific page on a tab control on a different form with VBA

I have created a help index on a tab control with 60 pages. Each page contains helpful information to the question that corresponds to the page. The questions that are being answered are on a dif...

stackoverflow.com

 

[Uncle Gizmo]

You may find my blog on a password protected tab useful:-

Tab Controls - Nifty Access

Tab Controls You can use a "Tab Control" to present several pages of related information. A "Tab Control" allows you to squeeze more information on to your Form, making it possible to have a smaller Form, or have a more "information dense" Form. You can also place subforms on your Tabs.See my...

www.niftyaccess.com

See video:-

 

[sctb0825]

Thanks a bunch Bastanu, Doc and Gizmo, all very helpful I am getting what I need from all this great help.