Search results

hmm maybe it's missing the If the ID isn't listed in the tag, then ctl.Enable = False ?

Thanks guys for the ideas, but unfortunately neither of those solutions worked. On this one particular page, there are 7 buttons. cmd1A1 tag: 1, 7, 8, 9 cmd1A3 tag: 1, 7, 8, 10 cmd1A4 tag: 1, 7, 8, 11 cmd1A5 tag: 1, 7, 8, 12 ... and so on could it be I should use a semi-colon instead of...

I was provided code to allow Access to read multiple tags to allow access to certain command buttons within my database: Private Sub Form_Open(Cancel As Integer) Dim ctl As Control 'Users 1 and 7 have access to all buttons If UserAccessID = 1 Or UserAccessID = 7 Then For Each ctl In...

oh and almost forgot to mention... in my Users set-up I have AccessViews that allows basic edits/adds of data in records (within my forms) and I have User Access Levels (will be at least 50 by the time I finish) that allows each user to access their section of the database. (hence the tag...

Thanks so much to both of you, for your replies... somehow I missed the notifications about this thread in my email. Currently I have this code entered in both Form_open and Form_current:Private Sub Form_Open(Cancel As Integer) Dim ctl As Control 'Users 1 and 7 have access to all buttons If...

Same for me, I had even opened up another thread bc I couldn't find it... then I came across your post FINALLY! lol thanks!

Great news for anyone looking for this answer!! When in conditional formatting, you have to set the default formatting as well (it's not automatically done for you)! Awesome!

SOLVED--SEE BELOW TRAFFIC & & Hi everyone, I am trying to accomplish null values being changed to red in my report. I used the above quoted advices that I found through my searches, but the cells don't highlight unless the mouse is clicked on it. (whereas I was hoping they would...

Hi guys, I am trying to accomplish the same thing in my report: To highlight null valued fields. I used the advice you gave as quoted above, but the cells don't highlight unless the mouse is clicked on it. Is there a different approach needed for Access 2007 to get the background to change...

Thank you for that, it worked perfectly to filter out only the records that had missing information. My apologies for the confusion on the second part. Basically I was asking how to then calculate only the null fields when I do the "count" feature in a report. I count each field by using...

I've created a query with intentions to only allow a record to show if it has a null value in any (or more than one) of 6 fields. I tried intering 'Is Null' in the or section of the query's design view, but I didn't receive the results I was looking for... does anyone know how to do this...

Here's another suggestion: it's where you tag which users can open which cmd buttons, otherwise they'd be greyed out and unclickable http://www.access-programmers.co.uk/forums/showthread.php?t=212671

I completely forgot I can select no in the visible property. Using the groups total worked perfectly! I can't believe what an easy solution took me forever to get ! lol... Thanks for your suggestion it was MUCH appreciated :D OH and almost forgot to mention (in case others are searching this...

My apologies for asking a needless question, I just tried it and it worked woot! :D

I'm signed in as admin which is ID 1. yes I noticed and in my example a few posts above I changed the button names to my own, thank you.Private Sub Form_Open(Cancel As Integer) Select Case User.AccessID Case 1, 7, 8 Me.Cmd1A1.Enabled = False Me.Cmd1A3.Enabled = True...

So it's my understanding that you cannot input more than one tag into a cmd button's properties. I came across the idea of setting up a table of parameters for the tag to direct to though. Does anyone know how to set that up or perhaps have a better solution?

I think you may just laugh at me!!! I was playing around with some things trying to fix the error I kept getting from the post before this and found out... the system logged me out so the userId was zero and that's what was giving me the error! Well I just found another task to tackle (how to...

I had changed what u presented to mine: Dim ctl As Control 'Users 1 and 7 have access to all buttons If User.AccessID = 1 Or User.AccessID = 7 Then For Each ctl In Me.Controls If ctl.ControlType = acCommandButton Then ctl.Enabled = True End If Next Else...

hahaha OH! I definitely didn't catch that lol... I suppose I hadn't noticed anything bc I logged in only as the accessID 1 which is granted all access as an admin and then logged in as no accessID used (not logged in for example) thus far. Thanks for those words of knowledge :) ----You know...

Arggg... I am not getting a case selection to work either. There aren't any errors popping up however, the "false"'s that I've been trying don't work. Maybe i have to point to the AccessID's table where the user.accesID's are coming from? Private Sub Form_Open(Cancel As Integer) Select Case...