Recent content by Frank X

Bob: Thanks. I didn't realize it was ANY field. Frank

Bob: I've checked this a hundred times. The field does exist. And it appears to make no difference. I've removed lines of code and yet any reference to any field causes the same error. The first line it fails on is: If rstSAP_SALES1![PKG_FORM] <> "01" Then But when I removed this line...

Bob: Here is the code: Option Compare Database Option Explicit Private Function Conversion() Dim dbsOmya_2 As DAO.Database Dim rstSAP_SALES1 As DAO.Recordset Dim InStrB As String Dim INCO_2X As String Dim strSQL As String Dim Count As Integer Dim i As Integer...

I'm new to Access and Visual Basic and I keep getting the message "Error #:3265 - Item not found in this collection" I've checked and cannot find the problem. If I remove this line of code, the problem happens on the next line. It doesn't seem to recognize the recordset? Can anyone help me...