Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-08-2016, 05:03 AM   #1
THREE05
Newly Registered User
 
Join Date: Dec 2015
Posts: 30
Thanks: 12
Thanked 1 Time in 1 Post
THREE05 is on a distinguished road
If no number entered show msg box?

Hello I have a Form that I use to enter my cases. I want to know on an field if no number is added there to show me a msg with error?
I did check required field on table but would like something more professional.

Field name is "OFF_IF"

Thanks

THREE05 is offline   Reply With Quote
Old 07-08-2016, 05:16 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,487
Thanks: 15
Thanked 4,148 Times in 4,079 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: If no number entered show msg box?

How about:

http://www.baldyweb.com/BeforeUpdate.htm
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Tags
error , msgbox , required

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Only show entered data Infinite Queries 9 04-03-2015 02:35 PM
Parameter query to show all if nothing is entered BCS Queries 2 12-26-2011 06:28 PM
Show only records entered within last month? NewShoes Queries 3 07-24-2011 04:56 PM
Newbie: How to show text after user entered a number? deegee Forms 4 11-10-2003 02:59 PM
[SOLVED] Autoformat telephone number field based on number entered Leoram Forms 1 05-17-2002 09:10 AM




All times are GMT -8. The time now is 01:30 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World