Search results

  1. M

    Query not combining and filtering values based on a form

    Yes the switchboard has a subform but I tried to change the main form. Do you mean make sure in the tblUsers that the uSecurityID field is showing 9? In that case yes it is.
  2. M

    Query not combining and filtering values based on a form

    Just did, on the Switchboard, and I was able to change the layout. I have a securityID of 9 which is Read only.
  3. M

    Query not combining and filtering values based on a form

    Okay applied the code to the On_Current event to the Switchboard to start with and all complied ok. Will apply to the rest of the forms once I have everything working properly. What would be the next step or steps?
  4. M

    Query not combining and filtering values based on a form

    Made form named frmUsers. Record Source tblUsers. When I modify On_Current I will replace "frmMainMenu" and "Form_Current" with the form name that I'm placing the code in? Or just "frmMainMenu"? Opps, I copied fncLockUnlockControls into a new module. Will put in under modUtilities.
  5. M

    Query not combining and filtering values based on a form

    Ok: -I need to make a new form based off of what? What fields do I put in it? -I apply a modified On_Current to all forms that I would like to apply permissions to. -But I don't have a fncLockUnlockControls form?
  6. M

    Query not combining and filtering values based on a form

    Oh wait, the On_Current code at the bottom of Control Form Access? I've been reading and re-reading your past couple of posts and the code all day and can't figure out what I'm supposed to do? What I'm getting so far from your posts: -I need to make a new form to manage permissions (Form is...
  7. M

    Query not combining and filtering values based on a form

    I'm assuming we are talking about the On_Load event code that is under the switchboard? Yes, I looked at the code (read it many times when I was trying to adapt it to the db to make it work). But I'm still not sure on how do I apply it to specific forms/tables for specific users? I thought it...
  8. M

    Query not combining and filtering values based on a form

    Would you explain how I can use the code to control what users can do? How do I control what permissions are assigned to a user? Example: I opened the db from my home computer and the new user form popped up and I entered my name and it opened the switchboard. I opened the tblUsers and it...
  9. M

    Query not combining and filtering values based on a form

    I deleted it and reopened and the new user form pops up in from of the switchboad. Entered name and pop up goes away. Closed db, reopened and just switchboad shows. So I guess it works correctly, right? But I'm still not following how this is supposed to work? A new user will be able to add...
  10. M

    Query not combining and filtering values based on a form

    I closed and opened it. The switchboard opens and nothing else. The new user form does not open. I’m not following how this works. New users will be able to add themselves to gain access to the db? So how does this restrict access to the db? And how would I be able to assign different...
  11. M

    Query not combining and filtering values based on a form

    I'm sorry, I didn't think of that. Thank you for fixing it for me. So I set the switchboard to open automatically when you open the db and nothing happened. It didn’t load the frmNewUser. It just opened the switchboard. I’m also not entirely sure on how to use it? How does one assign...
  12. M

    Query not combining and filtering values based on a form

    I open the "Switchboard" in design view because if not it gives an error message. And the form name is "frmNewUser". Try not to be mad at me for the lack of any sort of naming convention (or lack there of).
  13. M

    Query not combining and filtering values based on a form

    Oh and I read at the bottom of the page where in Access 2007 it was giving that same error of "Compile Error, Expected: End of Statement" and highlights UserName but I'm using 2010
  14. M

    Query not combining and filtering values based on a form

    Applied new code but it still gives me a "Compile error: Syntax error" and highlights same snippet of code. It also gives "Complie error: Expected:end of statement" and hightlights UserName in same snippet of code. This is what I have: Private Sub cmdContinue_Click() On Error GoTo ErrHandler...
  15. M

    Query not combining and filtering values based on a form

    This is the code that I attempted. I removed the email references and changed the switchboard name to reflect mine but it's not compiling properly. Private Sub cmdContinue_Click() On Error GoTo ErrHandler If Nz(Me.txtFirstName, "") = "" Then MsgBox ("First Name cannot be empty.")...
  16. M

    Query not combining and filtering values based on a form

    OK added the modified code to the On_Load event of my switchboard and deleted the two hidden fields (delete and departmentID) After step 5 there are a couple other pieces of code "a *delete* button, form *On_Current* events and Lock users out of a Menu/Switchboard button" do I need to add any...
  17. M

    Query not combining and filtering values based on a form

    That would be great. Thank you Gina.
  18. M

    Query not combining and filtering values based on a form

    I just got my car back from shop. Timing belt and front brake rotors replaced. Don't even ask how much that cost! :eek: Hope yours is not that much.
  19. M

    Query not combining and filtering values based on a form

    I'm not sure about the log on part. If it can remember a user in order for them not to have to log on every time then that would be fine. But let me find out. Code for the On_Load event: Private Sub Form_Load() On Error Resume Next Dim rst As DAO.Recordset Dim db As DAO.Database Dim myQuery...
  20. M

    Query not combining and filtering values based on a form

    I suppose to log on every time. Because if not, can the program remember a user in order for them not to have to log in everytime (I'm thinking like a cookie or something like that)? I'm not sure what you mean by this? I thought I had read that I needed a tblUsers (with 13 fields uUserID...
Back
Top Bottom