Show Your Table/Query Data on this Forum

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,035
Office Version
2019
Platform
Windows
I am also getting the error message as described above by others. I have determined that this add in will not be beneficial to me. Now that it is installed as an add-in and each db created looks for it, it has become a bit of a nusiance when transferring dB to others to use without transferring the add in file. How can I delete the add in from Access 2007. I can't quite figure this out.

Alan
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,035
Office Version
2019
Platform
Windows
Thanks Denis. The KN is exactly what I tried to do. However, for this add-in there is no check box to un-check.
Rich (BB code):
Select or clear the check box for the Add-in that you want enable or  disable and then click OK.
That is why I raised the question. I think it may have to do with the add in itself that was developed. Thanks again. Will keep trying to figure this out.

Alan
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,255
Richard Schollar has been working on one for a while, for Excel posts.
You can download a test version if you like, from his signature. I think it goes beyond just displaying the output; but see what you think of it.

Giacomo's version was intended to work out of Access because the Board didn't have a tool for that, but maybe yours can be adapted.

Denis
 

Kreszch68

Active Member
Joined
Mar 10, 2011
Messages
411
Test

<TABLE cellSpacing=0 bgColor=#ffffff border=1><CAPTION>sysColumnOrders</CAPTION><THEAD><TR><TH borderColor=#000000 bgColor=#c0c0c0>frmName</TH><TH borderColor=#000000 bgColor=#c0c0c0>CtrlName</TH><TH borderColor=#000000 bgColor=#c0c0c0>ColumnOrder</TH><TH borderColor=#000000 bgColor=#c0c0c0>ColumnWidth</TH><TH borderColor=#000000 bgColor=#c0c0c0>ColumnHidden</TH><TH borderColor=#000000 bgColor=#c0c0c0>RowHeight</TH></TR></THEAD><TBODY><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstRelaties</TD><TD borderColor=#d0d7e5>RelatieType</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5 align=right>1530</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstRelaties</TD><TD borderColor=#d0d7e5>Bedrijfsnaam</TD><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>6300</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstRelaties</TD><TD borderColor=#d0d7e5>Zoekcode</TD><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5 align=right>1710</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstRelaties</TD><TD borderColor=#d0d7e5>Plaats</TD><TD borderColor=#d0d7e5 align=right>5</TD><TD borderColor=#d0d7e5 align=right>1590</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstRelaties</TD><TD borderColor=#d0d7e5>Telefoonnummer</TD><TD borderColor=#d0d7e5 align=right>6</TD><TD borderColor=#d0d7e5 align=right>2055</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstRelaties</TD><TD borderColor=#d0d7e5>Depotnummer</TD><TD borderColor=#d0d7e5 align=right>2</TD><TD borderColor=#d0d7e5 align=right>1665</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstMutaties</TD><TD borderColor=#d0d7e5>Status</TD><TD borderColor=#d0d7e5 align=right>7</TD><TD borderColor=#d0d7e5 align=right>1485</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstMutaties</TD><TD borderColor=#d0d7e5>Datum mutatie</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5 align=right>1890</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstMutaties</TD><TD borderColor=#d0d7e5>Aantal</TD><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>1020</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstMutaties</TD><TD borderColor=#d0d7e5>Prijs per aandeel</TD><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5 align=right>1980</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstMutaties</TD><TD borderColor=#d0d7e5>Vermogen</TD><TD borderColor=#d0d7e5 align=right>5</TD><TD borderColor=#d0d7e5 align=right>1815</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstMutaties</TD><TD borderColor=#d0d7e5>Toelichting</TD><TD borderColor=#d0d7e5 align=right>6</TD><TD borderColor=#d0d7e5 align=right>1725</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstMutaties</TD><TD borderColor=#d0d7e5>dnmID</TD><TD borderColor=#d0d7e5 align=right>8</TD><TD borderColor=#d0d7e5 align=right>-1</TD><TD borderColor=#d0d7e5 align=right>Waar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstMutaties</TD><TD borderColor=#d0d7e5>dndID</TD><TD borderColor=#d0d7e5 align=right>9</TD><TD borderColor=#d0d7e5 align=right>-1</TD><TD borderColor=#d0d7e5 align=right>Waar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstDeelnemingen</TD><TD borderColor=#d0d7e5>Aandeelhouder</TD><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5 align=right>4920</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>-1</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstDeelnemingen</TD><TD borderColor=#d0d7e5>Valuta</TD><TD borderColor=#d0d7e5 align=right>5</TD><TD borderColor=#d0d7e5 align=right>1020</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>-1</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstDeelnemingen</TD><TD borderColor=#d0d7e5>Depotnummer</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5 align=right>1710</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>-1</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstDeelnemingen</TD><TD borderColor=#d0d7e5>GT-Nummer</TD><TD borderColor=#d0d7e5 align=right>2</TD><TD borderColor=#d0d7e5 align=right>1560</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>-1</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstDeelnemingen</TD><TD borderColor=#d0d7e5>Deelneming</TD><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>6300</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>-1</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstDetailDeelneming</TD><TD borderColor=#d0d7e5>rsaNaam</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5 align=right>1785</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstDetailDeelneming</TD><TD borderColor=#d0d7e5>dndStatus</TD><TD borderColor=#d0d7e5 align=right>7</TD><TD borderColor=#d0d7e5 align=right>1350</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstDetailDeelneming</TD><TD borderColor=#d0d7e5>dndCoupureGestort</TD><TD borderColor=#d0d7e5 align=right>2</TD><TD borderColor=#d0d7e5 align=right>1920</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstDetailDeelneming</TD><TD borderColor=#d0d7e5>dndCoupure</TD><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>1260</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstDetailDeelneming</TD><TD borderColor=#d0d7e5>dndAantal</TD><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5 align=right>1020</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstDetailDeelneming</TD><TD borderColor=#d0d7e5>dndToelichting</TD><TD borderColor=#d0d7e5 align=right>6</TD><TD borderColor=#d0d7e5 align=right>1830</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstDetailDeelneming</TD><TD borderColor=#d0d7e5>Nominaal bedrag aandelen</TD><TD borderColor=#d0d7e5 align=right>5</TD><TD borderColor=#d0d7e5 align=right>2925</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstFinanRechtRenteData</TD><TD borderColor=#d0d7e5>frdID</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstFinanRechtRenteData</TD><TD borderColor=#d0d7e5>firID</TD><TD borderColor=#d0d7e5 align=right>2</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstFinanRechtRenteData</TD><TD borderColor=#d0d7e5>frdDatum</TD><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>1635</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstContactpersonen</TD><TD borderColor=#d0d7e5>conInitialen</TD><TD borderColor=#d0d7e5 align=right>1</TD><TD borderColor=#d0d7e5 align=right>660</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstContactpersonen</TD><TD borderColor=#d0d7e5>conVoorvoegsel</TD><TD borderColor=#d0d7e5 align=right>2</TD><TD borderColor=#d0d7e5 align=right>690</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstContactpersonen</TD><TD borderColor=#d0d7e5>conAchternaam</TD><TD borderColor=#d0d7e5 align=right>3</TD><TD borderColor=#d0d7e5 align=right>1875</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>frm_LijstContactpersonen</TD><TD borderColor=#d0d7e5>conTelefoonnumer</TD><TD borderColor=#d0d7e5 align=right>4</TD><TD borderColor=#d0d7e5 align=right>2055</TD><TD borderColor=#d0d7e5 align=right>Onwaar</TD><TD borderColor=#d0d7e5 align=right>
</TD></TR></TBODY><TFOOT></TFOOT></TABLE>
 
Last edited:

N0komiz

New Member
Joined
May 1, 2013
Messages
1
Cool. Thanks for giving us a chance to learn from the code. It helps.

<style>


body
{


overflow: none;


}
</style>
 

bradhog

New Member
Joined
Dec 21, 2013
Messages
15
After downloading this add-in it becomes more easy to understand it. You have provided everything altogether at one place. Thank you for this.
 

AngelJ

Board Regular
Joined
Jan 8, 2013
Messages
227
The link to giacomo's website is dead and users can now copy and paste straight from Access. Seems better to have a sticky informing people of their ability to do that.
 

Forum statistics

Threads
1,077,722
Messages
5,335,843
Members
399,052
Latest member
WPO

Some videos you may like

This Week's Hot Topics

Top