Microsoft Access examples and tutorials - Revision history

Karl Jones at 13:36, 24 May 2016

2016-05-24T13:36:06Z

Karl Jones: /* TreeView */

2016-05-23T16:32:17Z

‎TreeView

Karl Jones: /* Form controls */

2016-05-23T16:31:59Z

‎Form controls

Karl Jones: /* See also */

2016-04-21T12:42:34Z

‎See also

Karl Jones at 15:11, 16 April 2016

2016-04-16T15:11:57Z

Karl Jones: /* TreeView */

2016-03-21T16:18:06Z

‎TreeView

Karl Jones at 11:46, 21 March 2016

2016-03-21T11:46:43Z

Karl Jones: /* TreeView */

2016-03-21T11:45:33Z

‎TreeView

Karl Jones: /* TreeView */

2016-03-21T11:45:14Z

‎TreeView

Karl Jones: /* Form controls */

2016-03-21T11:35:59Z

‎Form controls

← Older revision		Revision as of 13:36, 24 May 2016
Line 2:		Line 2:

	The list is not comprehensive -- I add links and examples as I need them.		The list is not comprehensive -- I add links and examples as I need them.
		+
		+	== Treeview and listview problems in Access 2013 ==
		+
		+	Steps:
		+
		+	<nowiki>Copied MsComCtl.ocx from my Windows 7 computer with Office 2010.
		+
		+	Placed in C:\Windows\SysWow64 folder, AND c:\Windows\System32 folder
		+
		+	Registered it.
		+
		+	Decompiled, and recompiled my Access application.
		+
		+	Deleted treeview control from form, and added a “new” treeview control.</nowiki>
		+
		+	Also:
		+
		+	<nowiki>Finding the MSComctlLib on a 64 Bit version of Windows and setting the reference with code.
		+
		+	What this code does is open the database check which version of Access computer is running (32 or 64 Bit), then checks what version of Windows (32 or 64 Bit) then removes the reference to the MSComctlLib (MSCOMCTL.OCX), then sets the reference to the MSComctlLib (MSCOMCTL.OCX) from the correct location.
		+
		+	Why would anyone need to do this is because the reference is located in different folders depending on which version of Windows the computer is running.
		+
		+	You need to check which version of Access so you use the proper code to call the API’s used.
		+
		+	This will eliminate errors on different computer configurations saving confusion and the need to fix the missing reference manually.
		+
		+	I have attached the code in a text document used to create a demo.</nowiki>
		+
		+	See:
		+
		+	* http://thesmileycoder.com/treeview-working-in-access2013/
		+	* http://www.utteraccess.com/forum/index.php?showtopic=2032428&pid=2564329&st=0&#entry2564329

	== Database and recordset ==		== Database and recordset ==

@@ Line 41: / Line 41: @@
 * [https://support.microsoft.com/en-us/kb/167309 Sample Procedure to Fill a TreeView Control Recursively] @ support.microsoft.com
 * [https://www.youtube.com/watch?v=M5KqFjhQqNg Treeview basics, loading information into the treeview] - TheSmileyCoder @ YouTube
-* [https://msdn.microsoft.com/en-us/library/aa443386(v=vs.60).aspx Add Method (Nodes Collection)] ** Adds a Node object to a Treeview control's Nodes collection.
+* [https://msdn.microsoft.com/en-us/library/aa443386(v=vs.60).aspx Add Method (Nodes Collection)]
 ** Syntax: object.Add(relative, relationship, key, text, image, selectedimage)

@@ Line 41: / Line 41: @@
 * [https://support.microsoft.com/en-us/kb/167309 Sample Procedure to Fill a TreeView Control Recursively] @ support.microsoft.com
 * [https://www.youtube.com/watch?v=M5KqFjhQqNg Treeview basics, loading information into the treeview] - TheSmileyCoder @ YouTube
 See also:

← Older revision		Revision as of 12:42, 21 April 2016
Line 97:		Line 97:

	[[Category:Computer programming]]		[[Category:Computer programming]]
		+	[[Category:Microsoft Access]]
		+	[[Category:Microsoft Office]]
	[[Category:Visual Basic for Applications]]		[[Category:Visual Basic for Applications]]

← Older revision		Revision as of 15:11, 16 April 2016
Line 95:		Line 95:
	* [[Database]]		* [[Database]]
	* [[Data structure]]		* [[Data structure]]
		+
		+	[[Category:Computer programming]]
		+	[[Category:Visual Basic for Applications]]

← Older revision		Revision as of 11:46, 21 March 2016
Line 1:		Line 1:
	This article lists examples and tutorials for [[Microsoft Access]].		This article lists examples and tutorials for [[Microsoft Access]].
		+
		+	The list is not comprehensive -- I add links and examples as I need them.

	== Database and recordset ==		== Database and recordset ==

@@ Line 36: / Line 36: @@
 Use TreeView to display and manage hierarchal data.
-* [https://msdn.microsoft.com/en-us/library/aa733703(v=vs.60).aspx https://msdn.microsoft.com/en-us/library/aa733703(v=vs.60).aspx Using the TreeView control] @ MSDN
+* [https://msdn.microsoft.com/en-us/library/aa733703(v=vs.60).aspx Using the TreeView control] @ MSDN
 * [https://support.microsoft.com/en-us/kb/167309 Sample Procedure to Fill a TreeView Control Recursively] @ support.microsoft.com
 * [https://www.youtube.com/watch?v=M5KqFjhQqNg Treeview basics, loading information into the treeview] - TheSmileyCoder @ YouTube

@@ Line 31: / Line 31: @@
 == Form controls ==
 === Listbox ===
 * [https://msdn.microsoft.com/en-us/library/office/ff823015.aspx ListBox.ItemsSelected Property]