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
Posts belonging to Category Tip of the Week
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 […]
‘Tis the season of joy – and hackers trying to steal your personal information! Scammers are sending out emails to unsuspecting users that state that their package could not be delivered – with the hopes that you will click on the links embedded in the email… USA Today article: http://www.usatoday.com/story/tech/news/2016/12/08/fake-package-delivery-notices-christmas-malware-ransomware/94631888/
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.
The latest J Street Buzz – When Customer Service Makes All the Difference
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.
Here is a link to a really good article on computer security from the Federal Trade Commission: https://www.consumer.ftc.gov/articles/0009-computer-security
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.
Here is a terrific article (with helpful links!) provided by the The Federal Trade Commission (FTC), the nation’s consumer protection agency. Stopping Unsolicited Mail, Phone Calls, and Email