The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+training - Password protection for Sub Forms

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

microsoft+access+training - Password protection for Sub Forms

Resolved · Low Priority · Version Standard

ReplyWed 14 Mar 2007, 14:46Delegate Brian said...

Password protection for Sub Forms

Hi

Is there a way I can generate some kind of password protection to a specific sub-form within a form?

I feel I ought to be able to create some code within the properties of the sub-form which when it is diplayed (it is within a tab on the main form) it asks for some input to an input box to which I can set a value which must be met, otherwise access is prevented.

I'd appreciate some advice on this please

Thanks
Brian Clark
Jobcentre Plus

For upcoming training course dates see: Pricing & availability

ReplyFri 16 Mar 2007, 12:56Trainer David said...

RE: Password protection for Sub Forms

Hi Brian

The answer to your question is it can be done using Visual Basic, however I am not sure whether it can be done using VBA, basically you will have to create a permissions table, then the form you are talking about loads it will check who is logged in and what permissions they have, then will only display the data that they have permission for. My initial reaction is that this is too much for VBA to handle and would need to be done using visual basic.

I will check this out and if I find it can be done using VBA I will get back to you. I hope this answers your Microsoft Access VBA question.
David

Access articles

· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Protect Sensitive Access Databases With A Password
· So what's new in Access 2007?
· Getting to grips with Access 2007's Opening Screen and User Interface
· How Does The Startup Work When Access 2010 Launches The Northwind Database

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips

Code relating too above subject.

» Forum post: Macros + webpages

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions