MS JET SQL HELP 2

[CCLINT]

There are often threads started by members looking how to use JET SQL and the JET VBA functions.

I just want to point out two often overlooked help files which you should find on your hard drive if anyone has installed VB6 SP5

JETSQL35.HLP
JETSQL40.CHM

These help files, especially the JETSQL40.CHM, will give you insite into not only JET SQL and JET VBA functions, ANSI '92 reserved words (and which ones that are actually available under JET), and things like using the IN keyword to connect to another MDB in the same SQL Statement, but it will also give you insite into the very Basics of the SQL syntax (SELECT, INSERT INTO, JOIN, UNION, Etc., Rushmore technology, etc.)

They will also give you an insite into DAO.

Please check this simple to use and nicely laid out help file first.

 

[CajunCenturion]

Good info CCLINT

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[zemp]

I agree with with Cajun. We often forget about the resources right under our noses.

Thanks for taking the time to post that.

Thanks and Good Luck!

zemp

 

[billybobk]

Interesting. Did a search of my c:\ and found the files. Who knew? (besides cclint!) And they are very useful files indeed.

 

[zyrag]

...and you can always invoke the program within the vb code window by pressing F1 with the mouse stationed on a SQL keyword. This file helps a lot.