top
logo

Polls

Using Microsoft Access
 

Directory

# | 0-9 |A |B |C |D |E |F |G |H |I |J |K |L |M |N |O |P |Q |R |S |T |U |V |W |X |Y |Z

Directory » Web links » Access VBA Tips and Tricks

Access VBA Tips and Tricks (27)

Results 1 - 20 of 27

http://office.microsoft.com/en-us/access-help/functions-by-category-HP001135959.aspx
2.9/5 (14 votes)
Web links/Access VBA Tips and Tricks
Saturday, 26 March 2011 | 1086 hits
1.9/5 (7 votes)
Web links/Access VBA Tips and Tricks
Wednesday, 07 September 2011 | 885 hits
http://gpgonaccess.blogspot.com/2010/03/work-in-progress-and-64-bit-vba.html
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
4.2/5 (9 votes)
Web links/Access VBA Tips and Tricks
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
From time to time, you may find that common functions like CurrentDB, Str$ or Mid$ stop working. This condition is usually caused by a reference error in the database. (All Access databases contain references, which are a way of referring to another...
Friday, 08 June 2012 | 964 hits | Read more
2.6/5 (9 votes)
Web links/Access VBA Tips and Tricks
http://msdn.microsoft.com/en-us/library/aa155438%28office.10%29.aspx
Although some applications link to foreign files, an Access database generally contains all the objects an application needs. As a result, file management isn't the same kind of laborious affair it is with other applications. However, that doesn't...
Sunday, 22 January 2012 | 4148 hits | Read more
http://msdn.microsoft.com/en-us/library/aa155438%28office.10%29.aspx
http://access.mvps.org/access/RunCommand/index.htm
3.0/5 (10 votes)
Web links/Access VBA Tips and Tricks
http://access.mvps.org/access/RunCommand/index.htm
Great information and VBA code examples for using DoCmd.RunCommand
Sunday, 03 November 2013 | 1180 hits
2.0/5 (12 votes)
Web links/Access VBA Tips and Tricks
http://access.mvps.org/access/modules/mdl0001.htm
Here is how to have Access convert the currency value "$531.20" into the text "Five hundred thirty one and twenty cents."
Monday, 27 February 2012 | 661 hits
http://access.mvps.org/access/modules/mdl0001.htm
http://www.fmsinc.com/microsoftaccess/performance/decompile.asp
2.6/5 (10 votes)
Web links/Access VBA Tips and Tricks
http://www.fmsinc.com/microsoftaccess/performance/decompile.asp
Decompile Your Microsoft Access Database to Improve Performance, Fix Corruption, and Avoid Strange VBA Errors Periodically, Microsoft Access databases with VBA module code perform oddly. Code that previously worked suddenly fail or behaves...
Tuesday, 15 May 2012 | 954 hits | Read more
2.6/5 (16 votes)
Web links/Access VBA Tips and Tricks
http://msdn.microsoft.com/en-us/library/aa221224%28office.11%29.aspx
The ExportXML method allows developers to export XML data, schemas, and presentation information from Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), Microsoft SQL Server 6.5 or later, or the Microsoft Jet database engine.
Monday, 12 March 2012 | 639 hits
http://msdn.microsoft.com/en-us/library/aa221224%28office.11%29.aspx
http://support.microsoft.com/kb/824255
3.4/5 (14 votes)
Web links/Access VBA Tips and Tricks
http://support.microsoft.com/kb/824255
This article discusses the sequence of tasks that Microsoft Office Access 2007, Microsoft Office Access 2003, Microsoft Access 2002, Access 2000, or Access 97 performs to resolve the references in Microsoft Visual Basic for Applications (VBA).
Sunday, 19 June 2011 | 909 hits
2.9/5 (16 votes)
Web links/Access VBA Tips and Tricks
http://www.techrepublic.com/blog/howdoi/how-do-i-retrieve-a-random-set-of-records-in-microsoft-access/149
We usually think of data in sets of related values, but not always. Occasionally, you may need to supply someone with a set of unrelated records, retrieved completely at random. Perhaps a manager wants to predict future growth or an auditor is...
Monday, 16 January 2012 | 1138 hits | Read more
http://www.techrepublic.com/blog/howdoi/how-do-i-retrieve-a-random-set-of-records-in-microsoft-access/149
http://support.microsoft.com/kb/310803
2.7/5 (12 votes)
Web links/Access VBA Tips and Tricks
http://support.microsoft.com/kb/310803
his article describes issues that concern the use of references in an Access database. Understanding reference errors requires an understanding both of how libraries are referenced in an Access database and of what is needed to install a database...
Friday, 08 June 2012 | 783 hits | Read more
2.3/5 (8 votes)
Web links/Access VBA Tips and Tricks
http://support.microsoft.com/kb/209953
his article describes how to use the OpenDatabase method to open a Microsoft Access database that has a database password. Note that this is different from opening a database that is secured with the Microsoft Access user-level security feature.
Thursday, 04 August 2011 | 807 hits
http://support.microsoft.com/kb/209953
http://msdn.microsoft.com/en-us/library/aa221344%28office.11%29.aspx
2.3/5 (12 votes)
Web links/Access VBA Tips and Tricks
http://msdn.microsoft.com/en-us/library/aa221344%28office.11%29.aspx
** Applies to Access 2003, Access 2007, and Access 2010 ** You use the HyperlinkPart method to return one of three values from a Hyperlink field or the displayed value. The value returned depends on the setting of the part argument. The part...
Sunday, 22 July 2012 | 762 hits | Read more
2.5/5 (11 votes)
Web links/Access VBA Tips and Tricks
Wednesday, 30 November 2011 | 1040 hits
http://allenbrowne.com/func-GoHyperlink.html
http://technet.microsoft.com/en-us/library/ee692914.aspx
1.7/5 (9 votes)
Web links/Access VBA Tips and Tricks
http://technet.microsoft.com/en-us/library/ee692914.aspx
Office Space: Tips and Tricks for Scripting Microsoft Office Applications Although the Office Space column has been in business for several months now there are at least two topics we haven’t even touched on: Microsoft Access and XML....
Monday, 12 March 2012 | 775 hits | Read more
3.3/5 (13 votes)
Web links/Access VBA Tips and Tricks
http://www.cpearson.com/excel/Classes.aspx
Classes are a powerful tool in intermediate to advanced level VBA programming. This page is an introduction to what a class and an object are and will hopefully get you started working with classes. This is by no means a comprehensive guide
Saturday, 31 December 2011 | 964 hits
http://www.cpearson.com/excel/Classes.aspx
http://allenbrowne.com/appinventory.html
2.4/5 (10 votes)
Web links/Access VBA Tips and Tricks
http://allenbrowne.com/appinventory.html
written by Allen Browne "How do I update the Quantity On Hand each time an item is sold/used?" The simple answer is: You don't! You calculate the value when you need it. The calculation is very simple: the total number acquired, less the...
Friday, 23 September 2011 | 1156 hits | Read more
2.7/5 (13 votes)
Web links/Access VBA Tips and Tricks
http://www.granite.ab.ca/access/latebinding.htm
Late binding means you can do not have to concern yourself with what version of other software, such as Word, Excel or Outlook, being installed on the target system. Or if that software is not installed at all on the target system.. We found this...
Monday, 20 June 2011 | 1657 hits | Read more
http://www.granite.ab.ca/access/latebinding.htm
http://www.granite.ab.ca/access/addins.htm
3.1/5 (18 votes)
Web links/Access VBA Tips and Tricks
http://www.granite.ab.ca/access/addins.htm
if you want to create an add-in for wide spread use outside your control then you should consider creating the MDE as an add-in with the USysRegInfo table. Otherwise just setting a reference works fine as Access 2000 and newer look in the same...
Sunday, 11 September 2011 | 786 hits | Read more
3.2/5 (11 votes)
Web links/Access VBA Tips and Tricks
http://accesstips.wordpress.com/2009/07/16/microsoft-access-vba-uses-wmi-to-read-the-registry/
Microsoft Access VBA can read and write to the Windows Registry by using WMI. In this article we are going to show you how easy it is to read 5 different types of Registry Values with VBA and WMI.
Monday, 16 January 2012 | 632 hits
http://accesstips.wordpress.com/2009/07/16/microsoft-access-vba-uses-wmi-to-read-the-registry/

« StartPrev12NextEnd »
Page 1 of 2


Powered by AlphaContent 4.0.15 © 2005-2014 - All rights reserved

Sponsored Links


bottom
top

Latest News

Popular


bottom

Powered by Joomla!. Designed by: Free Joomla 1.5 Theme, linux hosting. Valid XHTML and CSS.