records are ordered by "drop down box" and text box for query

Posted on 2015-01-12
Medium Priority
Last Modified: 2016-07-07
moved pages from frontpage to asp
add, edit, delete all done and working, displaying all records in web page no problem
I would like to add a drop down box and it would select the order ie last name, file number or town
also a text box which if something was imputed it would only list that record(s). if the text box was empty, all records would be displayed.
Question by:dataspeak
  • 2
LVL 44

Accepted Solution

Rainer Jeschor earned 1000 total points
ID: 40546354
there is a really nice Javascript library called DataTables.net
Their site has a lot of samples and I guess this plugin should do the trick (it depends a little bit on your generated HTML code).

Author Comment

ID: 40546440
I'm using access with 8000 records
the java script "nice" but reads all records into the html page then sorts and displays.
I don't think this will work
i need record pointers.
i will attach a file with part code
LVL 51

Assisted Solution

by:Steve Bink
Steve Bink earned 1000 total points
ID: 40546820
The datatables library is a jQuery plugin, and I've been using it for an internal analytics engine.  It will suit this project well enough if you take the time to learn what you can do with it.

For example, it can provide automatic or scripted filtering and sorting.  It can also be told to fetch data via AJAX instead of populating it with a static table/list/whatever.  It has options for client- *OR* server-side record processing.  

This library will 100% work for you, but there is some learning curve you'll have to go through.
LVL 51

Expert Comment

by:Steve Bink
ID: 41697111
#40546354 and #40546820

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Implementing simple internal controls in the Microsoft Access application.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

586 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question