Generating Random Order Number

[Guest]

I need to create a random automatic entry that consists of 2 letters and 6
numbers.

The letters and numbers need to automatically change on every new field but
the 2 letters need to prefix the numbers i.e

mk123456
ab798794
ud903398

etc....

Can anyone help as I think the only way to do this is with VB code?

Thanks

 

[James A. Fortune]

I need to create a random automatic entry that consists of 2 letters and 6
numbers.

The letters and numbers need to automatically change on every new field but
the 2 letters need to prefix the numbers i.e

mk123456
ab798794
ud903398

etc....

Can anyone help as I think the only way to do this is with VB code?

Thanks

I did something similar to this once. See:

http://groups.google.com/group/comp.databases.ms-access/msg/74ee550e77af8209

Also, check to see if that thread has some VBA solutions. Entire thread:

http://groups.google.com/group/comp.databases.ms-access/browse_frm/thread/b2ce2aecb417e60a

James A. Fortune
(e-mail address removed)

 

[Guest]

I will try this and let you know.

Thanks

I did something similar to this once. See:

http://groups.google.com/group/comp.databases.ms-access/msg/74ee550e77af8209

Also, check to see if that thread has some VBA solutions. Entire thread:

http://groups.google.com/group/comp.databases.ms-access/browse_frm/thread/b2ce2aecb417e60a

James A. Fortune
(e-mail address removed)