Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mach5
  • Order by date
  1. mach5

    Running Stored Procedures in GP VBA

    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...
  2. mach5

    Changing pre-defined text labels in Modifier

    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...
  3. mach5

    Accessing SQL tables in VBA for GP

    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...
  4. mach5

    Accessing SQL tables from VBA

    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
  5. mach5

    Accessing SQL tables from VBA

    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...
  6. mach5

    Accessing SQL tables in VBA for GP

    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...

Part and Inventory Search

Back
Top