Search results

That is one way of doing it. Another way would be: txtBox = "S03-" & txtAutoNumber ' It should return S03-01, S03-02, etc.. :)

Autonumber If I understand it right, in your number - last three digits are to be autonumbered ? for eg: S03-001 S03-002 So 'S03-' part remains unchanged ? If that is the case than why not concatonate lbl"S03-" & "autonumber" ? Maybe somebody else has a better solution. Good Luck ! :)

Appreciate your comments. I am going to go through with the upgrade.Will keep posted if I encounter any issues.Thanks again

I use Access 97 on Windows NT 4.0 platform at work and I use Access 97 on Windows 98 platform at home. VBA Development at home and work have had no problems. Both ways it works fine. My question is that if I upgrade my system at home to Windows XP platform and use Access 97 will there be any...

Thanks ...it worked..sharad

I have a form where there are several dates entered by user. Record date is entered by the user. How do I add 30 days to that date in the next txt Box. Thanks.