Avatar of ca1358
ca1358

asked on 

runtime error -2147352567 - cant assign value to this object

This is Access Database using VBA

I get the runtime error -2147352567 - cant assign a value to ths object.

any help would greatly be appreciated.

Private Sub Form_Load()
If Me![Commit] = 0 Then

Commit = Nz(DMax("Commit", "N588888Commit"), 0) + 1

Else
End If
Visual Basic ClassicProgramming Languages-Other

Avatar of undefined
Last Comment
ca1358
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of ca1358
ca1358

ASKER

It didn't work.
Avatar of ca1358
ca1358

ASKER

Thank you!!  It does work!
Visual Basic Classic
Visual Basic Classic

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

165K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo