i have rang the debug and the values it is outputting are correct
[Employee_Name]= 'Dave Lucas' And [Date]=#10/02/2009#
If i run the query there is a record created for this person on this date.
i just cant see why it wont work :confused:
I think what your looking for is along the lines of
If Combobox = Option1 Then
Textbox1.Visible = True
ElseIf Combobox = Option2 Then
Textbox2.Visible = True
ElseIf Combobox = Option3 Then
Textbox3.Visible = True
End If
Replace Combobox with the name of your Combobox and replace...
Hi All,
Basically i have a form which consists of
Officer
Line Manager
Employee_Name
Date
The user selects an Officer which then filters the line manager then they select the employee which will then show the dates in a list box which have records for that employee.
They will then select...
Hi guys wonder if anyone can help me...
basically i have with checkboxes on, in the query it calculates how many check boxes have been ticked and what percentage of them have been ticked...
The user then has a drop down box in order to select the text which should appear...
e.g
5...
hi this is the code which i have for the Total Score in the Query
TotalScore: ([QM_1]+[QM_2]+[QM_3]+([QM_4]*+3)+([QM_5]*+2)+([QM_6]*+2)+([QM_7]*+3)+([QM_8]*+3)+[QM_9]+([QM_10]*+3)+([QM_11]*+4)+([QM_12]*+3)+([QM_13]*+2)+([QM_14]*+5)+[QM_15])*-1
Hello Guys,
i've run into abit of trouble
i have a form which has check boxes on which once checked creates a score in a text box below.
Basically the user is allowed to create 6 of these forms for each user this is all setup fine the problem im having is
i need to to be able to sum the...