burrina's Profile User Rating: -----

Reputation: 1 Apprentice
Group:
Members
Active Posts:
31 (0.04 per day)
Joined:
09-November 12
Profile Views:
1,338
Last Active:
User is offline Jul 20 2014 02:53 AM
Currently:
Offline

Previous Fields

Country:
Who Cares
OS Preference:
Linux
Favorite Browser:
Chrome
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Who Cares
Dream Kudos:
0
Icon   burrina has not set their status

Posts I've Made

  1. In Topic: Multiple DLookup Help Needed

    Posted 20 Jul 2014

    I managed to get this sorted out.


    Thanks,
  2. In Topic: Trim Text to 10 Characters

    Posted 31 May 2014

    I resolve this finally by this;
    2 Step Process,
    1st: Remove Spaces; Result:
    Replace([sernu],Chr(45),"")
    

    2nd: Trim to 10 Characters;
    m10digit: Right([Result],10)
    


    Thanks,

    Hope this helps someone else.
  3. In Topic: Date Must Be Greater Than Today's Date

    Posted 30 May 2014

    Yep, that got rid of the error.
    Thanks
  4. In Topic: Combine 2 If Statements

    Posted 15 May 2014

    I resolved this issue.

    Thanks,
  5. In Topic: Combine 2 If Statements

    Posted 15 May 2014

    I forgot to add additional info. rememberme field size Integer & default value is 1 Or -1
    'Check To See If Users Computer Name matches Auto login Criteria.
    If DLookup("[pcID]", "tblUserSecurityAutoLogin") <> (Me.txtComputerName1) Then
    If DLookup("[rememberme]", "tblUserSecurityAutoLogin") = 1 Then
        
        DoCmd.OpenForm "frmMainMenu"
        DoCmd.Close acForm, "frmAutoLogin"
            ElseIf DLookup("[rememberme]", "tblUserSecurityAutoLogin") = -1 Then
        DoCmd.OpenForm "frmLogin"
        DoCmd.Close acForm, "frmAutoLogin"
             End If
                End If
    

My Information

Member Title:
New D.I.C Head
Age:
63 years old
Birthday:
November 21, 1951
Gender:
Years Programming:
10
Programming Languages:
VBA

Contact Information

E-mail:
Click here to e-mail me