msaccessdevelopment.blogspot.com
MS Access Share: July 2012
http://msaccessdevelopment.blogspot.com/2012_07_01_archive.html
Efficient Design: Data Accessibility, Reporting, Business Intelligence, Useability. Saturday, July 21, 2012. MS Access Designing and Deploying for Efficiency. Split your application into front-end/back-end architecture:. A split architecture has long been suggested and I have used it and found it improves performance, minimizes collisions and corruption, and makes support and program enhancements so much easier. How to split an application:. Establish a Persistent Connection:. You can greatly enhance per...
msaccessdevelopment.blogspot.com
MS Access Share: Sharepoint Access Services Reporting Flexibility
http://msaccessdevelopment.blogspot.com/2011/11/sharepoint-access-services-reporting.html
Efficient Design: Data Accessibility, Reporting, Business Intelligence, Useability. Sunday, November 6, 2011. Sharepoint Access Services Reporting Flexibility. Here's what I came up with:. In this way I was able to offer reports on multiple lists and have included 3 additional criteria (state, district, active). I reviewed the templates Microsoft offers for Web Databases, and the Northwinds Web template and I believe what I have designed has more flexibility/options for reporting all in Sharepoint (don't...
msaccessdevelopment.blogspot.com
MS Access Share: April 2012
http://msaccessdevelopment.blogspot.com/2012_04_01_archive.html
Efficient Design: Data Accessibility, Reporting, Business Intelligence, Useability. Sunday, April 29, 2012. MS Access to Oracle ODBC Connection. I recently had an adhoc reporting project using MS Access querying Oracle tables via ODBC. Thought I would share the process for anyone that might need it. Though I could make the connection read/write, for safety and because I didn't need to make any changes to the Oracle data, a read-only connection was made. Here's the basic overview:. 8226; In the “Sys...
msaccessdevelopment.blogspot.com
MS Access Share: MS Access SharePoint Attachment Field
http://msaccessdevelopment.blogspot.com/2012/04/ms-access-sharepoint-attachment-field.html
Efficient Design: Data Accessibility, Reporting, Business Intelligence, Useability. Sunday, April 29, 2012. MS Access SharePoint Attachment Field. I recently tested a project that is a good candidate for MS Access on Sharepoint. It is an ongoing project keying records daily from scanned images and would require at least 3 keyers daily. The advantages are obvious: ability to work remotely, centralized administration, and flexibility to distribute or redistribute work flow. Dim strFile As String. Set db = ...
msaccessdevelopment.blogspot.com
MS Access Share: January 2009
http://msaccessdevelopment.blogspot.com/2009_01_01_archive.html
Efficient Design: Data Accessibility, Reporting, Business Intelligence, Useability. Friday, January 9, 2009. It's a tough economic market and this company had previously started this project with a subsidiary company of a very large corporation. They went bust, leaving them with a failed project to start over. The moral of the story is: size may matter but it doesn't guarantee success. If at first you don't succeed, try try again. Posted by Bonnie Hicks. Subscribe to: Posts (Atom). My Profile on LinkedIn.
msaccessdevelopment.blogspot.com
MS Access Share: December 2009
http://msaccessdevelopment.blogspot.com/2009_12_01_archive.html
Efficient Design: Data Accessibility, Reporting, Business Intelligence, Useability. Wednesday, December 16, 2009. We Are a Google Favorite Place! It's been almost a year since I posted (shame on me). Still here after 15 years. We have been staying busy with a large project collecting police accident reports and validating the VINs. Been promised more to come and glad of it. Posted by Bonnie Hicks. Subscribe to: Posts (Atom). The Microsoft Office Blog. Tony's Microsoft Access Blog. My Profile on LinkedIn.
msaccessdevelopment.blogspot.com
MS Access Share: June 2012
http://msaccessdevelopment.blogspot.com/2012_06_01_archive.html
Efficient Design: Data Accessibility, Reporting, Business Intelligence, Useability. Thursday, June 14, 2012. ActiveX Controls to Enhance MS Access Functionality. ActiveX is a Microsoft technology that offers components to insert into programs or web pages, similar to JAVA applets. Here's Microsoft's description of ActiveX Controls ( http:/ support.microsoft.com/kb/154544. With sophisticated formatting features and animation. In other words, ActiveX controls are mini-programs that can be inserted into, sa...
msaccessdevelopment.blogspot.com
MS Access Share: April 2010
http://msaccessdevelopment.blogspot.com/2010_04_01_archive.html
Efficient Design: Data Accessibility, Reporting, Business Intelligence, Useability. Thursday, April 8, 2010. Go Where the Work Takes You. I have been awarded several MS Access database development projects of late that I would like to share:. The third project is for an association that promotes a food product. Though I am modifying and adding to an existing application, I and the original programmer seem to approach the process similarly. I can more quickly understand where he is going.
dataplus-svc.com
Business Resources - MS Access Developer
http://www.dataplus-svc.com/resources.htm
Data Entry, Document Scanning and Business Process Outsourcing to SUPPORT your BUSINESS. JVG Civil Engineers, Inc. Marthas Vineyard Custom Masonry. MS Access Share Blog.
msaccessdevelopment.blogspot.com
MS Access Share: November 2008
http://msaccessdevelopment.blogspot.com/2008_11_01_archive.html
Efficient Design: Data Accessibility, Reporting, Business Intelligence, Useability. Saturday, November 1, 2008. Being Prepared When the Opportunity Arises. So I had been awarded a job capturing names and addresses from Kids Club applications for Burger King Corporation. Burger King had 6,000 franchisees at the time and each was a distribution point for these applications. This was huge! Okay, we're ready, where's the work? Yes, ma'am.". Have you had any memorable job experiences you can share?