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: apexearth
  • Content: Threads
  • Order by date
  1. apexearth

    SELECT IN A SELECT IN A SELECT (possible?)

    I'm trying to put a select within a select within a select. Here's an example of what I'm trying to do. DECLARE @TEMP TABLE (I INT, K INT) INSERT INTO @TEMP SELECT 1, 2 UNION SELECT 1, 3 UNION SELECT 1, 5 UNION SELECT 2, 1 UNION SELECT 2, 3 UNION SELECT 2, 7 UNION SELECT 3, 3 UNION SELECT 3...
  2. apexearth

    Optimizing Macro Record Lookups

    What's the fastest way to do a view lookup in a macro or while using the COMAPI? Right now I have used either the .Browse or .FilterSelect functions followed by a Fetch or a GoTop and sometimes it can take an outlandish amount of time to perform depending on where the record is and whether I'm...
  3. apexearth

    COMException using AccpacFinder.ViewFinder in VB.NET

    Hi, I'm trying to use the AccpacFinder.ViewFinder I get an unhandled exception once I get to af.Finder(). No errors show up in af.Session.Errors. I'm using the AccpacCOMAPI on Windows 7 64bit with the program running in 32bit. I've tried everything I can think of but I can't seem to get this...

Part and Inventory Search

Back
Top