completerealtyga.com

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.

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?

msaccessdevelopment.blogspot.com

MS Access Share: May 2012

http://msaccessdevelopment.blogspot.com/2012_05_01_archive.html

Efficient Design: Data Accessibility, Reporting, Business Intelligence, Useability. Tuesday, May 29, 2012. MS Access - A Cost Effective, Powerful Business Tool. MS Access is a powerful low-cost business tool that offers excellent ROI and fills many and varied business needs. With the Access Query Designer, complex multi-table queries can be created. Queries can also use VBA or user defined functions directly in queries for sophisticated analysis and updates. MS Access 2010 also includes the ability to de...