Recent content by jnp102

Sorry about posting in the wrong place, I just saw the others in here with VBA and went with it. I made that small change and it works great!!!! I didn't even think about that!!!! Thank you so much Tony Jeremy

Hey everyone! Got a quick question about VBA Conditional Formatting. With help from other posts, specifically from xlbo, I put the following into the worksheet.... Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim oCell As Range If Not Intersect(Target, Range("C8:T145")) Is...

Hi all, Had a question about grabbing the workstation logon ID and 1, putting it with a time stamp in a table and then 2, using it to track what changes have been made to the data. Currently my database opens to a form where people can enter/edit data. This form also pulls the workstation id...

Hi All, I'm kind of in a bind here and hoping that you guys can help. I have a form that lists 2 pieces of info from one table and I want to be able to have either a button or something out to the right of each line to find a record on another form. Let me explain another way.....So...

Bob, That's perfect, I appreciate the quick reply to this post. I think that this will help tremendously. Thanks again jnp102

Bob, To answer questions (I hope) I have a table that has 2 dates and a days field. Now on the form I have the three text boxes that are bound to the fields in the table. However, when I do Michael's code he has you put =DeltaDays([start],[end]) in the control source. So currently, to get the...

Hi All, Just had a quick question about how to do this. I read MichaelRed's FAQ181-261 (by the way thanks for the great FAQ!) on how to do this and I can get it to work perfectly. However, I want to add one last twist in it and I just can't seem to get it to work for me. The text field that...

PHV, Ok, sorry, I should have known that I just wasn't thinking about it. Anyway, it still did not work which ok for now, I've went another route because I have to have something soon. No matter if I had someone as admin or super the button was not hiding. However, if anyone comes up with...

sillysod, I tried to put that in there but I get an error when I go to the next line down "Compile Error: Must be first statement on the line" and the following line is in red.... Else If Nz(grp) = "Super" Then Maybe I'm just missing something but I can't get it to happen for me. Any other...

PHV, I changed the code to what you have and it still just "kind of works". Now it takes the first If statement and just holds it true for everyone that logs in. So basically it looks like it is not reading the second statement at all. Any other suggestions? Thanks jnp102

That would be nice to keep track of some of that stuff but I need the validation part of it. However, if you could....explain the nesting of the "ifs" a little further if you could. The interesting part about what I have already is that it seems like it is just looking in the table to see if the...

Ok, I've got this partially working but can't get it the rest of the way for some reason. I have a login form that has a drop down menu with everyones user id in it, then a password field to input their password. I already have the validation code set and that works fine. Where my problem lies...

Bob, Thanks for that info. It looks like it will work the way I need it to but there are two things that I am having a problem with. The first, is that I can not use the workstation ID method. I would love to, but can't. So I would imagine that I need the form to store the userid info...

That's great info! What if I would want it based off of the access level. So basically when they login it checks the login table and sees the access that they have and then limits the what they can see from there. any help in the right direction would be great. jnp102

Hi everyone, I'm in a bit of a bind and have read through many many threads looking for an answer. I see people talk about it but can not get it done for some reason. I have a database that users log into. This info is from a table where I have the username, password and access level. This...