User Profile

Collapse

Profile Sidebar

Collapse
cdoublen
cdoublen
Last Activity: May 20 '12, 05:40 PM
Joined: Sep 1 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • cdoublen
    replied to Choose Form to open Based on Values in Table
    in Access
    Bingooooo! You know what NeoPa your last comment broke my feet but hey you made me go back to my original code stick to it like a tick and you know what it works. My most persistent error was due to reference to order of events when I was closing the login form prior to testing "User" and "Admin" strings. It now works like a charm. I followed your advise too with Option Explicit which is cool, I've now setup in tools for Option...
    See more | Go to post

      Leave a comment:

    • cdoublen
      replied to Choose Form to open Based on Values in Table
      in Access
      Apologies NeoPa

      I did not realize there were additional responses after my second response to Mihail. I guess it was an issue with my internet being to slow. As I seem to have moved a step ahead with the second option I would like to stick to this in order not to loose focus. Please advice me on my previous post as to why the forms do not open. I have rechecked the names of my tables and fields and are correct please see image attached....
      See more | Go to post

        Leave a comment:

      • cdoublen
        replied to Choose Form to open Based on Values in Table
        in Access
        Guys

        I came across the code below from a similar query here (http://bytes.com/topic/access/answer...different-form) which I have been testing but the last portion where it should choose the form to open just does not respond, logging in password is cleared and no form opens. Here is the code.


        Code:
        Option Compare Database
Private Sub cmdLogin_Click()
 
  'Check to see if
        ...
        See more | Go to post

          Leave a comment:

        • cdoublen
          replied to Choose Form to open Based on Values in Table
          in Access
          Mihail

          Still it makes it makes no difference. On Else I specified a different form so code looked like below but all the when either Admin or User logs in opens "BreakDowns ".
          Code:
              'If straccess = "Admin" Then
        'DoCmd.OpenForm "admin_dashboard"
    'Else
        'DoCmd.OpenForm "BreakDowns"
    'End If
          See more | Go to post
          Last edited by NeoPa; Apr 5 '12, 12:00 AM. Reason: Added mandatory [CODE] tags for you.

            Leave a comment:

          • cdoublen
            replied to Choose Form to open Based on Values in Table
            in Access
            Mihail

            I have tried your code, but it simply opens the form for "else".

            BTW how does this code check the table? I thought there would have been something like a DlookUp or something to to see if the user was an Admin or not from the existing table with users.

            Further help will be appreciated.
            See more | Go to post

              Leave a comment:

            • cdoublen
              replied to Choose Form to open Based on Values in Table
              in Access
              Hi NeoPa

              That is true I should have posted the code here. Please see below.
              It includes my attempts in which now I have changed into comments.
              Code:
              Option Compare Database
Private intLogonAttempts As Integer

Private Sub Form_Open(Cancel As Integer)
'On open set focus to combo box
Me.cboEmployee.SetFocus
End Sub

Private Sub cboEmployee_AfterUpdate()
'After selecting user
              ...
              See more | Go to post
              Last edited by NeoPa; Apr 4 '12, 11:49 PM. Reason: Added mandatory [CODE] tags for you.

                Leave a comment:

              • cdoublen
                started a topic Choose Form to open Based on Values in Table
                in Access

                Choose Form to open Based on Values in Table

                Hi All

                I'm very new to VB coding for Access. At present I'm doinga dbase which has a logon screen. Upon "User" or "Admin" logon I would like a relevant form be opened based on "User" or "Admin" criterion. I have a table that contains UserList with UserName, Password, ID, AccessAS as fields. In The "AccessAS" field there are only "User" and "Admin" values. So Administartors...
                See more | Go to post
                • cdoublen
                  started a topic Broadband Internet Problem
                  in Networking

                  Broadband Internet Problem

                  Hi Guys
                  I am having troulbe with two of my five computer in a wired network. This network is set this way, the five computer are connected in a LAN using an 8 port LAN switch. I have a moderm into which telephone line is plugged, and the ouput from moderm goes to port number 1 of the LAN switch. This setup has been working perfectly for file sharing and internet connection. From nowhere this problem has arisen that two of the computers out...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...