Posts belonging to Category Developer Downloads
March 28, 2017
Two different examples of a pop-up report selection criteria form. This technique is great for allowing the user to choose which records will appear on a report, without using parameter queries. Other report techniques (like hiding and showing report sections) are shown also. Access MDBs and PowerPoint presentation, 800k. http://www.jstreettech.com/files/Report-Record-Selection-Techniques.zip
Categories: Developer Downloads, JStreetTech, Tip of the Week
| 
No comments
February 14, 2017
The Best of Both Worlds: Access-SQL Server Optimization http://www.jstreettech.com/files/Best-of-Both-Worlds.zip Access can be used to build great front-end applications for SQL Server databases, as long as you know how to optimize for performance. This slide deck shows you the basics of using Access as a client-server application so that you can leverage the full power of […]
Categories: Access, Developer Downloads, JStreetTech, SQL Server
| No comments
February 8, 2017
Access Security Basics: http://www.jstreettech.com/files/AccessSecurityBasics.pps Access User Level Security (ULS) has been deprecated for the ACCDB file format, but many people are still using ULS for their legacy Access MDB applications. Here is a PowerPoint slide deck that Armen Stein, President of J Street and Access MVP, has presented to Access user groups. It describes various […]
Categories: Access, Developer Downloads
| No comments
January 23, 2017
Access Security Basics Access User Level Security (ULS) has been deprecated for the ACCDB file format, but many people are still using ULS for their legacy Access MDB applications. Here is a PowerPoint slide deck that Armen Stein, President of J Street and Access MVP, has presented to Access user groups. It describes various approaches […]
Categories: Developer Downloads, JStreetTech
| No comments
January 4, 2017
The Best of Both Worlds: Access-SQL Server Optimization: http://www.jstreettech.com/files/Best-of-Both-Worlds.zip Access can be used to build great front-end applications for SQL Server databases, as long as you know how to optimize for performance. This slide deck shows you the basics of using Access as a client-server application so that you can leverage the full power of […]
Categories: Access, Business & Tech, Database Design, Developer Downloads, JStreetTech, SQL Server, Tip of the Week
| No comments
December 8, 2016
User Interface Guidelines Also known as “Beauty Is Only Skin Deep, But It Gets You Asked To Dance!” It’s our approach to designing consistent, professional-looking forms. Word, 64K.
Categories: Business & Tech, Database Design, Developer Downloads, JStreetTech, Tip of the Week
| No comments
November 16, 2016
Data Dictionary Report Utility Can’t get the built-in Access database documentation tools to give you the simple report you want? Here’s the answer. This utility documents all the tables and fields in your database, linked or local, including field descriptions! Access MDB, 44k.
Categories: Business & Tech, Database Design, Developer Downloads, JStreetTech, Tip of the Week
| No comments
October 12, 2016
A sampler of labor-saving code and cool usability enhancements. Includes QuickDate, a “Quicken-style” method of using keys to increment date fields by day, week, month and year, and some handy name and address concatenation functions. Comes with a form demonstrating most of the tools – look in the code for more! Access MDB, 48k.
Categories: Business & Tech, Developer Downloads, JStreetTech, Tip of the Week
| No comments
October 5, 2016
This is the PowerPoint slideshow that Armen Stein, President of J Street, presented to the KEGS Access SIG. It shows how to tackle the problem of converting old “flat” data (from Excel, text or wherever) to your relational Access tables. Includes a sample database showing the techniques mentioned in the slides. PowerPoint, Access MDB, […]
Categories: Access, Business & Tech, Database Design, Developer Downloads, Tip of the Week
| No comments