Hello:

I have a IDNumber field that I wish to use a query to insert a sequential increasing individual alpha numeric character into each row.

I do not wish to use the AutoNumber generator.

Example:
CAL00001
CAL00002
....
....
CAL00700

Any ideas if this can be done.

Glen

Call Shell(explorer.exe & thePath, vbNormalFocus) opens the Windows folder
with pathname thePath.

My trouble is the folders I'm trying to open have a comma in their name, as:
thePath = "C:\My Documents\firstword, secondWord"

With that stinking comma in the path, Call Shell(explorer.exe & thePath,
vbNormalFocus) doesn't open the folder, it fails, and gives an alert: 'The
path 'secondWord' does not exist or is not a directory'.

Is there a fix? (There are thousands of folders, so taking the comma out of
the folder names isn't a practical option.)

GAKane