Show Your Table/Query Data on this Forum

giacomo

Well-known Member
A while back I got frustrated that there was not a good way to display table data from Access on this forum. I always liked Colo's HTML Add-In for Excel, so I set out to make my own for Access. So now almost 7 months later, I think it's finished. I will post below some samples of what you can create with my add-in and I hope that some of you might be interested in installing it for yourselves and sharing your feedback with me.

the add-in can be downloaded from my web site

Thanks!
Giacomo
 

giacomo

Well-known Member
This is what I call the extended view, it is meant to simulate the layout in MS Access. If you click on or hover over the table name it will display some of the table meta data such as record count and description. Hovering or clicking on the field names will give you data type, indexes, and description.

I added record selectors for fun, although they don't display in firefox. I've only tested this on IE and FireFox.

<SCRIPT language=JavaScript src="http://www.theprimarykey.com/js/accHTML.js"></SCRIPT><link rel="stylesheet" type="text/css" href="http://www.theprimarykey.com/css/acchtml.css"/><CENTER><TABLE cellSpacing=0 align=center cellpadding=2px width=50% ><TR ><TD CLASS="AccTBMain" border-left=1px solid colSpan= 11 ><TABLE width="100%" align=left VALIGN="TOP" ><TR ><TD CLASS="AccTBInner" align=Left ><font color="White">tblPresident : Table</font></TD><TD CLASS="AccTBInner" align=right >Access 2000</TD></TR></TABLE></TD></TR><TR ><TD CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccHDRMain" align=left >ID</TD><TD CLASS="AccHDRMain" align=left >Birth Order</TD><TD CLASS="AccHDRMain" align=left >Fname</TD><TD CLASS="AccHDRMain" align=left >Middle</TD><TD CLASS="AccHDRMain" align=left >Lname</TD><TD CLASS="AccHDRMain" align=left >DOB</TD><TD CLASS="AccHDRMain" align=left >Century</TD><TD CLASS="AccHDRMain" align=left >Order of Office</TD><TD CLASS="AccHDRMain" align=left >BirthCity</TD><TD CLASS="AccHDRMain" align=left >BirthState</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >4</TD><TD CLASS="AccDataElem" >1</TD><TD CLASS="AccDataElem" >1</TD><TD CLASS="AccDataElem" >George</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >Washington</TD><TD CLASS="AccDataElem" >February 22, 1732</TD><TD CLASS="AccDataElem" >18</TD><TD CLASS="AccDataElem" >1</TD><TD CLASS="AccDataElem" >Pope's Creek</TD><TD CLASS="AccDataElem" >Virginia</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >2</TD><TD CLASS="AccDataElem" >2</TD><TD CLASS="AccDataElem" >John</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >Adams</TD><TD CLASS="AccDataElem" >October 30, 1735</TD><TD CLASS="AccDataElem" >18</TD><TD CLASS="AccDataElem" >2</TD><TD CLASS="AccDataElem" >Braintree</TD><TD CLASS="AccDataElem" >Massachusetts</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >3</TD><TD CLASS="AccDataElem" >3</TD><TD CLASS="AccDataElem" >Thomas</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >Jefferson</TD><TD CLASS="AccDataElem" >April 13, 1743</TD><TD CLASS="AccDataElem" >18</TD><TD CLASS="AccDataElem" >3</TD><TD CLASS="AccDataElem" >Goochland County</TD><TD CLASS="AccDataElem" >Virginia</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >4</TD><TD CLASS="AccDataElem" >4</TD><TD CLASS="AccDataElem" >James</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >Madison</TD><TD CLASS="AccDataElem" >March 16, 1751</TD><TD CLASS="AccDataElem" >18</TD><TD CLASS="AccDataElem" >4</TD><TD CLASS="AccDataElem" >Port Conway</TD><TD CLASS="AccDataElem" >Virginia</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >5</TD><TD CLASS="AccDataElem" >5</TD><TD CLASS="AccDataElem" >James</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >Monroe</TD><TD CLASS="AccDataElem" >April 28, 1758</TD><TD CLASS="AccDataElem" >18</TD><TD CLASS="AccDataElem" >5</TD><TD CLASS="AccDataElem" >Westmoreland County</TD><TD CLASS="AccDataElem" >Virginia</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >6</TD><TD CLASS="AccDataElem" >6</TD><TD CLASS="AccDataElem" >Andrew</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >Jackson</TD><TD CLASS="AccDataElem" >March 15, 1767</TD><TD CLASS="AccDataElem" >18</TD><TD CLASS="AccDataElem" >7</TD><TD CLASS="AccDataElem" >Waxhaw</TD><TD CLASS="AccDataElem" >South Carolina</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >7</TD><TD CLASS="AccDataElem" >7</TD><TD CLASS="AccDataElem" >John</TD><TD CLASS="AccDataElem" >Quincy</TD><TD CLASS="AccDataElem" >Adams</TD><TD CLASS="AccDataElem" >July 11, 1767</TD><TD CLASS="AccDataElem" >18</TD><TD CLASS="AccDataElem" >6</TD><TD CLASS="AccDataElem" >Braintree</TD><TD CLASS="AccDataElem" >Massachusetts</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >8</TD><TD CLASS="AccDataElem" >8</TD><TD CLASS="AccDataElem" >William</TD><TD CLASS="AccDataElem" >Henry</TD><TD CLASS="AccDataElem" >Harrison</TD><TD CLASS="AccDataElem" >February 9, 1773</TD><TD CLASS="AccDataElem" >18</TD><TD CLASS="AccDataElem" >9</TD><TD CLASS="AccDataElem" >Charles City County</TD><TD CLASS="AccDataElem" >Virginia</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >9</TD><TD CLASS="AccDataElem" >9</TD><TD CLASS="AccDataElem" >Martin</TD><TD CLASS="AccDataElem" >Van</TD><TD CLASS="AccDataElem" >Buren</TD><TD CLASS="AccDataElem" >December 5, 1782</TD><TD CLASS="AccDataElem" >18</TD><TD CLASS="AccDataElem" >8</TD><TD CLASS="AccDataElem" >Kinderhook</TD><TD CLASS="AccDataElem" >New York</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >10</TD><TD CLASS="AccDataElem" >10</TD><TD CLASS="AccDataElem" >Zachary</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >Taylor</TD><TD CLASS="AccDataElem" >November 24, 1784</TD><TD CLASS="AccDataElem" >18</TD><TD CLASS="AccDataElem" >12</TD><TD CLASS="AccDataElem" >Orange County</TD><TD CLASS="AccDataElem" >Virginia</TD></TR><TR ><TD ID="IE" CLASS="AccIEOnlyMain" colSpan= 11 ><TABLE width="100%" align=left VALIGN="TOP" ><TR ><TD CLASS="AccIEOnlyInnerRight" > Record: </TD><TD CLASS="AccIEOnlyButton" > 9 </TD><TD CLASS="AccIEOnlyButton" > 3 </TD><TD CLASS="AccIEOnlyData" > 1 </TD><TD CLASS="AccIEOnlyButton" > 4 </TD><TD CLASS="AccIEOnlyButton" > : </TD><TD CLASS="AccIEOnlyInnerLeft" > of 43</TD></TR></TABLE></TD></TR><TR ><TD CLASS="AccIEOnlyMain" colSpan= 11 ><TABLE cellSpacing=0 cellPadding=0 width="100%" align=left VALIGN="TOP" ><TR ><TD ID="Data483699977" CLASS="AccInfoBarInnerRight" >tblPresident</TD><TD ID="Info483699977" CLASS="AccInfoBarData" > Record Count: 43</TD></TR></TABLE></TD></TR><TR ><TD CLASS="tpkrow" colSpan = 11 ><CENTER><font size = 1>Access HTML Add-in provided by theprimarykey.com</font></CENTER></TD></TR></TABLE></CENTER><script type="text/javascript">if (navigator.appName != 'Microsoft Internet Explorer') { var a = document.getElementById("currRec"); a.innerHTML = '
'; var b = document.getElementById("IE"); b.textContent = 'Table format has been altered for non-IE browsers '; b.style.fontSize = 10;}</script>
 

