Database
Access detective – find differences in databases
Website For over two decades, Total Access Detective has supported every major Microsoft Access version adding many enhancements along the way: Original Release and Major Updates by Microsoft Access Version Access Version Introduced Product Name Product Version Major Releases Upgrade from Another Version Upgrade in Same Version Access 2.0 Jun 1995 Total Access Detective 2.0 […]
Database address lookup system
1000/month free https://addressfinder.nz/plans/ AddressFinder only ever displays addresses from official NZ Post and LINZ databases. The addresses you collect will always be real and mistake-free.
Crosstab Missing Column in data error
https://msdn.microsoft.com/en-us/library/office/aa191550(v=office.11).aspx How to Tame the Crosstab Missing Column Beast (and Get a Free Lunch) Office 2003 This article may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist. To maintain the flow of the article, we’ve left these URLs in the text, but disabled the […]
Access: reference sub forms and subforms
Forms(“submitter”).Controls(“submission subform”).Form.Controls(“submissionTheme subform”).Form.Controls(“ThemeID”).Requery It is a word that generates fear into the sturdiest Access developer. How do you reference a control on a subform? How do you reference a subform to requery it? How do you reference a subform so you can requery a control on it? Well, fear no more. I am going […]
Access installer Programs for Windows
http://www.bernardvukas.com/installer-alternatives-for-office-developers/ Bernard Vukas HELPING BUSINESSES DO MORE WITH MICROSOFT OFFICE & OFFICE 365 BY DEVELOPMENT OF CUSTOM SOLUTIONS. Skip to content Home Blog Portfolio About Contact Home » Blog » Installer Alternatives for Office Developers JANUARY 29, 2016 Installer Alternatives for Office Developers As one of the leaders of deployment and installer authoring solutions, InstallShield […]
Find and replace addin for Access
VTools AddIns [edit] V-Tools: 8 useful tools for Access developers Here is a set of tools for Access developers and users. Its name is V-Tools. It works like an Access add-in but you need to open the file as a normal Access file in order to start the intallation. V-Tools is available for Access 2000, […]
Convert Access Database to MySQL
http://www.bullzip.com/products/a2m/info.php Access to MySQL is a small program that will convert Microsoft Access Databases to MySQL. Wizard interface. Transfer data directly from one server to another. Create a dump file. Select tables to transfer. Select fields to transfer. Transfer password protected databases. Supports both shared security and user-level security. Optional transfer of indexes. Optional transfer […]
Connect Access database to Remote MySQL database
To connect to a local database (using MyODBC Driver)oConn.Open “Driver={mySQL};” & _ “Server=MyServerName;” & _ “Option=16834;” & _ “Database=mydb”To connect to a remote databaseoConn.Open “Driver={mySQL};” & _ “Server=db1.database.com;” & _ “Port=3306;” & _ “Option=131072;” & _ “Stmt=;” & _ “Database=mydb;” & _ “Uid=myUsername;” & _ “Pwd=myPassword”To connect to a local database (using MySQL ODBC 3.51 Driver)oConn.Open “DRIVER={MySQL ODBC 3.51 Driver};” & _ “Server=myServerName;” & _ “Port=3306;” & […]
Corrupt Microsoft Access MDBs FAQ
(Updated 2010/10/23) Make a backup! Before doing anything else. Preferably on another computer or CDR as a there is a slight possibility the hard drive in question is failing. A successful repair isn’t sufficient to ensure your data is clean. I’ve personally seen a 120 Mb backend MDB repair just fine but both compacting and importing […]
MS Graph Fix for Access Database / Report Chart
http://ourworld.compuserve.com/homep…p.htm#GRAPHGEN The columns in query need to be the same so add a blank column. Also Try: Inserting chart into NEW report. Removing the linked fields master/child worked for IPCA chart (put criteria in the query)Some of the most common questions related to Access reports involve problems with Microsoft Graph or formatting Graph presentations. Here’s […]