Developer 17 Lesson 1 - How To Remove Multi-Select Listbox Items Export PDF Reports and Use DLookupPlus in Microsoft Access


	Back to Access Developer 17 Lessons Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Developer 17 Lesson 1

Ken Wykoff

4 months ago

After changing to a combo box for the Add Record and making code adjustments to the DoStuffBtn, that button no longer enters items into it. Not sure why. I checked the coding against the code in the lesson database we have from the class, and it looks the same. Since the buttons on the lesson do not all list names, it is difficult to find where new codes are assigned to mine, with names corresponding to the buttons. Attached is the code from my database. Also, the handbook that came with the lesson is this an updated version? I just noticed that someone wrote about missing items and wanted to be sure I have an updated version.

	Ken Wykoff OP @Reply 4 months ago

	Kevin Robertson @Reply 4 months ago
Which button isn't working? Do Stuff or Add Record?

	Ken Wykoff OP @Reply 4 months ago
Do Stuff

	Kevin Robertson @Reply 4 months ago
Does the button do anything when it is clicked?

	Ken Wykoff OP @Reply 4 months ago
nothing at all. It worked fine till the combo box was made and the code placed into the dostuffbtn.

	Kevin Robertson @Reply 4 months ago
Perhaps the code has detached from the button. Open the Property Sheet for the button. Click on the Events tab. In the Click event it should say `[Event Procedure]`. Have you renamed the button at all since entering the code?

Ken Wykoff OP @Reply

4 months ago

Kevin, I just checked, and I apparently placed the wrong name on the button property. I am so used to using btn, cbo, etc for names, I forgot this time I was doing it like Robert has been in some videos as a button. Now that I corrected that, it is working again. I still have to check the databases from the downloads of databases because lately, instead of naming everything, it has been left as a command or just the name without the combobox, listbox, or button. Not always,s but this lesson I have to watch closer how it is entered per the video, as to the way I have been trying to do. Thanks again for your time on this.

	Kevin Robertson @Reply 4 months ago
Happy to help.

	Richard Rost @Reply 4 months ago
Inconsistent naming conventions will bite you eventually.

	Kevin Robertson @Reply 4 months ago
Yeah. I've always used 3 letter prefixes when naming controls. This convention started in VB6 and carried forward into Access.

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

Next Unseen

New Feature: Comment Live View