Solved

Check if all fields in new row are filled (datasheet view)

Posted on 2013-07-01
1
448 Views
Last Modified: 2013-07-01
Hi there

I have a form with datasheet view and I need to make user that user fills in all fields before he moves on to the next row.
Any idea how to catch the moment of moving to another row?
0
Comment
Question by:yahooooo
1 Comment
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
Comment Utility
Use the Before Update event of your form.


Private Sub Before_Update(Cancel as Integer)
       if "" & Me.Field1 = ""  OR  "" & Me.Field2 = "" OR "" & Me.Field3 = ""  OR "" & Me.Field4 = "" then
               msgBox "Please enter data in all fields"
               Cancel = True
        end if
end sub

Open in new window

0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now