locked
Access Form UserName and Password

    Question

  • Ok will see how this explanation goes!!!

    For this class:


    Using Access 2003 need to have it work on Access 2007.

    making an application for a movie rental store with Access.

    Have the relationship thing figured out I think
    <!--[if !supportLineBreakNewLine]-->
    <!--[endif]-->

     

    Found out about validation in late rental fees. 

    (Ex. if customer has not paid over dues customer will not be able to rent movies until over dues are paid up.)


    Looking for a username and password protection with a count down timer that would lock the application after certian amount of time? Hopefully no movment then start the count down timer.

     



    Need total protection with username and password of the program. Not readonly but to have unauthorized users inside the forms.

     

    We can not use Access as security.  I am thinking VBA.  I found the VBA form with the buttons.  So i would insert Visual basic code into there?


    I'm going to try the vb code in there.  Any pointer would be great...

    Hope this makes sence


    Thank you

     

     



    Wednesday, February 13, 2008 7:18 PM

Answers

  •  Phil212 wrote:

    Found out about validation in late rental fees. 

    (Ex. if customer has not paid over dues customer will not be able to rent movies until over dues are paid up.)
    Looking for a username and password protection with a count down timer that would lock the application after certian amount of time? Hopefully no movment then start the count down timer.

     

    Hi Phil212,

     

    Welcome to MSDN forums!

     

    You can use a Timer object to implement Count Down feature.

    Prerequisites: Label and Timer1 on Form1.

    Code Snippet

    Public Class Form1

     

        Dim allowTime As Int32 = 60 ' limit to 60 seconds

     

        Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

            Timer1.Interval = 1000  ' 1000 millisecond = 1 second

            Timer1.Start()

        End Sub

     

        Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick

            allowTime = allowTime - 1

            If allowTime = 0 Then

                Label1.Text = "Overtime"

                Me.Close() ' Close current form

            Else

                Label1.Text = "Remain time: " & allowTime - 1 & "seconds"

            End If

        End Sub

    End Class

     

     Phil212 wrote:

    Need total protection with username and password of the program. Not readonly but to have unauthorized users inside the forms.

     

    What you said is typical multi-user management database application. You need to implement User Login/Verify feature.

    Please check the following code samples:

    1. Code sample: create a login form and add/delete user

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2676391&SiteID=1

     

    2. Code sample: create a login form and change user password

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2647742&SiteID=1

     

    How to make login form more secured

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2032444&SiteID=1

     

     Phil212 wrote:

    We can not use Access as security.  I am thinking VBA.  I found the VBA form with the buttons.  So i would insert Visual basic code into there?
    I'm going to try the vb code in there.  Any pointer would be great...

     

    Visual Basic for Applications (VBA) forum is here:

    http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=74&SiteID=1

     

    For Visual Basic 6 questions, please read...

     

    Regards,

    Martin

    Friday, February 15, 2008 9:14 AM

All replies

  •  Phil212 wrote:

    Found out about validation in late rental fees. 

    (Ex. if customer has not paid over dues customer will not be able to rent movies until over dues are paid up.)
    Looking for a username and password protection with a count down timer that would lock the application after certian amount of time? Hopefully no movment then start the count down timer.

     

    Hi Phil212,

     

    Welcome to MSDN forums!

     

    You can use a Timer object to implement Count Down feature.

    Prerequisites: Label and Timer1 on Form1.

    Code Snippet

    Public Class Form1

     

        Dim allowTime As Int32 = 60 ' limit to 60 seconds

     

        Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

            Timer1.Interval = 1000  ' 1000 millisecond = 1 second

            Timer1.Start()

        End Sub

     

        Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick

            allowTime = allowTime - 1

            If allowTime = 0 Then

                Label1.Text = "Overtime"

                Me.Close() ' Close current form

            Else

                Label1.Text = "Remain time: " & allowTime - 1 & "seconds"

            End If

        End Sub

    End Class

     

     Phil212 wrote:

    Need total protection with username and password of the program. Not readonly but to have unauthorized users inside the forms.

     

    What you said is typical multi-user management database application. You need to implement User Login/Verify feature.

    Please check the following code samples:

    1. Code sample: create a login form and add/delete user

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2676391&SiteID=1

     

    2. Code sample: create a login form and change user password

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2647742&SiteID=1

     

    How to make login form more secured

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2032444&SiteID=1

     

     Phil212 wrote:

    We can not use Access as security.  I am thinking VBA.  I found the VBA form with the buttons.  So i would insert Visual basic code into there?
    I'm going to try the vb code in there.  Any pointer would be great...

     

    Visual Basic for Applications (VBA) forum is here:

    http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=74&SiteID=1

     

    For Visual Basic 6 questions, please read...

     

    Regards,

    Martin

    Friday, February 15, 2008 9:14 AM
  • Thank You Martin,

    I will work with this.

    Phil
    Saturday, February 16, 2008 2:05 PM