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.
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.
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
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?
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!
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
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.