Show Your Table/Query Data on this Forum

giacomo

Well-known Member
Joined
Feb 20, 2002
Messages
1,802
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
Joined
Feb 20, 2002
Messages
1,802
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
Joined
Feb 20, 2002
Messages
1,802
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
Joined
Feb 20, 2002
Messages
1,802
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
Joined
Aug 16, 2002
Messages
5,869
Office Version
365, 2019
Platform
Windows
This addin is MrExcel approved
:)
Giacomo - if you can provide a link to where the user can get the addin...
 

giacomo

Well-known Member
Joined
Feb 20, 2002
Messages
1,802
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
Joined
Aug 5, 2003
Messages
12,255
Giacomo,

That's really cool :cool:

Thanks for putting it together (y)

Denis
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,277
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
Joined
Feb 20, 2002
Messages
1,802
Thanks Norie!

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

Giacomo
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,277
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:
 

Forum statistics

Threads
1,077,768
Messages
5,336,143
Members
399,067
Latest member
CJWFM

Some videos you may like

This Week's Hot Topics

Top