Re: Microsft Acces 97 by Anonymous Ghost on December 08th, 2004 09:13:12 AM
Hi - I am new to Access and am having troble configuring my save feature, to save info to a table.
I have defined variables in a module as public. Below is my save function. Under the save button, what do I put as arguments? I tried putting intCallNumber, but get a ByRef type mismatch argument.
Public Sub AddInfo(rstTemp As Recordset, CallNumber, GroupNumber, MemberNumber, CallType, CallDate, ReviewDate, Comments, Points, AgentsName)
With rstTemp
.AddNew
!CallNumber = intCallNumber
!GroupNumber = strGroupNumber
!MemberNumber = strMemberNumber
!CallType = strCallType
!CallDate = strCallDate
!ReviewDate = strReviewDate
!Comments = strComments
!Points = intPoints
!AgentName = strName
.Update
End Sub
Thank you,
Tony |
