Search results for query: *

I'm trying to run a Stored Procedure from the GP VBA. It will be used for data entry validation so it will be run a lot (hundreds of times per day). Using ADO, I can create a connection and get a recordset back, but as far as I can tell this requires that I either (a) hardcode a userid and...

I'm trying to change some of the text labels on the customer card. Basically, I need to change the "Statement To:" label to read "Update To:". If possible, I would also like the column reference in Explorer to also display as "Update To". I haven't had any luck...

The ODBC connection is set up on my computer, I just don't know how to set it up in VBA. I've been reading a few VB books that say I need to do something along the lines of "ODBC;UID=blah blah;PASSWORD=somethingorother;" etc. I've attempted to do this a number of different ways to...

I've seen a bit about SQL pass-through queries in my search for information... I'll take another look and see what I missed. Thanks, Mark

Can someone tell me how to access an SQL table through VBA, or where I might find specifics on the subject? Seems like a basic question, and I'm sure it is, but for the life of me I can't figure it out. I've looked in VB books, VBA books, SQL books, VB/SQL books, online (Microsoft is no help...

There are so few VBA books out there and even fewer that deal with accessing databases of any kind, let alone the specifics of getting at SQL tables. Any help would be greatly appreciated as I really have no idea where to begin. Somehow I need to be able to send "SELECT/FROM/etc&quot...