Using variable and controls in sql strings (1 Viewer)

[Lol999]

Hi, could someone point me in the direction of some resource for the proper syntax of including, say, the output from a combobox into an sql string in vba?

Many thanks, Lol

 

[1268]

Hi, could someone point me in the direction of some resource for the proper syntax of including, say, the output from a combobox into an sql string in vba?

Many thanks, Lol

Variable = me.combox if within the form. You have to reference the form if not. Google it, pretty basic, tons of info out their already.

Sent from my SM-G950U using Tapatalk

 

[Uncle Gizmo]

Not exactly what you asked for, but this should get you started:-

http://www.niftyaccess.com/vba-beginner/

 

[Beetle]

Have a look here

 

[Lol999]

Have a look here

Thanks for the link.

 

[sonic8]

Hi, could someone point me in the direction of some resource for the proper syntax of including, say, the output from a combobox into an sql string in vba?

First, a ComboBox has no "output". It has properties that you can use in SQL queries based on the selection in the ComboBox. Most of the time, you want to use the Value property, which contains the value of the first column of the selected record of the Rowsource. Sometimes you rather need the value of another column. You can access that with the indexed Column property.

Building a SQL string with the numeric value of a ComboBox in the form of the control would look like this in code:

strSQL = "SELECT SomeColumns FROM yourTable WHERE aColumn= " & Me.yourComboBox.Value

Please see my extensive tutorial on SQL strings building in VBA for further reference.
The link to MSDN, provided by Beetle, is quite good as well, but it lacks essential information for Non-US environments.