UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> MySQL query parser/organizer    
 
   
niesz
post Dec 22 2007, 12:48 PM
Post#1


Utter A-fishin'-ado
Posts: 17,958
Joined: 1-August 05
From: Cincinnati, Ohio, USA . . . ><((((°>


I initially wrote this little utilty to help me store some MySQL queries that I couldn't quite store natively in Access. Some bits of the of SQL reference web page components, so they aren't "pure" SQL and it was difficult to organize them the way I wanted.
It stores the SQL in a memo field in a table, and (oh yeah wink.gif ) even parses it for you and copies it to the clipboard so you can paste it directly into VBA or whatever web editing software you may have.
**It works equally as well for converting native SQL from Access' query builder into useable VBA strings. Just add your variable name! ("sql =") **
I thought some others may have use for this, so here you go...
Some other nice features that you'll find demonstrated here are:
[*] Filtering a listbox
[*] Use of an unbound main form to bound subform
[*] Master/Child relationship from a listbox to a subform
[*] Making a TAB key work as a standard TAB in a textbox (This one's kinda cool wink.gif )
Attached File(s)
Attached File  SQL2VBA.zip ( 25.23K )Number of downloads: 325
 
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    13th December 2017 - 03:57 PM