I am writing a program to search contracters and job numbers
If you misspell the name it doesn't find anything. You can search by last name, contractor, job number, and job site.
When switching to search for job number I want the files to be in order by job number so I have the following code:
Private Sub AdojobnumAdo()
frmcontract.Adobuilder.RecordSource = "select * from_ _ tbljobinfo order by fldjobnum"
frmcontract.Adobuilder.Refresh
End Sub
Now I just want it to return the closest job number to it
Example if I search for job number 1255 and there is no job 1255 it returns 1254.
Please Help - Thanks Matt
If you misspell the name it doesn't find anything. You can search by last name, contractor, job number, and job site.
When switching to search for job number I want the files to be in order by job number so I have the following code:
Private Sub AdojobnumAdo()
frmcontract.Adobuilder.RecordSource = "select * from_ _ tbljobinfo order by fldjobnum"
frmcontract.Adobuilder.Refresh
End Sub
Now I just want it to return the closest job number to it
Example if I search for job number 1255 and there is no job 1255 it returns 1254.
Please Help - Thanks Matt