Recent content by yourdeployedson

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

I don't know what you mean ???

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

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

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

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

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

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

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

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

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.