Sorting a HTML column (1 Viewer)

kitty77

Registered User.
Local time
Today, 18:39
Joined
May 27, 2019
Messages
556
I'm using the export html feature and I get a static html page. I would like to be able to sort the html columns.
But I can only seem to export a static html. Any way to do what I'm asking?

Thanks...
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:39
Joined
May 7, 2009
Messages
16,867
you create a Query from your Table and Sort it on the Column of your choice.
Export the query instead of the table.
 

kitty77

Registered User.
Local time
Today, 18:39
Joined
May 27, 2019
Messages
556
Yes but the exported html is only static.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:39
Joined
May 7, 2009
Messages
16,867
i'm afraid it is static.
if you know javascript or ado programming you can make it dynamic/updateable?
 

kitty77

Registered User.
Local time
Today, 18:39
Joined
May 27, 2019
Messages
556
Was hoping I could find a tool that would convert it. Maybe from excel to html or something.
I don't know javascript or ado to the level.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 15:39
Joined
Oct 29, 2018
Messages
19,194
Was hoping I could find a tool that would convert it. Maybe from excel to html or something.
I don't know javascript or ado to the level.
HTML pages are static. To make them dynamic, you'll need to use something like JavaScript. If you do that, you'll also need to store the data to sort them. You could try storing them into an array. In addition, you'll need a sorting routine.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:39
Joined
May 7, 2009
Messages
16,867
here is a demo of what i found.
i frankenstein some code and create a Function to
create an HTM file out of table/query.
the resulting HTM is sortable.

you call the function:

Call TableToSortableHTM("yourTableName")

open the .htm (on Document folder).
you can Click on the Header and it will sort.
 

Attachments

  • table_to_html.accdb
    432 KB · Views: 209

kitty77

Registered User.
Local time
Today, 18:39
Joined
May 27, 2019
Messages
556
here is a demo of what i found.
i frankenstein some code and create a Function to
create an HTM file out of table/query.
the resulting HTM is sortable.

you call the function:

Call TableToSortableHTM("yourTableName")

open the .htm (on Document folder).
you can Click on the Header and it will sort.
Thanks for the example! Can you explain how I make the module work? Not familiar on how to call it or use it. Sry...
I think this will work.
 

Users who are viewing this thread

Top Bottom