[ms_access] Leading zero problem

2010-02-27 Thread Perry
I am using MS Access 2000. I have a text field that contains data similar to this: LONDON 1 LONDON 2 PARIS 3 AMSTERDAM 1 For some strange reason, any entry containing the number '1' acquires a leading zero, resulting in LONDON 01, LONDON 2, PARIS 3, AMSTERDAM 01. The number of letters varies,

[ms_access] Pass parameter to message box?

2010-06-20 Thread Perry
is in the drive, do nothing, otherwise open a mesage box requesting (for example) DVD 3 be placed in the drive. Thank you. Perry