Convert the code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting to excel from access using filter 1
Help with opening a form to a specific record 7
Code not working 2
Run time error 2494 1
Change view to Pivot Table, Please Help 3
proper after ujpdate code to populate form 2
Search Form 2
Passing Two Argument in OpenFrom 4

Back
Top