MS Access creating a task number

  sat481 15:45 03 Feb 2005
Locked

Hi there..

I'm having a small problem with Access. I want to create a task number that is made up of the year and and auto-incrementing number. I have designed the form and every thing else work fine except this. I have tried having to fields ,year and Number, but when I try can to combine them i hit problems.. I've tried expression builder, and Code builder both to no avail. So any advise greatly accepted.

Sat481

  sat481 16:33 03 Feb 2005

I finally solved the vb code way. The problem was that I had to have the task number as a text field, and the vaules I were trying to add were a date and a integer. I converted these to strings and it worked fine.

Sat481

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?