giacomo

Well-known Member
This is my Lite view, it's meant to be more compact. I also have a sample data option so that posters can obscure thier data if they feel it is sensitive.



Actual Data:
<link rel="stylesheet" type="text/css" href="http://www.theprimarykey.com/css/acchtml.css"/><CENTER><TABLE cellSpacing=0 align=center cellpadding=2px width=50% ><TR ><TD CLASS="AccTBMainLT" border-left=1px solid colSpan= 11 ><TABLE width="100%" align=left VALIGN="TOP" ><TR ><TD CLASS="AccTBInnerLT" align=Left >tblPresident : Table</TD><TD CLASS="AccTBInnerLT" align=right >Access 2000</TD></TR></TABLE></TD></TR><TR ><TD CLASS="AccDataElemLT" align=left >ID</TD><TD CLASS="AccDataElemLT" align=left >Birth Order</TD><TD CLASS="AccDataElemLT" align=left >Fname</TD><TD CLASS="AccDataElemLT" align=left >Middle</TD><TD CLASS="AccDataElemLT" align=left >Lname</TD><TD CLASS="AccDataElemLT" align=left >DOB</TD><TD CLASS="AccDataElemLT" align=left >Century</TD><TD CLASS="AccDataElemLT" align=left >Order of Office</TD><TD CLASS="AccDataElemLT" align=left >BirthCity</TD><TD CLASS="AccDataElemLT" align=left >BirthState</TD></TR><TR ><TD CLASS="AccDataElemLT" >1</TD><TD CLASS="AccDataElemLT" >1</TD><TD CLASS="AccDataElemLT" >George</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Washington</TD><TD CLASS="AccDataElemLT" >February 22, 1732</TD><TD CLASS="AccDataElemLT" >18</TD><TD CLASS="AccDataElemLT" >1</TD><TD CLASS="AccDataElemLT" >Pope's Creek</TD><TD CLASS="AccDataElemLT" >Virginia</TD></TR><TR ><TD CLASS="AccDataElemLT" >2</TD><TD CLASS="AccDataElemLT" >2</TD><TD CLASS="AccDataElemLT" >John</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Adams</TD><TD CLASS="AccDataElemLT" >October 30, 1735</TD><TD CLASS="AccDataElemLT" >18</TD><TD CLASS="AccDataElemLT" >2</TD><TD CLASS="AccDataElemLT" >Braintree</TD><TD CLASS="AccDataElemLT" >Massachusetts</TD></TR><TR ><TD CLASS="AccDataElemLT" >3</TD><TD CLASS="AccDataElemLT" >3</TD><TD CLASS="AccDataElemLT" >Thomas</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Jefferson</TD><TD CLASS="AccDataElemLT" >April 13, 1743</TD><TD CLASS="AccDataElemLT" >18</TD><TD CLASS="AccDataElemLT" >3</TD><TD CLASS="AccDataElemLT" >Goochland County</TD><TD CLASS="AccDataElemLT" >Virginia</TD></TR><TR ><TD CLASS="AccDataElemLT" >4</TD><TD CLASS="AccDataElemLT" >4</TD><TD CLASS="AccDataElemLT" >James</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Madison</TD><TD CLASS="AccDataElemLT" >March 16, 1751</TD><TD CLASS="AccDataElemLT" >18</TD><TD CLASS="AccDataElemLT" >4</TD><TD CLASS="AccDataElemLT" >Port Conway</TD><TD CLASS="AccDataElemLT" >Virginia</TD></TR><TR ><TD CLASS="AccDataElemLT" >5</TD><TD CLASS="AccDataElemLT" >5</TD><TD CLASS="AccDataElemLT" >James</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Monroe</TD><TD CLASS="AccDataElemLT" >April 28, 1758</TD><TD CLASS="AccDataElemLT" >18</TD><TD CLASS="AccDataElemLT" >5</TD><TD CLASS="AccDataElemLT" >Westmoreland County</TD><TD CLASS="AccDataElemLT" >Virginia</TD></TR><TR ><TD CLASS="tpkrow" colSpan = 10 ><CENTER><font size = 1>Access HTML Add-in provided by theprimarykey.com</font></CENTER></TD></TR></TABLE></CENTER><script type="text/javascript">if (navigator.appName != 'Microsoft Internet Explorer') { var a = document.getElementById(""); a.innerHTML = '
'; var b = document.getElementById(""); b.textContent = 'Table format has been altered for non-IE browsers '; b.style.fontSize = 10;}</script>



