Search results

Thank you all for responding...... I Do Appreciate it. @CJ_London You are right I was missing the "=". How I miss that is a dilemma, but you look at something for hours the simplest things are missing. So " =DMax("[Sample Date]","DDW_Import") works and I can get the show on the road. thank...

As far As I can see/tell they are correct....

It gives me #Name? Error..... DMax("[Sample Date]","DDW_Import")

Hello All, I am trying to use the expression builder to get the latest date in a table in a form inside an unbound text box utilizing DLookUp. Have tried a bunch of different syntax options of the same formula.o_O None are working what am I doing wrong..... Any help is appreciated...

Thanks for the reply this worked =DLookUp("APN","Access_Agreement","Well_ID = '" & [Well_ID] & "'")

Bingo......... cheekybuddha Dam I hate Access's Syntax stuff..... Is there a some white papers that you guys can point me to that tells you when you got to use what and what type of syntax well this works thanks a lot guys...... I really do appreciate this.

Would it make a difference if the form is Build From A Query Vs a table?

It seems to be Okay

Good Question...... I thought that also, Not being very good in terminology I am using the unbounded box in the same form I am doing the Dlookup. The form is tabbed form

Opps, Sorry I missed that One but still same error #Name?

Well_ID is a String

Hello bob fitz..... Thank for joining in...... see below

theDBguy - The_Doc_Man I do appreciate the help..... theDBguy you are right I am using the unbounded in a form to pull info from another table..... Here the versions I tried & get the same error. =DLookUp([APN],[Access_Agreement],"[Well_ID] = ' " & [Me].[Well_ID] & " ' ")...

Thanks for the quick reply..... I tried =DLookUp("APN","Access_Agreement","Well_ID = '" & Me.Well_ID & "'") I get the #Name? error. I did check the Control Source in the form and it is Well_ID, I am not sure if it make a difference or not by the expression builder automatically add [] to...

Hello All, I am trying to pull a number(Not string) from a form I am working on. I think my issue is syntax but can't figure this out and I have tried several version all ending up in #Error Domain = Access_Agreement expression = APN (number) criteria = lookup from a field from the form...

Oh.... I got it...... Never mind it works perfect......... Thank you all Left([T_lab_anl_method_name],Len([T_lab_anl_method_name])-1) & " " & Right([T_lab_anl_method_name],1)

What if the length varies, i.e Book Door Sliding Door Jam

Thank you for the response.....Tried Left([T_lab_anl_method_name],-1) & " " & Right([T_lab_anl_method_name],1) it gives me can't update all the records violation error. but if I take the negative out it works but the result is not what i was aiming for. Ardy

Hello All, I am trying to construct a update Query to add a space right before the last character. but am having a hard time:banghead:.... can anybody point me to the right direction. Example: Book Door Sliding Door Jam Should look like this after the Query Boo k Doo r Sliding Doo r Ja m...

sxschech, Thanks a bunch man....... Right on the point.....So simple......Thank you