Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Edit Mode    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
How to handle NEW record
Gary James 
      
4 years ago
Excellent examples of record protection, but what happens when you move to the New Record position.   Do you still require the Edit Button to be pushed?
Richard Rost  @Reply  
           
4 years ago
That's completely up to you. I wouldn't. If they're adding a new record, push it for them. However, I have had clients complain about accidental new records being added all the time... so it's completely up to you how you put your Legos together.
Kevin Yip  @Reply  
     
4 years ago
In my old job I had an "Add New" button (see picture below) -- in addition to all the buttons mentioned in Richard's video: Edit, Save, Cancel, etc.

Also consider using an unbound form for data entry, where all controls on the form (and the form itself) are unbound, and any changes made to the data have to be done with VBA code.  And you don't have to worry about a user locking up a table, because no table is bound to anything.

Making an unbound form is a tall task, since everything has to be done with programming: retrieving data from tables, displaying data, saving, etc.  But if your tables are mission-critical, consider that; it might be worth it.  I did that in my old job.  The forms in my pictures below are all unbound.

If you foresee yourself developing a web interface for data entry in the future, you also need to know how to work with unbound controls, because everything is (often) "unbound" on the web.
Kevin Yip  @Reply  
     
4 years ago

Gary James OP  @Reply  
      
4 years ago
Using VBA Recordsets, how can you detect that you're currently in the New Record position in the Table?
Richard Rost  @Reply  
           
4 years ago
If you want to add a new record in a situation like Kevin suggests with an unbound form, you'll just set the ID to something like 0, and that way when you save the record, your code will know to add it. There's many ways to do it. That's how I would. You could also set a variable like "IsNew" or something. I actually show how to do this exact example in Access Developer 18, which I see you have, Gary. Lesson 4.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Edit Mode.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 4/29/2026 11:45:34 PM. PLT: 1s