Search results

this is not working. Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer) If [job status] = "job complete" Then [GroupHeader1].BackColor = vbBlue End Sub

great ideas! how do i phrase the code to do this in the format event for the header section?

i want the color of the header which these fields reside in to change based on the critera of a specific field with conditonal formatting.

it turns out that i can set the conditional formatting of specific cells to change color based on field criteria, but i still cant get the backcolor or altbackcolor to match when the critera change

it is a contiunous report, and the colors there are blue and red

can anyone help me please? i am still stuck on this issue!

hello access guru's! heres my issue... i have a multi line report with a mess of fields in it. i would like to change the back color of specifically a field, a header, and a group based on the criteria of a field. so for example i tried this... on load if [field] = "word" then...

thanks for following up on this. i have successfully created username and password protection for my database. simple description of my solution: form with username and password entry areas and code behind some buttons to get you logged in based on "access levels" changed accdb to accdr...

hey! any idea whats the problem here? see photo please. thanks!

or it would even be nicer if there was a way for only a single specific user to access all access objects...

hi! can anyone share with me a method to lock all users out of all access objects through a means other than merely hiding the navigation pane? please let me know if this is possible. thanks!

im still failing miserably with this. can anyone help me write/design it?

huzzah! this works.. Private Sub usernameentry_AfterUpdate() If Me.[usernameentry].Value = Me!username Then Me.Check7.Value = -1 End If End Sub now, how to write the part that makes the checkbox unchecked if the statment is not true....

Private Sub username_AfterUpdate() If [me.usernameentry] = Me!username Then Me.Check7.Value = -1 End If End Sub this is not erroring out, but it is also not checking the box

ive renamed my text boxes on the form to: usernameentry and passwordentry

it did not like the addition of txt to username. i am not opposed to remaning/changing things if you have a method that would make this work. i have 4 fields in my table: ID - autonumber username - text password - text access level - number i plan to have 2 text fields in my form: username...

still the same error, new table created with no spaces, and that table is in the forms record source. Private Sub username_AfterUpdate() If Me.username.Value = userinfo.username Then Me.Check7.Value = -1 End If End Sub

still getting an error: run time error 424 object required my code: Private Sub username_AfterUpdate() If Me.username.Value = user info.username Then Check7 = -1 End If End Sub

hi! how do i reference a field in VBA to compare values in an if statement, please help me with the []'s and ,'s and whatnot. my statement should read like: private sub after update if {textbox on form} {is = to or matches text} {field on a query or table} then checkbox = true end if end...

hey trevor! after having played with your login screen, i cant quite get it to do what i want it to do. im just not that adept at VBA. do you have a login program setup to work with a username and password rather than the eviron function? some users will use multiple PC's. for my purposes...