Auto number

[Theresa]

Can you create an Auto number field in a custom form?
I have been unable to find any documentation.
Thanks

 

[Hollis D. Paul]

Can you create an Auto number field in a custom form?
I have been unable to find any documentation.
Thanks

No, you cannot. An Outlook folder is really not a database table, just
can be manipulated like one in some respects. However, the autonumber
field has never been implemented.

Microsoft has always suggested opening an Access database table
whenever you need a Unique ID value or an autonumber value.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA

 

[Andy]

You could do it from a text file:

'Get the Autonumber from the text file and feed it in to the
Autonumber field also add one so it is updated next time

strFullPath = "C:\test.txt"
Set oFSO=Application.CreateObject("Scripting.FileSystemObject")
Set oFSOFile=oFSO.OpenTextFile(strFullPath,ForReading)
strContent=oFSOFile.ReadAll

arrItems=strContent

Item.UserProperties.find("AutoNumber").Value=arrItems

'Update the number-add one to it
AddOne=arrItems+1
oFSOFile.Close

'Open the file for writing the updated number into
Set oFSOFile=oFSO.OpenTextFile(strFullPath,ForWriting)
oFSOFile.Write AddOne
oFSOFile.Close


You could look up textstream on Outlook VBA help.

Can you create an Auto number field in a custom form?
I have been unable to find any documentation.
Thanks

No, you cannot. An Outlook folder is really not a database table, just
can be manipulated like one in some respects. However, the autonumber
field has never been implemented.

Microsoft has always suggested opening an Access database table
whenever you need a Unique ID value or an autonumber value.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA

 

[kmurphy]

Could you explain how to apply the code below? I would
like to use this.

Thanks!

-----Original Message-----
You could do it from a text file:

'Get the Autonumber from the text file and feed it in to the
Autonumber field also add one so it is updated next time

strFullPath = "C:\test.txt"
Set oFSO=Application.CreateObject ("Scripting.FileSystemObject")
Set oFSOFile=oFSO.OpenTextFile(strFullPath,ForReading)
strContent=oFSOFile.ReadAll

arrItems=strContent

Item.UserProperties.find("AutoNumber").Value=arrItems

'Update the number-add one to it
AddOne=arrItems+1
oFSOFile.Close

'Open the file for writing the updated number into
Set oFSOFile=oFSO.OpenTextFile(strFullPath,ForWriting)
oFSOFile.Write AddOne
oFSOFile.Close


You could look up textstream on Outlook VBA help.

"Hollis D. Paul" <[email protected]> wrote in

message outlookdev.outlookbythesound.com>...

Can you create an Auto number field in a custom form?
I have been unable to find any documentation.
Thanks

No, you cannot. An Outlook folder is really not a database table, just
can be manipulated like one in some respects. However, the autonumber
field has never been implemented.

Microsoft has always suggested opening an Access database table
whenever you need a Unique ID value or an autonumber value.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp? FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA

.