Search results

Are all the codes will attempt to take the load event.. Private Sub Form_Load() Me.txtUser.SetFocus Me.txtUser = Environ("UserName") If IsNull(Me!txtUser) Or Len(Me!txtUser) < 1 Then Me!cboEmployee = "" Else select case Me!txtUser case "e09115" Me!cboEmployee.SetFocus...

Hello.. Age ranges can get the best partition function. Use.: Partition(Field_Name, lower_limit, upper_limit, interval) I prepared a sample; please review My English is not very good; maybe i can not understood the question. :rolleyes:

Hi.. The second column contains data, try this way..: ..... ......... ElseIf Me!txtUser = "e09115" Then Me!cboEmployee.text= "User1" ElseIf Me!txtUser = "e05872" Then Me!cboEmployee.text = "User2" ..... ............

select tt.[task id], ( select min([perform at date]) from ( select table_name.[task id], table_name.[perform at date] from table_name where table_name.[perform at date]...

Hello..: iif function with the help can get the totals.. Use should be this way..: Played: sum(IIf([Played Home]=-1;1;0)+IIf([Played Away]=-1;1;0)) with the implementation of the abs function..: abs(sum([Played Home]+[Played Away]))

Hello .. Try this way.. =DSum("Total","AllSales","year([OrderDate]) =year(date())-2 and month([OrderDate])=month(date())-1 ")

Hi.. In Design View, view the Format tab and set Navigation Buttons to No. Add a textbox to the form and the form's current event type of this procedure..: Dim trz As DAO.Recordset Dim recCount As Long Set trz = Me.RecordsetClone With trz .MoveFirst .MoveLast recCount =...

Hello.. In this example, the user is not created yet in our application allows the user to add.. In general, user applications prepared using the table of the user (admin or user) we are already saved to the table.. I use this method, first running the application as Administrator, create...