Posts belonging to Category Tip of the Week

Developer Download: Report Selection Techniques

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

Developer Download: The Best of Both Worlds: Access-SQL Server Optimization

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 […]

Fake “FTC investigation” email making the rounds again

https://www.consumer.ftc.gov/blog/fake-ftc-investigation-email-making-rounds-again

Beware Of Scam Package Delivery Emails!

‘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/  

Free Developer Download: User Interface Guidelines

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.

J Street Buzz – When Customer Service Makes All the Difference

The latest J Street Buzz – When Customer Service Makes All the Difference

Developer Download: Data Dictionary Report Utility

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.  

FTC Article: Computer Security

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

FREE Developer Downloads: Cool Tools

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.

Stopping Unsolicited Mail, Phone Calls, and Email

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