Sample Data:
<link rel="stylesheet" type="text/css" href="http://www.theprimarykey.com/css/acchtml.css"/><CENTER><TABLE cellSpacing=0 align=center cellpadding=2px width=50% ><TR ><TD CLASS="AccTBMainLT" border-left=1px solid colSpan= 11 ><TABLE width="100%" align=left VALIGN="TOP" ><TR ><TD CLASS="AccTBInnerLT" align=Left >tblPresident : Table</TD><TD CLASS="AccTBInnerLT" align=right >Access 2000</TD></TR></TABLE></TD></TR><TR ><TD CLASS="AccDataElemLT" align=left >ID</TD><TD CLASS="AccDataElemLT" align=left >Birth Order</TD><TD CLASS="AccDataElemLT" align=left >Fname</TD><TD CLASS="AccDataElemLT" align=left >Middle</TD><TD CLASS="AccDataElemLT" align=left >Lname</TD><TD CLASS="AccDataElemLT" align=left >DOB</TD><TD CLASS="AccDataElemLT" align=left >Century</TD><TD CLASS="AccDataElemLT" align=left >Order of Office</TD><TD CLASS="AccDataElemLT" align=left >BirthCity</TD><TD CLASS="AccDataElemLT" align=left >BirthState</TD></TR><TR ><TD CLASS="AccDataElemLT" >1</TD><TD CLASS="AccDataElemLT" >1.73807489871979</TD><TD CLASS="AccDataElemLT" >Nhwjhu</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Renppqpupx</TD><TD CLASS="AccDataElemLT" >Jigvbzdw 33, 4656</TD><TD CLASS="AccDataElemLT" >26.6243748664856</TD><TD CLASS="AccDataElemLT" >1.09137880802155</TD><TD CLASS="AccDataElemLT" >Njnw's Uhovy</TD><TD CLASS="AccDataElemLT" >Rlcsuqbn</TD></TR><TR ><TD CLASS="AccDataElemLT" >2</TD><TD CLASS="AccDataElemLT" >3.81959247589111</TD><TD CLASS="AccDataElemLT" >Bxwx</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Ekdoj</TD><TD CLASS="AccDataElemLT" >Xrucgku 70, 9210</TD><TD CLASS="AccDataElemLT" >19.379741191864</TD><TD CLASS="AccDataElemLT" >3.62732839584351</TD><TD CLASS="AccDataElemLT" >Imwqjywpx</TD><TD CLASS="AccDataElemLT" >Ctpegtmhvlhni</TD></TR><TR ><TD CLASS="AccDataElemLT" >3</TD><TD CLASS="AccDataElemLT" >5.4609010219574</TD><TD CLASS="AccDataElemLT" >Pplmzg</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Wfcssxfko</TD><TD CLASS="AccDataElemLT" >Fittu 17, 2089</TD><TD CLASS="AccDataElemLT" >26.4411628246307</TD><TD CLASS="AccDataElemLT" >5.28418350219727</TD><TD CLASS="AccDataElemLT" >Pdqdbfwnz Dxblqz</TD><TD CLASS="AccDataElemLT" >Ppcaisgj</TD></TR><TR ><TD CLASS="AccDataElemLT" >4</TD><TD CLASS="AccDataElemLT" >4.55132865905762</TD><TD CLASS="AccDataElemLT" >Bfast</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Kgbwexb</TD><TD CLASS="AccDataElemLT" >Lmixh 46, 8192</TD><TD CLASS="AccDataElemLT" >22.4764308929443</TD><TD CLASS="AccDataElemLT" >4.62641525268555</TD><TD CLASS="AccDataElemLT" >Etbm Edfmby</TD><TD CLASS="AccDataElemLT" >Klnviwtl</TD></TR><TR ><TD CLASS="AccDataElemLT" >5</TD><TD CLASS="AccDataElemLT" >6.63025498390198</TD><TD CLASS="AccDataElemLT" >Stfne</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Miihbu</TD><TD CLASS="AccDataElemLT" >Edueb 13, 31100</TD><TD CLASS="AccDataElemLT" >29.3717615604401</TD><TD CLASS="AccDataElemLT" >5.34849524497986</TD><TD CLASS="AccDataElemLT" >Tbptfbztbhgh Xjxqwv</TD><TD CLASS="AccDataElemLT" >Gjcfeove</TD></TR><TR ><TD CLASS="tpkrow" colSpan = 10 ><CENTER><font size = 1>Access HTML Add-in provided by theprimarykey.com</font></CENTER></TD></TR></TABLE></CENTER><script type="text/javascript">if (navigator.appName != 'Microsoft Internet Explorer') { var a = document.getElementById(""); a.innerHTML = '
'; var b = document.getElementById(""); b.textContent = 'Table format has been altered for non-IE browsers '; b.style.fontSize = 10;}</script>
 

