Computer Learning Zone CLZ Access Excel Word Windows

Education is a system of imposed ignorance. Teachers should be guides and facilitators, not taskmasters who impose fixed knowledge.

-Noam Chomsky
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Templates > ABCD > Part 2 < Part 1 | Part 3 >
Back to ABCD Core Part 2    Comments List
Upload Images   Link   Email  
ABCD Part 2 Lesson 4
Richard Rost 
            
4 years ago
Posted Lesson 4. It's uploading now. Should be done in about 30 minutes (it's big - over 50 min long). Developed groups for entities to be in (students, parents, vendors, employees, whatever you want to create!) Many to many relationship, so people can be in multiple groups, and groups can have multiple people. Forms to jump between them. Good lesson!
Michelle Maughan 
    
4 years ago
Hi Richard
Me again! Lesson 4 keeps stopping at 14.31.
Richard Rost OP 
            
4 years ago
OK. I'll recompile and re-upload it. That happens sometimes with these big video files. You can skip ahead in the video if you catch it before it locks up, but you'll miss a little. Recompiling it usually fixes it. Give me about an hour.
Alex Hedley 
            
4 years ago
Groups
Can you add the same Entity to a group multiple times?
Richard Rost OP 
            
4 years ago
Probably. I didn't put anything in there to prevent it. I'll add this to the bug fix list.
Michelle Maughan 
    
4 years ago
Hi Richard
After the SQL sort at the very end of lesson, I now get "Enter Parameter Value" EntityListName.
I have gone over the code again and again and can't find an error. i have copied and pasted below. Was working great until then. HELP.

Public Sub LoadGroupMembers()
    
    GroupSubF.Form.RecordSource = "SELECT * FROM EntityXGroupQ WHERE GroupID=" & GroupList & " ORDER BY EntityListName"
    GroupSubF.Form.AllowAdditions = True

End Sub
Alex Hedley 
            
4 years ago
Does EntityListName exist in your EntityXGroupQ?
Have you tried making a new Query in the Editor, hard coding the GroupID and testing it that way?
This Query did change in versions, did you pick an earlier version and not add the extra columns with the new name calculations?
Richard Rost OP 
            
4 years ago
99% of the time unexpected "Enter Parameter Value" prompts are caused by a misspelling somewhere.
Michelle Maughan 
    
4 years ago
I know... you have said that many times. I just can't find it!
I will try again now that i have had a sleep, hopefully fresh eyes will find it.
Richard Rost OP 
            
4 years ago
I don't know how many times I spent HOURS trying to hunt down a bug... late at night... tired as can be... then I sleep on it and find the problem FIRST thing in the morning... like DUH!
Michelle Maughan 
    
4 years ago
Would you believe a restart fixed the problem! I forgot about the obvious!
Richard Rost OP 
            
4 years ago
I absolutely 100% do believe that. I've seen that a million times. Hence, the Troubleshooter.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in ABCD Core Part 2.
 

 
 
 

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 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 12/2/2024 3:51:35 AM. PLT: 1s