I wonder why ppl nowadays so particular with the word 'portrait' & 'macro'.

Any lens which has short minimum focus distance can be use to shoot macro.
Only difference would be magnification & sharpness (which is hardly visible for 8R & below).

Any lens which can produce sufficient bokeh can be use to shoot portrait. Why 85mm & 100mm or 105mm are usually called portrait lens?

It's bcos the focal length in original FF gives a comfortable & desirable distance between the photographer & model. So that both won't feel awkward or shy.

Anyhow, if you want the best of both world for under RM1k, I'd suggest the Tokina AT-X M100 AF Pro D (used) or its earlier variants.

After focal length conversion in dSLR, it becomes 45mm.
Neither here nor there.

I don't know what body Scotty's using now.

But he did post up "[wtb] nikkor 85mm f1.8 or 50mm f1.4 or tamron sp90 macro" at another photography related forum. Which none of them has a built in focusing motor.

So back to your question. For D40/D40x, any lens without AF-S or HSM would only give you manual focus.