Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Developer Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Purchased Access 2019 Bible
Nathan Shepard 
      
2 years ago
I recently purchased Microsoft Access 2019 bible.  the book is 1091 page long.  Its very complicated.  I really do not like macros.  They work then don't work.  I purchased this based on Richard's recommendations.  He forewarned me that it was a complicated book.  I have no regrets in purchasing it.

The one thing I was looking to find in it was the coding for the following:

1. add a record.
2. Closing a form
3.  select a record from continuous form load a form to edit it.
4.  select a record from continuous form and display it in a form.

I did find on page 932 adding a new record and deleting a record.  Per Richards's advice my application does not delete records .  I will be archiving them. Very complicated.  Richard's code is simple.

Now I believe in the school of hard knocks!!!.  Any one with advice that can point me in the right direction to code to to do the 4 items listed above.  I thank you.
Adam Schwanz  @Reply  
           
2 years ago
I'm assuming you're talking with VBA.

1. Can be done multiple ways, usually though with a recordset or SQL statement.
RunSQL v Execute
Access SQL Seminars
CurrentDB.Execute "Insert Into Table (MyField) VALUES (" & MyVariable & ")"

2. Close Form

3. Search Form 2.0

4. Same as 3, just disabled Editing if you only want them to display.
Disallow Editing Data
Edit Mode
Richard Rost  @Reply  
          
2 years ago
Yeah, the Access Bible is one of the best books out there... but it's no match for a good TechHelp video. LOL.
Richard Rost  @Reply  
          
2 years ago
John Davy  @Reply  
         
2 years ago
Hi Nathan
I think you have jumped too far. What you are looking to is easy and doesn't require the 'Bible' although you will get much use out of it. Watch Rick's videos and observe how he adds a record. It often depends on the situation and/or form but can be very easy. To close a form one can simply place a button the form, give the button a name and add 1 line of VBA such as
DoCmd.Close acForm, "LabelF"       to close my form named LabelF, to select a record from a continuous form  can be as easy. Show us what you want to do - be specific with Form names and button names and we will help you. Watch Richard's videos

John
Thomas Gonder  @Reply  
      
2 years ago
@Nathan I purchased Access 2019 Programming by Julitta Korol, hoping to get lots of tips from 1000+ pages. I spent four whole days trying to figure out the Big Picture, for doing many of the things you described. That was three years ago. Doing any one small thing is pretty easy. Getting it all to work together is an engineering nightmare. Mostly because Access keeps getting in the way of anything and almost everything if you're trying to make a comprehensive package that looks "professional" and is easy for the user to navigate. I've got so much code, far more complicated than I ever imagined would be needed, to present an UI that took me about six months to design and code from scratch in my old RAD forty years ago. I've been wrestling Access to the mat for three years now, and every day is a new adventure. Every Access update a complete QC redo.

Look here for my (humble?) idea of how Access could work: Forums>Access Template Marketplace>Advanced Development Shell
Nathan Shepard OP  @Reply  
      
2 years ago
A Special Thank you!!! to Adam for providing those commands.  As I look at them.  I believe you responded to this question the last time.
Richard  I thank you for responding.  Yes, TechHelp do wonders for learning.  Yes, 2019 Access Bible is a reference book.  After all the techhelps and the searching I am deficient  in how to add a record, Selecting a record from a continuous form and either editing or displaying it.  Finally closing a form.

I noticed that if you have two many forms open that the some of my buttons do not work.  

Now, I believe in the school of hard knocks.  When I tough in Middle school.  So times I would try to instill a desire to research and learn in students.  So the bottom line is I need to search for the answers.

John Davy I read your post and I thank you.  I will certainly keep your thoughts in mind.

Thomas Gonder, I thank you for responding.  Your feedback certainly is interesting.  I will check out the link you provided.

So in conclusion I thank you!!! all

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.
 

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: 5/2/2026 8:28:45 AM. PLT: 1s