Alpha Video Training
Page 2 of 2 FirstFirst 12
Results 31 to 37 of 37

Thread: Progressive Lookup Function

  1. #31
    "Certified" Alphaholic forskare's Avatar
    Real Name
    Ken Nordin
    Join Date
    Apr 2000
    Location
    Walker, MN
    Posts
    7,545

    Default Re: Progressive Lookup Function

    John,

    I don't think posting a DB would help you any more than the code posted above because you will still need to change parts of the code to reflect your database. Tell us what your issue is.
    TYVM :) kenn

    Knowing what you can achieve will not become reality until you imagine and explore.

  2. #32
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Progressive Lookup Function

    Agreed.

    You pass the source table, source index, return field, rows and columns.
    John,

    The last function posted is database and table independent.
    You tell the funtion what table to use.
    You tell the function the index name (on that field, of course) to use.
    You tell the function what field to return.
    Etc.

  3. #33
    Member
    Real Name
    Renny Jacob
    Join Date
    Mar 2012
    Location
    Dubai
    Posts
    117

    Default Re: Progressive Lookup Function

    John,
    Don't bother about the code too much. There is an xdialogu option (in v10) which will do the progressive search easily. If you are still struggling let me know, i will upload a sample project.

    Group members,
    Meanwhile I'm looking for an option to print the grid of progressive search result. Any advice on this?
    Thanx

  4. #34
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,628

    Default Re: Progressive Lookup Function

    Quote Originally Posted by jacobr View Post
    John,
    Don't bother about the code too much. There is an xdialogu option (in v10) which will do the progressive search easily. If you are still struggling let me know, i will upload a sample project.

    Group members,
    Meanwhile I'm looking for an option to print the grid of progressive search result. Any advice on this?
    Thanx
    Depending on the data volume, you may notice a large performance issue between Jim's routine and other routines....

    Jim's is extremely fast even with large tables - ie more than hundreds of thousands of records.

    Usually the difference is noticed in the 2,000 or more records in a table...
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  5. #35
    Member nehru's Avatar
    Real Name
    Nehru L. Albania
    Join Date
    Nov 2003
    Location
    Philippines, Manila, Q.C.
    Posts
    152

    Default Re: Progressive Lookup Function

    + 2 john
    "Knowledge without application is useless."

  6. #36
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default Re: Progressive Lookup Function

    Hi Renny,
    Meanwhile I'm looking for an option to print the grid of progressive search result. Any advice on this?
    Do you mean to print a report with the same data as the lookup?
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

  7. #37
    Member
    Real Name
    Renny Jacob
    Join Date
    Mar 2012
    Location
    Dubai
    Posts
    117

    Default Re: Progressive Lookup Function

    Yes Keith,
    is there any possibility to print that or export to excel?

    Renny

Similar Threads

  1. Progressive Lookup
    By julian lewis in forum Alpha Five Version 5
    Replies: 2
    Last Post: 06-30-2004, 03:28 PM
  2. Progressive lookup
    By Chris McConnell in forum Alpha Five Version 5
    Replies: 11
    Last Post: 04-04-2004, 07:14 AM
  3. Progressive lookup Value
    By forskare in forum Alpha Five Version 5
    Replies: 5
    Last Post: 02-22-2004, 04:33 AM
  4. Progressive Lookup
    By Bill Parker in forum Alpha Five Version 5
    Replies: 9
    Last Post: 01-13-2004, 09:18 AM
  5. Progressive Lookup
    By Louis Nickerson in forum Alpha Five Version 5
    Replies: 4
    Last Post: 09-29-2003, 08:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •