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 Rhinorhino 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. jnp102

    VBA Conditional Formatting

    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
  2. jnp102

    VBA Conditional Formatting

    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...
  3. jnp102

    Logging User activity

    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...
  4. jnp102

    Running a search for a record

    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...
  5. jnp102

    # of Days between 2 Dates

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

    # of Days between 2 Dates

    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...
  7. jnp102

    # of Days between 2 Dates

    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...
  8. jnp102

    User login and limitations

    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...
  9. jnp102

    User login and limitations

    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...
  10. jnp102

    User login and limitations

    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
  11. jnp102

    User login and limitations

    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...
  12. jnp102

    User login and limitations

    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...
  13. jnp102

    Hiding buttons based on Login

    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...
  14. jnp102

    Hiding buttons based on Login

    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
  15. jnp102

    Hiding buttons based on Login

    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...
  16. jnp102

    Multiple Users Question

    Look for some help to see if this can even be done becuase I have exhausted all possiblities that I know of. I have a database with a linked excel doc in it. I have a form with a subform that accesses that linked excel doc. Everything works exactly how it is supposed to but.....I have multiple...
  17. jnp102

    Subform Help

    Thanks for the reply but I couldn't get it to work. I wasn't sure where to put the syntax you wrote. Also, I thought that i would have to reference the option group some way because that is where the subform will be triggered to sort. Thanks.
  18. jnp102

    Combo Box Help

    I have combo box that is based off a table of names. I need the user to be able to select the name and just those records pull up. I have a query with the info in it linked to that combo box, but when I select a name nothing comes up. The problem that I am running into is that the name field...
  19. jnp102

    List Box help

    I have multi-select list box that has two columns in it....last name and first name. I need to create a button that will allow the user, when they select a name or names, to click the button and it show the statistics on that/those names that the user selected. I want the outcome to be produced...

Part and Inventory Search

Back
Top