Not well-familiar with vb syntax

[Naqibullah]

Hello valued colleagues,
i am new with VB, i have problems in writing some in-dept coding and sometimes even in simple ones, for example i am not able to write sql queries using vb, please help me find reference book(give me the link so that i would become well-familiar with vb syntax and coding). however i know the simple ones.

Regards

 

[arnelgp]

4shared.com there are lots of sharing materials there.

 

[gemma-the-husky]

the best vb book is the vba developers handbook, I think.

SQL is different. you are using VBA to construct a string, which you then execute

so something like this

strg = "select * from etc"
currentdb.execute strg

so whether the contents of the string are valid or not, is completely outside the scope of vba itself.

 

[Naqibullah]

thank you arnelgp and gemma-the-husky,

dear arnelgp, i found some useful material in 4shared.com thank you again.
Dear husky, the vba developer handbook is not available in hard copy in afghanistan, can you let me know about free soft copy link of this book, i searched alot but couldn't find one.
regards