Search results

I have a subform in datasheet view and I wish to selectively hide columns I'm not using (depending on the query). I wrote a small function to make it easier. Here's my code: Function HideColumn(myForm As SubForm, myLabel As String) myForm.SetFocus myForm.Controls(myLabel).SetFocus...

Well, these are only SELECT queries that I'm doing btw. I don't think creating the queries are too complicated. At the very least I think I can spit out the SELECT statement that should be run. Still, I want these queries to be displayed dynamically. Using a subform in datasheet view doesn't...

As much as I would like to tell my boss he's insane I'd also like to keep my job. I know this is possible, but it sounds very complicated. Basically, I need a way to generate queries on the fly. This is geared towards someone who doesn't know SQL of course. I know basically what he's looking...