OK, I'll just reply next time. Do you think there is more to the select statement that i didn't add? I'm having a difficult time trying to find the...

Thanks Elliot. What did you mean by "whatever else you didn't send"? I'm sorry I don't understand.

Thank you.

There is a table in the Justice database named CaseStatusHist that has the same fields as I listed in a previous (recent) post. In the database table, the key...

Also, something I did gave me an error box from Visual Studio that says: "Form1.daFutureHearings could not be previewed

The parameterized query '(@prmDate datetime)SELECT csh.* from ClkCaseHdr AS '...

I just edited to add some additional info to my previous post. I am not experienced in finding stuff "buried" in Visual Basic forms, I'm afraid. Can you...

Thanks for continuing to help! There is a data adapter, a connection, a cmdSelect, and a dataset at the bottom of the screen underneath the blank form. The...

Sounds logical Elliot. I think the person who coded it originally was someone who specialized in VB.

RBAR --> I had "RBAC", just a typo by me,...

Thanks, I just saw another chunk of code that you've translated and optimized after I posted a minute ago. Wow!

Thanks Elliot,

The code I posted is the entire thing except for the data source connection string. Could this: "Me.DsFutureHearings1.CaseStatusHist" be filled from transactions in the table via...

Lowell (3/12/2012)

---

i've done the same as what you are asking many times...moving data logic out of VB and into stored procs...post the code as an attachment, i'm sure we can...

I feel a little dense here. What do you mean about the "whole world looks like a nail" in this context? Do you mean we (or I) would tend...

Thanks Elliot. If I had my choice we'd keep it in VB and just run it from SSIS because it is so much time spent rewriting it in a...

Wow, thanks Lowell! [This is in reply to Lowell above, I see there are more comments now that I will read...]

Here's the code for one of them :

Public Class Form1

...

Thanks for your reply Eugene. I think they expect me to figure it out. I would feel like I had a prayer if I knew what the code...

.