Thanks
"I wrote one in T-SQL and made a "trial" presentation of the technique for my local PASS chapter. I'm converting that to an article."
Is the article freely...

"my "Excel Hell" presentation last night"
Was that an online presentation?

I currently cannot create any db(against which to run your code)in SQL Server, I'm going to ask the db admin to create a test environment for me.

I was trying to run Sub Test()
but I get an error at the line
ConnString = "Provider=SQLOLEDB;Data Source= GOSTAMUNKTELL\SQLEXPRESS;" & _
...

We're a small to medium size company and we use Access and Access Web Apps coupled with SQL Server and Azure with great satisfaction since it can also handle managed...

Hi Bill, why is there a comma in

CurrentDb.QueryDefs("qryTest").sql = "prcTest '',''"

?

How about not pumping anything into SQL Server and do all the processing and output in Access?

"The ACE drivers"

So Access could be used instead to solve the problem outlined in the opening post?

Isn't Public Sub bindInfo supposed to be run in Access? If so, does VB.Net code run in Access?

From the previous post(copied below), are DataList, Try and Catch accepted elements in VBA? Or is this not VBA?

Public Sub bindInfo(ByVal grid As DataList, ByVal UserID As Int32)

...

"allows you to use dynamic parameters in cells"

What are dynamic parameters in cells?

Thank you again

what calls the Public Property Get Ready()?

Is the process of setting

m_booReady = True

in the main form Open event

enough to call it?

Thanks 🙂

"This event can only occurs when both subforms have been initialized" and that's for the Open event but what triggers the main form's Ready property?

"the Ready property of the parent is set to True (through its m_booReady member variable)."

so in the main form Open event you have

m_booReady = True

but then what triggers the main...