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 |
Thread Tools | |
Display Modes | |
|
|