Computer Learning Zone CLZ Access Excel Word Windows

The universe is a pretty big place. If it's just us, seems like an awful waste of space.

-Carl Sagan
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
ABCD Part 2 Lesson 4 Upload Images   Link   Email  
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             
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
Can you add the same Entity to a group multiple times?
Richard Rost             
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             
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             
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             
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.

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

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 4/15/2024 4:13:15 PM. PLT: 1s