A Diffcul;t Chapter in Access VBA Programing for Dummies.

[Lou_Reed]

I have been reading the book by Alan Simpson, "Access VBA programming for Dummies".

I have read it and reread it. I believe that the most difficult chapter is Chapter 10:

Customizing Lists and Drop Down Menus; the rest is basic stuff that any programmer
can understand. Chapter 10 is different. It is not basic that is for sure.

It is by far the hardest for someone new to Access 2010 VBA programming to grasp.

Therefore I am doing some of the code examples that are in that chapter.

That is where I have run into trouble. Some are just code fragments so it is hard to get


them in any shape to run.

That is why I posted some Access VBA code in a separate post earlier today.

So much of the results of the programming results is not output that I or any other programmer is used to seeing.

If I may, could I post some of examples that seem not to run? I am using a leftover database donated to me
by coworker that is no longer relevant to our organization, but to me it could be useful.

Jus let know if this is okay.

Please reply soon.

Respectfully,


Lou Reed

[aytee111]

You have to use the code in the context that is being explained, you cannot separate it from the rest of the chapter. If it is a stand-alone piece of code then you can start a new module, paste it into it (with Function before and End Function after) and you can run it with the Run command (or f5). If however the code refers to objects, such as your previous post which referred to objects on a form or report, then you need to read what the chapter is telling you and follow the instructions.

[Lou_Reed]

I know that. I just cannot run code fragments whenever I see them in a book. But if I can
use in my sample db then it will be much easier to understand when I get the code working. I
am a programmer. Just reading about a new language just will not get it. You must program in it to understand it.

But if I hit some errors along the way. I do want to understand them as best as I could.

Hence the question in post no 1.

Respectfully,

Lou_Reed

[aytee111]

I know it is frustrating, but you maybe need to slow down a little, follow their examples and then you can copy it into your own database with your own controls and design requirements.

[pbaldy]

If I may, could I post some of examples that seem not to run? I am using a leftover database donated to me
by coworker that is no longer relevant to our organization, but to me it could be useful.

Jus let know if this is okay.

Certainly.