T
Theresa
Can you create an Auto number field in a custom form?
I have been unable to find any documentation.
Thanks
I have been unable to find any documentation.
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Hollis D. Paul
No, you cannot. An Outlook folder is really not a database table, justCan you create an Auto number field in a custom form?
I have been unable to find any documentation.
Thanks
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]
[email protected]
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
A
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.
'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:No, you cannot. An Outlook folder is really not a database table, justCan you create an Auto number field in a custom form?
I have been unable to find any documentation.
Thanks
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]
[email protected]
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
K
kmurphy
Could you explain how to apply the code below? I would
like to use this.
Thanks!
like to use this.
Thanks!
message outlookdev.outlookbythesound.com>...-----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
.No, you cannot. An Outlook folder is really not a database table, justCan you create an Auto number field in a custom form?
I have been unable to find any documentation.
Thanks
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]
[email protected]
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