 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / January 2006Convert the code
I need to Convert the code from a text field to code for a number field: If Me.SpecificResultCode = True Then If stLinkCriteria <> "" Then stLinkCriteria = stLinkCriteria & " and " stLinkCriteria = stLinkCriteria & "[dbo_customers.QuitCode] = " & "" & (Trim(Me.SpecificResultCode)) & "" End If Thanks I got it: If Me!ChooseResultCode = True Then If stLinkCriteria <> "" Then stLinkCriteria = stLinkCriteria & " and " stLinkCriteria = stLinkCriteria & "[dbo_customers.QuitCode] = " & ((Str(Trim(Me![SpecificResultCode])))) End If > I need to Convert the code from a text field to code for a number field: > If Me.SpecificResultCode = True Then [quoted text clipped - 3 lines] > End If > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.