Search results
-
M
Query not combining and filtering values based on a form
Wow Gina, you do some really amazing stuff! That's way way way way over my head, but amazing neither the less. I'll just stick to plain old 2 or 13 for now :) I know I've said it before but you really know your stuff. I'm so grateful and appreciative that you decided to help me. To say I... -
M
Query not combining and filtering values based on a form
Oh I see. I understand. Do I have an ADMIN section? Do I need to have one? So if I'm set at 2 - read/write then I can't add values to Combo boxes? Meaning can I pretty much do as I please with the forms if I'm a 2? Or do I need to change to a 13? -
M
Query not combining and filtering values based on a form
I don't understand what you mean by this? Actually, wait a minute now that I try, I can't make any entry in any of the forms?! Or make a selection from a combo box or make any entry in a text box. But when I change my SecurityID to 2 I can make entries! Cool! So I guess that part works. But... -
M
Query not combining and filtering values based on a form
Just deleted one of the entries. Didn't make a difference, I can still alter any of the forms. -
M
Query not combining and filtering values based on a form
Yes it's in there twice. Same name but one from work and one from home computer. Does that make a difference? Should I delete one? Both are set to 9. -
M
Query not combining and filtering values based on a form
Ooohhhh! Okay. This whole time I thought the other forms needed to show 9 as well :o I'm a little concerned as to why I'm still able to alter anything on a form (delete/add fields). My SecurityID is set to 9. -
M
Query not combining and filtering values based on a form
We're talking about other forms not the switchboard, right? bc the switchboard shows 9. But I'm talking about the other forms. They aren't showing anything in the txt box even after I compact and repair. -
M
Query not combining and filtering values based on a form
Oh jezz, I'm a dingbat. Sorry. Changed the code in all the forms to what you have listed. But txtSecurityID is still blank? No #9. -
M
Query not combining and filtering values based on a form
No, the 9 is showing on the switchboard when I open the other forms. Hmm... maybe I applied the code incorrectly (very possibly I did)? Would you like to take a look for me? I've applied the code to most (not the hidden forms) in the db. I kept txtSecurityID visible to be able to check... -
M
Query not combining and filtering values based on a form
No the switchboard is still open when I open the other forms. -
M
Query not combining and filtering values based on a form
No, no this is on another form (frmAffiliateNameAndRegion). I was trying to apply the On_Current code to all the other forms and started with frmAffiliateNameAndRegion (no subform on it). But like I said the txtSecurityID field is blank. My name is still in the table with a 9. On the... -
M
Query not combining and filtering values based on a form
Ok so this is an example of the On_Current event code in one of the forms: On Error Resume Next If Forms![frmAffiliateNameAndRegion]![txtSecurityID] = 9 Then fncLockUnlockControls Me, True Else fncLockUnlockControls Me, False End If But when I check the txtSecurityID field (made it visible... -
M
Query not combining and filtering values based on a form
So this is the code that I put in the On_Current event in all my forms that I want to apply permissions to: Private Sub Switchboard_Current() On Error Resume Next If Forms![Switchboard]![txtSecurityID] <> 13 And Forms![Switchboard]![txtOverride] = False Then fncLockUnlockControls Me, True... -
M
Query not combining and filtering values based on a form
I was trying to alter the design of the form, move things, delete things. My SecurityID is 9 in the table and 9 is showing in the text box. (Which reminds me would I also need to put those 4 hidden text boxes in every form I put the code in?) -
M
Query not combining and filtering values based on a form
I'm still able to alter the form. Am I doing something wrong? -
M
Query not combining and filtering values based on a form
I'm really sorry. I thought I was to copy the whole piece of code. I didn't know I was only to copy the bottom part. I'm sorry. I put in the code you just gave me. But it still lets me alter the form. I must me doing something wrong. I'm sorry to be causing you so much trouble. Thank you... -
M
Query not combining and filtering values based on a form
Yes. This is what I have for the code: Private Sub Form_Current() On Error Resume Next If Forms![Switchboard]![txtSecurityID] = 9 Then fncLockUnlockControls Me, True Else fncLockUnlockControls Me, False End If End Sub Private Sub Switchboard_Current() On Error... -
M
Query not combining and filtering values based on a form
Maybe when I first made the table I just put in the values and didn't think about the numbers. But since then I have changed the table to look exactly the way you have yours. 2 for Read/Write, 9 for Read only and 13 for ADMIN. But that's weird bc now I just tried opening the db and I see a 9... -
M
Query not combining and filtering values based on a form
No, nothing is in the text box when I made it visible -
M
Query not combining and filtering values based on a form
Hidden in the switchboard I have txtSecurityID, txtOverride, txtUserID and txtPassword. I'm not sure where I would see a 9. In design view for txtSecurityID it says unbound.