UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Closed TopicStart new topic
> Run Time Error 2448, Access 2013    
 
   
Alialas
post Feb 25 2018, 12:05 AM
Post#1



Posts: 9
Joined: 24-February 18



I have a control in a subform that should be calculated in VBA code , it had a (number) data type on the source table and the subform is going on a recordset , it keeps giving me a 2448 run time error and do not calculate ( Me!AB.Form!mark1.Value = b * Me!AB.Form!nom1.Value / c
) the code is as follow
Private Sub Command13_Click()
Dim a As Integer
Dim b As Integer
Dim c As Integer
a = DLast("nom", "main")
b = (100 / a)
Dim DB As DAO.Database
Set DB = CurrentDb
Dim rs1 As Recordset
Set rs1 = DB.OpenRecordset("sub")
Do While rs1.EOF = False
rs1.Edit
c = DLast("nom1", "sub")
Me!AB.Form!mark1.Value = b * Me!AB.Form!nom1.Value / c
rs1.Update
rs1.MoveNext
Loop
End Sub

==============================
Please do NOT cross-post. It does not improve chances of getting an answer and can be confusing.

This post has been edited by GroverParkGeorge: Feb 25 2018, 08:22 AM
Reason for edit: Closed second post
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th December 2018 - 09:36 AM