Order By or Order By On First, Access DB on the Web

In this Microsoft Access tutorial, I will show you how to handle common questions from users, including setting the OrderBy property in the correct sequence, understanding the difference between Subs and Functions in VBA, using the Tag property effectively, and addressing issues with background color changes on controls. I also answer questions about using Access for payroll systems, discuss web-based database alternatives, and talk about features like the tree view control. Along the way, you'll hear some light moments about working with ChatGPT and tips for troubleshooting internet connections in an office setting.

Prerequisites

• Quick Queries Listing
• Quick Queries #36

Links

• Click to Sort
• Tag Property
• Create Function
• Edit Mode 2
• Ethernet & WiFi
• Export Reports to PDF
• Access Online
• Access SQL Server Online
• TreeView in Access Developer 20

Recommended Courses

• Access Developer Courses
• Access Beginner 1

Up Next

• Quick Queries #38

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, OrderBy property, OrderByOn property, OrderByOnLoad, sort form records, form sorting VBA, Tag property uses, Tag property character limit, store data in Tag, control type checking VBA, error handler On Error Resume Next, checking BackColor property, sub vs function VBA, custom VBA functions, Access class modules, tree view ActiveX control, storing SQL Server tables, web-based Access front end, connect Access to SQL Server, Access ASP web forms, prioritizing Wi-Fi over ethernet, Access database for payroll, hotspot internet backup, ChatGPT cleaning grammar, forbidden characters m-dash curly quotes, Access control coordinates in Tag, smoke alarm random beeping, polite chatbot interaction, training AI communication style, Star Trek references in Access videos