CodeSampleF - Microsoft Access Developer 9


	Back to Access Developer 9 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

CodeSampleF

Ken Wykoff

3 months ago

Can anyone tell me if there is a lesson or tech help video on how this form was made? I've been trying to do it, but it's not working for me. I've gone back and forth to investigate names, events, data, sources, etc., and just can't seem to put it all together. I really like the way this form was made and would like to add more code to the form that I find useful
Thanks, Ken

	Alex Hedley @Reply 3 months ago
What's the Form bound to?

	Ken Wykoff OP @Reply 3 months ago
Alex from what I can tell it is created using CodeSampleT to create it so I am going to say looking at the table it is the bound item is ID. It is a separate form from the lesson. 3 attachments

	Ken Wykoff OP @Reply 3 months ago

	Ken Wykoff OP @Reply 3 months ago

	Ken Wykoff OP @Reply 3 months ago

	Ken Wykoff OP @Reply 3 months ago
I just think this form would be great for so many things.

	Alex Hedley @Reply 3 months ago
What part isn't working for you?

	Ken Wykoff OP @Reply 3 months ago
After I make the form created from the table, nothing shows after being saved. Heading only shows Name???? and no ID, and no coding. I add the code to the button like ot does too, but I am obviously not doing something correctly.

	Ken Wykoff OP @Reply 3 months ago

	Ken Wykoff OP @Reply 3 months ago
Alex somehow I finally got the top part to work but still nothing the code are. When I hit the button "Select all copy text" I get this error. I looked in Properties but can't find anything named this.

	Ken Wykoff OP @Reply 3 months ago

	Ken Wykoff OP @Reply 3 months ago
CodeSample.SelStart = 0 in blue

	Alex Hedley @Reply 3 months ago
Can you put the Form is Design View and show what the RecordSource is then each of the controls

	Ken Wykoff OP @Reply 3 months ago
I hope this is what you wanted. I made it as I saw it in the Lesson video Developer 9

	Ken Wykoff OP @Reply 3 months ago

	Ken Wykoff OP @Reply 3 months ago

	Ken Wykoff OP @Reply 3 months ago

	Ken Wykoff OP @Reply 3 months ago

	Ken Wykoff OP @Reply 3 months ago
If I leave the control source as CodeSample and place CodeSampleT in rowsource, this is what happens

	Ken Wykoff OP @Reply 3 months ago

	Ken Wykoff OP @Reply 3 months ago
Alex I finally figured out how to make it all work! Took a lot of trial and error but it works now. Thanks, Ken

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

Next Unseen

New Feature: Comment Live View