Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GoAutoWay

    SImple SQl statement help!

    I need CIR.vendor to be distinct. here is the code that does not use distinct. I can't just stick dinstinct row or distinct in there because there is a different index number for each row. This is for a listbox on a form. SELECT CIR.Vendor, CIR.index from CIR ORDER BY CIR.Vendor;
  2. GoAutoWay

    I need to lock fields in a form by user

    OK, this thing is still not working. This is where the code stands right now... For Each ctl In Me.Controls If Len(ctl.Tag & "") <> 0 Then 'check for ABCD user role ctl.Enabled = strLevel <= ctl.Tag 'Enable based on user role If Right(ctl.Tag, 1) = "N" And Left(ctl.Tag, 1) >= "B" And Not...
  3. GoAutoWay

    I need to lock fields in a form by user

    I also realize the last line should be If Not IsNull ctl.locked Again, I have killed my brain today and the logic and syntax needs help! thanks!
  4. GoAutoWay

    I need to lock fields in a form by user

    First I will answer your questions. By some fields in the form I mean there are a few fields, that should allow C level users to input the initial data, but not change it. Admins sould bbe the only one that can change it. This does not apply to all of the field I am restricting so your left and...
  5. GoAutoWay

    I need to lock fields in a form by user

    I have one more twist that has been added. For some fields in the form, that are available for A,B,and C levels, I need to check to see if the field has a value, if so, lock it except for Admins (A). I have poked around with this code today, but just haven't put it together correctly. I'm...
  6. GoAutoWay

    I need to lock fields in a form by user

    I know we jumped to the GetRole function, but I was actually learning and understanding you based on the baby steps you were doing (thanks). You left off with my security levels being A,B,C and D. This is correct. I realize the on open code will use the getrole function to return the users...
  7. GoAutoWay

    I need to lock fields in a form by user

    I know this is something I SHOULD be able to fgure out, but the previous code is blowing chunks @ ([Security Level] FROM It says compile error: List separator or ) expected. Thanks, GoAutoWay
  8. GoAutoWay

    I need to lock fields in a form by user

    Well, Ace, yes, that would make sense! It's the only missing link here... Duane, that is acceptable. It is exactly what I'm trying to accomplish. I need the Getrole() function though... Thanks, Toby
  9. GoAutoWay

    I need to lock fields in a form by user

    Yes, The table name is employee The fields are: UID, First Name, Middle Name, Last Name and Security Level. Security levels are A,B,C and D. There are many fields in the form that will be locked based on UID and Security Level, at least that is the goal. I do know which fields should be at...
  10. GoAutoWay

    I need to lock fields in a form by user

    Yes, I used the code listed in the previous threads link to grab the login. I also have a table called employees with the logins and security from A Admin B Manager C User D Read only. Obviously I'm willing to change the table around if I can just get this last part going. I know I'm so close...
  11. GoAutoWay

    I need to lock fields in a form by user

    thread702-1609388 I'm trying to lock certain fields in a form based on user login and a table created withh user and security levels. I think the above thread would work but I am new to VB and Access and I do not have the GetRole() function. I am assuming this is user defined?? Thanks, Go

Part and Inventory Search

Back
Top