They're not very tricky or a shortcut really, but Debug-Compile, Option Explicit, and Compact and Repair definitely saves me more time in Access then anything else in finding troubleshooting problems lol.

The two that you've done that comes to mind first is the calendar opening over the date field, and being able to enter equations in my fields either by input box or your new method. Saves me having to open up my calculator all the time.

My Helper data combo boxes use a function in a global module that selects the correct helper data for the rowsouce based on the its name after I strip off the suffix "combo" and any trailing numbers.  Since it is in a function, the code copies and pastes with the combo box.  To get country names instead of state names, I just have to rename the combo from StateCombo to CountryCombo and double-click.

I have also found that using table names in alphabetical order in junction table names allows you to easily, dynamically build the junction table name from the form name and subform name.  My database has 4 main data tables, each with a many to many relationship to the other three.  Even though I have 12 form/subform combinations, I only have 6 junction tables and 4 subforms to manage.

Richard

I use your template 'Single Form' and 'Continuous Form' to save me the most time.  I have a VBA structure already setup in those templates which keeps me from retyping notes and organizing the code over and over again.

-Raymond

P.S. I'm still working on my Form Color Templates so I can have a quick select Form Themes from a ComboBox hidden on the Form.  That will save me time making the colors look nice together.  (Just need more time in a day, and not having to work so much)

-Raymond

Another trick I use all the time is being able to use the Shift or Ctrl when clicking a button to run different commands. I use this daily.

Your status function, lol, much faster for debugging than msgbox - especially in loops and continuous forms... although I did add a parameter "optional ClearStatus as Boolean = False". That way I don't have to bother adding a line before calling the function, just set this to true and it clears the text first.

Aside from that, I only create one form template for my projects. Once Saved, I go into Object Designers in the backstage and set that as the default form template. Then, no matter which type of form you choose in the ribbon, it will use those default settings. Then I hide that template in the navigation options so it doesn't clutter up the list of what I'm working on. It's faster than copy/pasting the form and, even if you use the "Form Design" button, it is easy enough to change to continuous form - and it even keeps things like "No Color" for alternate rows.

Same for basic report settings.

Im with Raymond, setting up a blank db with templates.

Programming date fields to read "+" and "-" and "T" to add a day, subtract a day, or make the date today.

Using the NewRecord property to change the SQL RowSource of combo boxes. Example: Only active employees should show up for new records but you have to see them all for existing records (who entered this order). Example: Only active shipping companies should show up for new invoices but you have to see all for existing records.

Having watched every course, every template, and every tech help video, and every quick query you have made, if I start listing all the things I use that you have taught, you will ban me from the site lol

Status Box
Helper Table
Form Templates
&
Using a large monitor.

Actually, my favorite is Access itself. To pin down just one item it would have to be the Backup code before closing the database, I use this on all my databases and it has saved me more times than I'd like to say.

I back up the front-end separately but the back-end with the data in it gets saved when the first user accesses the system every morning

My favorite trick is using actual SQL as the source of data instead of a query.

Good thing females are allowed to change their minds! I totally agree with John I have doBackup in the On close event of my form, and I can't even begin to guess how many times that backup has saved me after a small "nothing" change mess something up.

Top 5
I recently added the auto backup feature to all my databases at work (hasn't saved me yet, but give it time lol)
The HelperTypeT, used to try and do it all in one table instead of two working together
Creating a blank database with my preferred settings has been great. (Still adding to it)
and using SQL instead of a blue zillion mini queries

Joe was this in one of his videos? It's been on my mind recently as I use a database for my checkbook and a few businesses have folded. I don't want them in the dropdown, but I can't remove the records.

I do not remember if it was a video or not. (I have poorly named fields with spaces so I have to use the brackets for the field names. My database was made 30 years ago before I knew better.)

In my example, a Yes/No field called Active is used in the table containing the data. I made a query named Employee Listing Query to bring together the fields in the order I wanted. Employee is the name of the combo box.

The code changes the RowSource of the combo box based on the NewRecord property.

This code goes into the On Current event for the form.

    If Me.NewRecord Then
        Employee.RowSource = "SELECT [Employee Listing Query].Name, [Employee Listing Query].EmployeeID, [Employee Listing Query].Active FROM [Employee Listing Query] WHERE (([Employee Listing Query].Active)=-1)"
    Else
        Employee.RowSource = "SELECT [Employee Listing Query].Name, [Employee Listing Query].EmployeeID, [Employee Listing Query].Active FROM [Employee Listing Query]"
    End If

Recently viewed customer list. This saves a lot of time every day! SUPER helpful.

The extended cut of: https://599cd.com/blog/display-article.asp?ID=1602

One great trick I believe I first saw on the DevHut website is that you can create a blank table from an existing table with all the fields, but no data, by running a make-table query with a false criteria.  E.g.:

     SELECT * INTO [NewTable] FROM [ExistingTable] WHERE False

This way, a table will still be created, but no rows will be created, thus essentially making a blank table.

The indices aren't copied over to the new table, so you still have to create them.  But this is a quick way to duplicate a table for whatever reason, such as when you need a temporary table with the same fields.

That is a cool trick. I'd have just used a TableDef or Make Table query, but that is indeed much easier. Might have to steal that one. LOL

Something I have done for a while now, after I saw it in an Access lesson I watched on another site, is whenever I am building a continuous form, after I have pulled all the fields I want onto the form, I will select them all, go to the Arrange tab, and select Tabular.  This automatically takes all the labels and puts them in the header, and the controls are left in the detail section of the form, up at the top.  It allows you to rearrange the fields along with their associated labels, and once you pretty much have everything where you want them, you can select it all, click on Remove Layout, and now you can make any small adjustments to make the form look cleaner.  It has saved me a lot of time, especially when dealing with quite a few controls on one form.

Arlyn yeah someone showed me that a few years ago. I think I mentioned it in a video too at one point. I still prefer the hard way. I guess I'm just old school. Lol

I added "Enter calculations into a field" from Fitness 54 (https://599cd.com/blog/display-article.asp?ID=3743 and extended cut https://599cd.com/blog/display-article.asp?ID=3743) and it is very helpful. No more opening the calculator app. Love this!