about d function

  • Thread starter Thread starter rudwan
  • Start date Start date
R

rudwan

i have in a form . unboudtext box , i made its countroul
source as
DLast("[SalAmount]", "Salary", "[EmpNumber]=" & Me.EmpID)
but it gives me #name error .
i checked the names well , i found it correct , no
mistakes in names , to be sure , i copied the same formula
and paste it at another text ( text_afterapdate ) it give
me a correct result .
what can i make to get the accurate result ?
 
In the control source property you must precede the expression with an = sign:
= DLast("[SalAmount]", "Salary", "[EmpNumber]=" & Me.EmpID)
 
Try:

= DLast("[SalAmount]", "Salary", "[EmpNumber]=" & [EmpID])

including the equal sign at the beginning. Note that I removed "Me" at the
end. This assumes [EmpNumber] is a Numeric Field.
 
i did already , but it refuse the equation with " = " , it
sent me message that you have entered wrong expresion




-----Original Message-----
Try:

= DLast("[SalAmount]", "Salary", "[EmpNumber]=" & [EmpID])

including the equal sign at the beginning. Note that I removed "Me" at the
end. This assumes [EmpNumber] is a Numeric Field.

--
HTH
Van T. Dinh
MVP (Access)



i have in a form . unboudtext box , i made its countroul
source as
DLast("[SalAmount]", "Salary", "[EmpNumber]=" & Me.EmpID)
but it gives me #name error .
i checked the names well , i found it correct , no
mistakes in names , to be sure , i copied the same formula
and paste it at another text ( text_afterapdate ) it give
me a correct result .
what can i make to get the accurate result ?
Click to expand...


.
Click to expand...
 
i also fail to use = , it sent me message that i used
invalid syntax


-----Original Message-----
In the control source property you must precede the expression with an = sign:
= DLast("[SalAmount]", "Salary", "[EmpNumber]=" & Me.EmpID)


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com



i have in a form . unboudtext box , i made its countroul
source as
DLast("[SalAmount]", "Salary", "[EmpNumber]=" & Me.EmpID)
but it gives me #name error .
i checked the names well , i found it correct , no
mistakes in names , to be sure , i copied the same formula
and paste it at another text ( text_afterapdate ) it give
me a correct result .
what can i make to get the accurate result ?
Click to expand...


.
Click to expand...
 
Did you remove the "Me." as per my post?

--
HTH
Van T. Dinh
MVP (Access)



rudwan said:
i did already , but it refuse the equation with " = " , it
sent me message that you have entered wrong expresion




-----Original Message-----
Try:

= DLast("[SalAmount]", "Salary", "[EmpNumber]=" & [EmpID])

including the equal sign at the beginning. Note that I removed "Me" at the
end. This assumes [EmpNumber] is a Numeric Field.
Click to expand...
Click to expand...
 
yes , it didnot accept any expresition starting by " = "
-----Original Message-----
Did you remove the "Me." as per my post?

--
HTH
Van T. Dinh
MVP (Access)



i did already , but it refuse the equation with " = " , it
sent me message that you have entered wrong expresion




-----Original Message-----
Try:

= DLast("[SalAmount]", "Salary", "[EmpNumber]=" & [EmpID])

including the equal sign at the beginning. Note that I removed "Me" at the
end. This assumes [EmpNumber] is a Numeric Field.
Click to expand...
Click to expand...



.
Click to expand...
 
Post the latest expression you used and explain each term in the expression,
especially where it comes from.

" = " sign works perfectly in my databases. The problem is the expression
which Access somehow doesn't recognise it as a valid expression.
 
Back
Top