Results 1 to 4 of 4

Thread: Code Error

  1. #1
    Join Date
    Jan 2012
    Location
    India
    Posts
    42

    Exclamation Unanswered: Code Error

    Hi,

    I've a concern in following code that this code is working in PC but not in client's PC. This code is about expire login pwd in application after 30 days. User is "admin" and PwdDt is last password created date, txtuser is UserName in login form.

    Private Sub txtusr_AfterUpdate()
    If Me.txtusr = "admin" And date - PwdDt > 30 Then
    MsgBox "Your password expired. Change now.", vbCritical + vbOKOnly, "Password Expired"
    DoCmd.Close 'Close login window
    DoCmd.OpenForm "FrmSecurityCheck" ' Open password change form
    End If
    End Sub


    Can anyone guide why is this problem coming and how can I resolve it?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    When apps run fine on one machine and not on another or run fine in one version and not when run under a newer version, the first thing you have to think about are missing references.

    If you haven't checked for this before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:


    Access Reference Problems

    Aside from that, what exactly does "not in client's PC" mean? Do you get an error message?

    Linq ;0)>
    Last edited by Missinglinq; 04-15-12 at 17:54.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jan 2012
    Location
    India
    Posts
    42
    i tried but while installing, it says old version of mdw. install new.

    I'm using 2003 sp3

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by anujkmehrotra View Post

    ...i tried but while installing, it says old version of mdw. install new...
    While installing what?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •