If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Overflow
Why does the last line in this code lead to the error message
"Overflow"? The figure in question is 33764 which is the value of txtPhotoID before trying to assign it to intPhotoID. If I declare intPhotoID as String, then all is well Dim intPhotoID As String Dim intProjectTeacherID As Integer Dim strActivity As String Dim strSequence As String Dim strProfile As String Dim DB As Database Dim RST As Recordset Set DB = CurrentDb Set RST = DB.OpenRecordset("tblProjectTeacherPhotoLNK") intPhotoID = Me.txtPhotoID |
#2
|
|||
|
|||
Overflow
anthony wrote:
Why does the last line in this code lead to the error message "Overflow"? The figure in question is 33764 which is the value of txtPhotoID before trying to assign it to intPhotoID. If I declare intPhotoID as String, then all is well Dim intPhotoID As String Dim intProjectTeacherID As Integer Dim strActivity As String Dim strSequence As String Dim strProfile As String Dim DB As Database Dim RST As Recordset Set DB = CurrentDb Set RST = DB.OpenRecordset("tblProjectTeacherPhotoLNK") intPhotoID = Me.txtPhotoID The range for integers is -32.768 tot 32.767. -- Groeten, Peter http://access.xps350.com |
#3
|
|||
|
|||
Overflow
Use 'Long' not integer,
Dim intPhotoID As Long anthony wrote: Why does the last line in this code lead to the error message "Overflow"? The figure in question is 33764 which is the value of txtPhotoID before trying to assign it to intPhotoID. If I declare intPhotoID as String, then all is well Dim intPhotoID As String Dim intProjectTeacherID As Integer Dim strActivity As String Dim strSequence As String Dim strProfile As String Dim DB As Database Dim RST As Recordset Set DB = CurrentDb Set RST = DB.OpenRecordset("tblProjectTeacherPhotoLNK") intPhotoID = Me.txtPhotoID -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 |
#4
|
|||
|
|||
Overflow
On May 25, 8:55*pm, XPS35 wrote:
anthony wrote: Why does the last line in this code lead to the error message "Overflow"? The figure in question is 33764 which is the value of txtPhotoID *before trying to assign it to intPhotoID. If I declare intPhotoID as String, then all is well Dim intPhotoID As String Dim intProjectTeacherID As Integer Dim strActivity As String Dim strSequence As String Dim strProfile As String Dim DB As Database Dim RST As Recordset Set DB = CurrentDb Set RST = DB.OpenRecordset("tblProjectTeacherPhotoLNK") intPhotoID = Me.txtPhotoID The range for integers is -32.768 tot 32.767. -- Groeten, Peterhttp://access.xps350.com Ah, silly me. Many thanks |
Thread Tools | |
Display Modes | |
|
|