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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by yourdeployedson

  1. yourdeployedson

    formatconditions problem

    Below is my code. It works when I select option 1 or option two it changes my format conditions without a problem. However, I have to manually open the format conditions from the menu bar and click ok for it to actually take affect. I cant seem to make it active automatically. Can anyone...
  2. yourdeployedson

    additional conditional formatting

    I don't know what you mean ???
  3. yourdeployedson

    additional conditional formatting

    I have a form that needs conditional formatting for more than three separate results. The background colors for the boxes need to be as such. CQ needs to be Orange DFAC needs to be red Day Off needs to be grey LNE needs to be yellow R&R...
  4. yourdeployedson

    format an Input box

    I have this input box assword = InputBox("Enter new password:" & vbCrLf & "(Remember that passwords are case sensitive. Check that your CAPS LOCK key is OFF, and if your password contains numbers, that the NUM LOCK key is ON.)", "New Password") I want to format it to show astrics like so...
  5. yourdeployedson

    HELP major code malfunction

    I have this code and i cant seem to get it to work. Right now it stops at the third line. Dim wrkdefault as workspace I don't know why or how to fix it. here is the complete code Private Sub NewPassword_Click() On Error GoTo errorpass Dim WrkDefault As Workspace Dim usrnew As user Dim...
  6. yourdeployedson

    username passwords

    sry, this is an Access database. I forgot to relay that
  7. yourdeployedson

    username passwords

    I would like to add a command button that would allow the current user to change his/her own password. Their passwords are currently locked within the database system features. AKA: Tools--Security--User/Group Accounts Is it even possible to allow them to change their password or do I need...
  8. yourdeployedson

    syntax for password change

    I get an error message that states: Compile error Argument not optional
  9. yourdeployedson

    syntax for password change

    I am trying to make my database easy to use to personnel without much computer knowledge. I want to create a command button that allows the current user to change their password without having to go through the dropdown menus. I can't seem to locate the syntax code that would allow me to do...
  10. yourdeployedson

    expressions in tables

    Ok, is there a way that that the calculations done within a form can save the results within my table. for example form box =DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd")) now I need the result to appear in the table automatically in the appropriate location so I...
  11. yourdeployedson

    expressions in tables

    I have a form that draws most of its information from a table. However, there are a few fields that have expressions in them because they need to do calculations. How can I get the results to save within my table without me having to manually type the result in every time.
See more

Part and Inventory Search

Back
Top