code fragment

[Lou_Reed]

I entered the flowing VBA Access 2010 code in the code (Alt-F11) window of my Access 2010 application.

Option Compare Database
Option Explicit

 'Create a String varaibale named NewValList
 Dim NewValList As String
 
 'Build NewValList string in chunks.
 
NewValList = Chr(34) + "First item" + Chr(34) + ";"
NewValList = NewValList + Chr(34) + "Second Item" + Chr(34) + ";"
NewValList = NewValList + Chr(34) + "Third Item" + Chr(34) + ";"
NewValList = NewValList + Chr(34) + "Fourth Item" + Chr(34)
'At this point . NewValList contains...
'"First item": "Second Item" + "Third Item"" "fourth Item"
'Make new string the Row Source for value list named OpsCombo
Me!OpsCombo.RowSourceType = "Value List"
Me!OpsCombo.RowSource = NewValueList
'Set the selection to first item in drop down menu
Me!OpsCombo.Value = Me!OpsCombo.ItemData(0)

Now how do I run it? I can cut and paste it to any window I want. I guess that I should
make a subprogram out of it with Start Sub and End Sub put around it. Anyway, I got this from a tutorial and I believe it is
good with no errors. But how do I run it?

Respectfully,




Lou_Reed

[pbaldy]

You could include it in the code for the appropriate event (when you want the row source set to this). That could be a button, the form's open event, etc. With the combo reference, it is form-specific.

[Lou_Reed]

Okay, I see your point but I just want to play with this code - do some things to it.

I have already got a db selected. I am going to use the code on that. But, how?

It is a code fragment.

That is my question.


Respectfully,


Lou_Reed

[pbaldy]

Simplest is probably behind a button. You can make it a public sub/function, but I don't see the point.

[pbaldy]

If your question was how to get it behind a button:

http://www.baldyweb.com/FirstVBA.htm

[davegri]

The code is meant to run behind a form, being the value list row source for a combo box on that form. Google access combobox for more info.

[Lou_Reed]

The point is just to learn about the VBA code system. A code fragment was used in a tutorial and I want
to use it and work with it. It is not a project.

Respectfully,


Lou_Reed
'

[pbaldy]

Did you get it working?

[Lou_Reed]

Not Yet. I am trying however.

Respectfully,

Lou_Reed

[pbaldy]

Post back if you get stuck. I didn't know if posts 4 & 5 got lost in the confusion.