Auto number

  • Thread starter Thread starter Theresa
  • Start date Start date
T

Theresa

Can you create an Auto number field in a custom form?
I have been unable to find any documentation.
Thanks
 
Can you create an Auto number field in a custom form?
I have been unable to find any documentation.
Thanks
Click to expand...
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
 
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 said:
Can you create an Auto number field in a custom form?
I have been unable to find any documentation.
Thanks
Click to expand...
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
Click to expand...
 
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
Click to expand...
message outlookdev.outlookbythesound.com>...
Can you create an Auto number field in a custom form?
I have been unable to find any documentation.
Thanks
Click to expand...
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
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top