Productivity Tips

2013-05-25T15:11:42Z

/* '''Productivity Tips''' */

Revision as of 15:11, 25 May 2013		Current revision
Line 17:		Line 17:
	\|-		\|-
	\| Create default Form and Report Templates \|\| [[Form and Report Templates]] \|\| 2003 - 2010		\| Create default Form and Report Templates \|\| [[Form and Report Templates]] \|\| 2003 - 2010
		+	\|-
		+	\| Calling XML Web Services \|\| [http://msdn.microsoft.com/en-us/library/aa140260(office.10).aspx Using XML Web Services] \|\| 2003 - 2010
	\|}		\|}

TempVars

2013-05-21T20:27:48Z

Revision as of 20:27, 21 May 2013		Current revision
Line 13:		Line 13:

	Here are some examples:<br/>		Here are some examples:<br/>
-	[code]TempVars.Add “curTotalTrans”, 356.60[/code]<br/>	+	[code]TempVars.Add "curTotalTrans", 356.60[/code]<br/>
-	[code]TempVars.Add “lngCustID”, 4455[/code]<br/>	+	[code]TempVars.Add "lngCustID", 4455[/code]<br/>
-	[code]TempVars.Add “bolIsActive”, True[/code]<br/>	+	[code]TempVars.Add "bolIsActive", True[/code]<br/>
	[code]TempVars.Add myFieldVar, "New User Name"[/code]<br/>		[code]TempVars.Add myFieldVar, "New User Name"[/code]<br/>
	(where "myFieldVar" might be a variable you've used to store the name of a field or control for the user name and "New User Name" is the value of that user name field/control)<br/><br/>		(where "myFieldVar" might be a variable you've used to store the name of a field or control for the user name and "New User Name" is the value of that user name field/control)<br/><br/>
Line 23:		Line 23:
	Once the values are assigned you can use them in your queries and code with various syntaxing:<br/>		Once the values are assigned you can use them in your queries and code with various syntaxing:<br/>
	[code]TempVars!curTotalTrans[/code]<br/>		[code]TempVars!curTotalTrans[/code]<br/>
-	[code]TempVars.Item(“curTotalTrans”)[/code]<br/>	+	[code]TempVars.Item("curTotalTrans")[/code]<br/>
	[code]TempVars.Item(0)[/code]<br/>		[code]TempVars.Item(0)[/code]<br/>
	All three methods above will return "356.60"		All three methods above will return "356.60"
Line 30:		Line 30:

	Use the "Remove" method to remove a single variable or use '.RemoveAll' to clear all of them.<br/><br/>		Use the "Remove" method to remove a single variable or use '.RemoveAll' to clear all of them.<br/><br/>
-	[code]TempVars.Remove “curTotalTrans”[/code]<br/>	+	[code]TempVars.Remove "curTotalTrans"[/code]<br/>
	[code]TempVars.RemoveAll[/code]<br/>		[code]TempVars.RemoveAll[/code]<br/>

Access wiki - Access Help and How-to - Microsoft Office - Recent changes [en]

Productivity Tips

TempVars