User Profile

Collapse

Profile Sidebar

Collapse
rhuns
rhuns
Last Activity: May 22 '19, 12:43 AM
Joined: Jun 23 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rhuns
    replied to Formatting One part of an Expression Text Box
    in Access
    Hey Mike, that's the one! Thanks for that :)
    See more | Go to post

      Leave a comment:

    • rhuns
      started a topic Formatting One part of an Expression Text Box
      in Access

      Formatting One part of an Expression Text Box

      Hi all, drawing a blank and need some assistance. I have a report with several text boxes (City, State Zip) that I am condensing into one. The text box that displays on the report has a control source set to

      =[txtclientcity] & "," & " " & [txtclientstate] & " " & [txtclientzip]

      This is all functional, problem is, almost all zips begin with a "0" via the area....
      See more | Go to post
      • rhuns
        replied to Advanced Login System with Admin Privilege?
        in Access
        NeoPa,

        Your code worked perfectly! Thanks so much! I've been stuck for over a week trying to debug this one. Thanks again!
        See more | Go to post

          Leave a comment:

        • rhuns
          replied to Advanced Login System with Admin Privilege?
          in Access
          Neopa,

          I tried your code and it works!

          However, how would make the distinction of and Admin vs. a regular user?

          I.E.:

          I want certain buttons, like addnewbtn, or, updatebtn, only enabled to Administrators, not regular users. How could this be accomplished?...
          See more | Go to post

            Leave a comment:

          • rhuns
            replied to Verify if a text box = 0 is has nothing in it?
            in Access
            Thanks Jerry, for the help the IsNull() worked perfectly!
            See more | Go to post

              Leave a comment:

            • rhuns
              replied to Advanced Login System with Admin Privilege?
              in Access
              I apologize I may not have been as clear as I needed to be. There are two forms I have: one a login and one a menu. I want certain buttons enabled to certain users and other buttons not enabled to certain users. Is there a way I set the current record through the login screen? Here is the code I have so far:

              Code:
              Private Sub Command8_Click()
Username.SetFocus
If Username = DLookup("UserID", "ActiveUsers",
              ...
              See more | Go to post

                Leave a comment:

              • rhuns
                started a topic Verify if a text box = 0 is has nothing in it?
                in Access

                Verify if a text box = 0 is has nothing in it?

                I am trying to verify if a text box is equal to 0 or is blank before the close button is pushed. The code works if the box equals 0 but not if it is blank. Can anyone help me with this. Here is the code:

                Code:
                Private Sub Command33_Click()
UnusedHRS.SetFocus
If UnusedHRS = 0 Or UnusedHRS = Null Then
    DoCmd.Close
ElseIf UnusedHRS <> 0 Then
    MsgBox "There are still hours that are unaccounted
                ...
                See more | Go to post
                • rhuns
                  started a topic Advanced Login System with Admin Privilege?
                  in Access

                  Advanced Login System with Admin Privilege?

                  I have a database with a table called activeusers and 3 fields. "UserID" "Password" and "Admin". Admin is a yes/no field. I would like to use this field to enable certain buttons on the switchboard screen. how can I use vba to check wether the Admin feild is checked or not?
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...