giacomo

Well-known Member
The add-in can also display Query data. There are three views for Queries:



Extended:
<SCRIPT language=JavaScript src="http://www.theprimarykey.com/js/accHTML.js"></SCRIPT><link rel="stylesheet" type="text/css" href="http://www.theprimarykey.com/css/acchtml.css"/><CENTER><TABLE cellSpacing=0 align=center cellpadding=2px width=75% ><TR ><TD CLASS="AccTBMain" border-left=1px solid colSpan= 7 ><TABLE width="100%" align=left VALIGN="TOP" ><TR ><TD CLASS="AccTBInner" align=Left ><font color="White">Query1 : Select Query</font></TD><TD CLASS="AccTBInner" align=right >Access 2000</TD></TR></TABLE></TD></TR><TR ><TD CLASS="AccDataElem" colSpan= 7 >SELECT
tblPresident.ID
, tblPresident.[Birth Order]
, tblPresident.Fname
, tblPresident.Middle
, tblPresident.Lname
, tblPresident.DOB

FROM
tblPresident
ORDER BY
tblPresident.[Birth Order] DESC;
</TD></TR><TR ><TD CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccHDRMain" align=left >ID</TD><TD CLASS="AccHDRMain" align=left >Birth Order</TD><TD CLASS="AccHDRMain" align=left >Fname</TD><TD CLASS="AccHDRMain" align=left >Middle</TD><TD CLASS="AccHDRMain" align=left >Lname</TD><TD CLASS="AccHDRMain" align=left >DOB</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >4</TD><TD CLASS="AccDataElem" >43</TD><TD CLASS="AccDataElem" >42</TD><TD CLASS="AccDataElem" >Bill</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >Clinton</TD><TD CLASS="AccDataElem" >August 19, 1946</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >42</TD><TD CLASS="AccDataElem" >41</TD><TD CLASS="AccDataElem" >George</TD><TD CLASS="AccDataElem" >W.</TD><TD CLASS="AccDataElem" >Bush</TD><TD CLASS="AccDataElem" >July 6, 1946</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >41</TD><TD CLASS="AccDataElem" >40</TD><TD CLASS="AccDataElem" >Jimmy</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >Carter</TD><TD CLASS="AccDataElem" >October 1, 1924</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >40</TD><TD CLASS="AccDataElem" >39</TD><TD CLASS="AccDataElem" >George</TD><TD CLASS="AccDataElem" >H.W.</TD><TD CLASS="AccDataElem" >Bush</TD><TD CLASS="AccDataElem" >June 12, 1924</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >39</TD><TD CLASS="AccDataElem" >38</TD><TD CLASS="AccDataElem" >John</TD><TD CLASS="AccDataElem" >F.</TD><TD CLASS="AccDataElem" >Kennedy</TD><TD CLASS="AccDataElem" >May 29, 1917</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >38</TD><TD CLASS="AccDataElem" >37</TD><TD CLASS="AccDataElem" >Gerald</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >Ford</TD><TD CLASS="AccDataElem" >July 14, 1913</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >37</TD><TD CLASS="AccDataElem" >36</TD><TD CLASS="AccDataElem" >Richard</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >Nixon</TD><TD CLASS="AccDataElem" >January 9, 1913</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >36</TD><TD CLASS="AccDataElem" >35</TD><TD CLASS="AccDataElem" >Ronald</TD><TD CLASS="AccDataElem" >
</TD><TD CLASS="AccDataElem" >Reagan</TD><TD CLASS="AccDataElem" >February 6, 1911</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >35</TD><TD CLASS="AccDataElem" >34</TD><TD CLASS="AccDataElem" >Lyndon</TD><TD CLASS="AccDataElem" >B.</TD><TD CLASS="AccDataElem" >Johnson</TD><TD CLASS="AccDataElem" >August 27, 1908</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >34</TD><TD CLASS="AccDataElem" >33</TD><TD CLASS="AccDataElem" >Dwight</TD><TD CLASS="AccDataElem" >D.</TD><TD CLASS="AccDataElem" >Eisenhower</TD><TD CLASS="AccDataElem" >October 14, 1890</TD></TR><TR ><TD ID="IE" CLASS="AccIEOnlyMain" colSpan= 7 ><TABLE width="100%" align=left VALIGN="TOP" ><TR ><TD CLASS="AccIEOnlyInnerRight" > Record: </TD><TD CLASS="AccIEOnlyButton" > 9 </TD><TD CLASS="AccIEOnlyButton" > 3 </TD><TD CLASS="AccIEOnlyData" > 1 </TD><TD CLASS="AccIEOnlyButton" > 4 </TD><TD CLASS="AccIEOnlyButton" > : </TD><TD CLASS="AccIEOnlyInnerLeft" > of 43</TD></TR></TABLE></TD></TR><TR ><TD CLASS="AccIEOnlyMain" colSpan= 7 ><TABLE cellSpacing=0 cellPadding=0 width="100%" align=left VALIGN="TOP" ><TR ><TD ID="Data959034801" CLASS="AccInfoBarInnerRight" >Query1</TD><TD ID="Info959034801" CLASS="AccInfoBarData" >Select Query, Record Count : 43</TD></TR></TABLE></TD></TR><TR ><TD CLASS="tpkrow" colSpan = 7 ><CENTER><font size = 1>Access HTML Add-in provided by theprimarykey.com</font></CENTER></TD></TR></TABLE></CENTER><script type="text/javascript">if (navigator.appName != 'Microsoft Internet Explorer') { var a = document.getElementById("currRec"); a.innerHTML = '
'; var b = document.getElementById("IE"); b.textContent = 'Table format has been altered for non-IE browsers '; b.style.fontSize = 10;}</script>



Lite:
<link rel="stylesheet" type="text/css" href="http://www.theprimarykey.com/css/acchtml.css"/><CENTER><TABLE cellSpacing=0 align=center cellpadding=2px width=75% ><TR ><TD CLASS="AccTBMainLT" border-left=1px solid colSpan= 7 ><TABLE width="100%" align=left VALIGN="TOP" ><TR ><TD CLASS="AccTBInnerLT" align=Left >Query1 : Select Query</TD><TD CLASS="AccTBInnerLT" align=right >Access 2000</TD></TR></TABLE></TD></TR><TR ><TD CLASS="AccDataElemLT" align=left >ID</TD><TD CLASS="AccDataElemLT" align=left >Birth Order</TD><TD CLASS="AccDataElemLT" align=left >Fname</TD><TD CLASS="AccDataElemLT" align=left >Middle</TD><TD CLASS="AccDataElemLT" align=left >Lname</TD><TD CLASS="AccDataElemLT" align=left >DOB</TD></TR><TR ><TD CLASS="AccDataElemLT" >43</TD><TD CLASS="AccDataElemLT" >42</TD><TD CLASS="AccDataElemLT" >Bill</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Clinton</TD><TD CLASS="AccDataElemLT" >August 19, 1946</TD></TR><TR ><TD CLASS="AccDataElemLT" >42</TD><TD CLASS="AccDataElemLT" >41</TD><TD CLASS="AccDataElemLT" >George</TD><TD CLASS="AccDataElemLT" >W.</TD><TD CLASS="AccDataElemLT" >Bush</TD><TD CLASS="AccDataElemLT" >July 6, 1946</TD></TR><TR ><TD CLASS="AccDataElemLT" >41</TD><TD CLASS="AccDataElemLT" >40</TD><TD CLASS="AccDataElemLT" >Jimmy</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Carter</TD><TD CLASS="AccDataElemLT" >October 1, 1924</TD></TR><TR ><TD CLASS="AccDataElemLT" >40</TD><TD CLASS="AccDataElemLT" >39</TD><TD CLASS="AccDataElemLT" >George</TD><TD CLASS="AccDataElemLT" >H.W.</TD><TD CLASS="AccDataElemLT" >Bush</TD><TD CLASS="AccDataElemLT" >June 12, 1924</TD></TR><TR ><TD CLASS="AccDataElemLT" >39</TD><TD CLASS="AccDataElemLT" >38</TD><TD CLASS="AccDataElemLT" >John</TD><TD CLASS="AccDataElemLT" >F.</TD><TD CLASS="AccDataElemLT" >Kennedy</TD><TD CLASS="AccDataElemLT" >May 29, 1917</TD></TR><TR ><TD CLASS="AccDataElemLT" >38</TD><TD CLASS="AccDataElemLT" >37</TD><TD CLASS="AccDataElemLT" >Gerald</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Ford</TD><TD CLASS="AccDataElemLT" >July 14, 1913</TD></TR><TR ><TD CLASS="AccDataElemLT" >37</TD><TD CLASS="AccDataElemLT" >36</TD><TD CLASS="AccDataElemLT" >Richard</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Nixon</TD><TD CLASS="AccDataElemLT" >January 9, 1913</TD></TR><TR ><TD CLASS="AccDataElemLT" >36</TD><TD CLASS="AccDataElemLT" >35</TD><TD CLASS="AccDataElemLT" >Ronald</TD><TD CLASS="AccDataElemLT" >
</TD><TD CLASS="AccDataElemLT" >Reagan</TD><TD CLASS="AccDataElemLT" >February 6, 1911</TD></TR><TR ><TD CLASS="AccDataElemLT" >35</TD><TD CLASS="AccDataElemLT" >34</TD><TD CLASS="AccDataElemLT" >Lyndon</TD><TD CLASS="AccDataElemLT" >B.</TD><TD CLASS="AccDataElemLT" >Johnson</TD><TD CLASS="AccDataElemLT" >August 27, 1908</TD></TR><TR ><TD CLASS="AccDataElemLT" >34</TD><TD CLASS="AccDataElemLT" >33</TD><TD CLASS="AccDataElemLT" >Dwight</TD><TD CLASS="AccDataElemLT" >D.</TD><TD CLASS="AccDataElemLT" >Eisenhower</TD><TD CLASS="AccDataElemLT" >October 14, 1890</TD></TR><TR ><TD CLASS="tpkrow" colSpan = 6 ><CENTER><font size = 1>Access HTML Add-in provided by theprimarykey.com</font></CENTER></TD></TR></TABLE></CENTER><script type="text/javascript">if (navigator.appName != 'Microsoft Internet Explorer') { var a = document.getElementById(""); a.innerHTML = '
'; var b = document.getElementById(""); b.textContent = 'Table format has been altered for non-IE browsers '; b.style.fontSize = 10;}</script>



SQL Only:
<link rel="stylesheet" type="text/css" href="http://www.theprimarykey.com/css/acchtml.css"/><CENTER><TABLE cellSpacing=0 align=center cellpadding=2px width=75% ><TR ><TD CLASS="AccTBMain" border-left=1px solid colSpan= 7 ><TABLE width="100%" align=left VALIGN="TOP" ><TR ><TD CLASS="AccTBInner" align=Left ><font color="White">Query1 : Select Query</font></TD><TD CLASS="AccTBInner" align=right >Access 2000</TD></TR></TABLE></TD></TR><TR ><TD CLASS="AccDataElem" colSpan= 7 >SELECT
tblPresident.ID
, tblPresident.[Birth Order]
, tblPresident.Fname
, tblPresident.Middle
, tblPresident.Lname
, tblPresident.DOB

FROM
tblPresident
ORDER BY
tblPresident.[Birth Order] DESC;
</TD></TR><TR ><TD CLASS="tpkrow" colSpan = 6 ><CENTER><font size = 1>Access HTML Add-in provided by theprimarykey.com</font></CENTER></TD></TR></TABLE></CENTER><script type="text/javascript">if (navigator.appName != 'Microsoft Internet Explorer') { var a = document.getElementById(""); a.innerHTML = '
'; var b = document.getElementById(""); b.textContent = 'Table format has been altered for non-IE browsers '; b.style.fontSize = 10;}</script>
 

starl

Administrator
This addin is MrExcel approved
:)
Giacomo - if you can provide a link to where the user can get the addin...
 

giacomo

Well-known Member
Thanks Tracy!

the add-in can be downloaded from my web site

If anyone has any questions about the add-in please feel free to PM or email me.

Giacomo
 

SydneyGeek

MrExcel MVP
Giacomo,

That's really cool :cool:

Thanks for putting it together (y)

Denis
 

Norie

Well-known Member
giacomo

Nice add-in.:)

I've only just downloaded it but it looks pretty impressive.

One thing I really appreciate is that you've not locked the code.

That gives others, including myself , a chance to study and perhaps offer some suggestions for improvements/alterations, though I doubt much improvement is needed.:)
 

giacomo

Well-known Member
Thanks Norie!

Looking forward to any suggestions you feel like providing... big or small

Giacomo
 

Norie

Well-known Member
Giacomo

No problem.:)

I've not really got time at the moment to fully analyze the code.

But when I do, I'll post back, but from what I've seen so far it doesn't seem to need any improvement.:)

And I've never create and add-in before either,so I'll need to look in to that as well.

I think I created something a while ago to reformat/restructure a HTML file created using Excel so it posted better on the board.

I just used it for personal use as for some reason I couldn't use Colo's HTMLMaker.

Anyways, I lost it and 100 of other files when my computer died.:oops:
 

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top