Unique Text String

[naylo...@my-deja.com]

Group

I am creating an application that will create a unique text string for
each store to a SQL Server 7 database. What I need is the following:

- A user will enter in 4 items and their weights.
- When the user clicks the Store Button, a disabled textbox will create
a unique text string. This text string will always start with the
prefix END (ex ENDxxxxxxxx)
- Ideally this string could be END-DATE-TIME END at 12:01pm (ex
END1201001201.

Anyone have any ideas that can help out a little bit. I guess the most
important part is to get the prefix, date and time to convert to the
format that I need whenever the store button is pressed.

Thank you so much in advance
Bob

Sent via Deja.com
http://www.deja.com/

[nakhob]

use the Date() and Time() functions to get the date and time.

then use the Format() function to get the fields in the correct
format, that is YYMMDD and HHMM. I suggest u you use international
notation for time if you don't want to add pm or am. Otherwise, you
may have duplicates. Convert the date and time fields to string with
CStr().