Totals Not Saved: Why Storing Calculated Values in Microsoft Access Can Cause Problems

  Рет қаралды 1,351

Computer Learning Zone

Computer Learning Zone

Күн бұрын

Пікірлер: 5
@Shadow.Dragon
@Shadow.Dragon 13 күн бұрын
Richard, great video! I have a db where I store a "totals" field in the main table. Looking forward to the extended cut to see if I did it correctly. 🙂
@599CD
@599CD 13 күн бұрын
Great idea!
@AzizAhmadMohammadi-z4y
@AzizAhmadMohammadi-z4y 7 күн бұрын
Hi Richard 👋 Me make my dB 80% but I need Cancel ,Save and not save method in continu Sub form😢 Please upload This Method learning video For Free😊 Please 🙏
@GreyPaSM
@GreyPaSM 6 күн бұрын
Although I agree that queries are a good method of getting a line total, I find that storing the totals in the table really optimize the database by leaps. What I usually do is have an Edit Form so when an invoice or order needs to be adjusted the user can use that. Add some vba after some events and presto, Totals are recalculated. Also, the Edit Form can be used to add other stuff to the primary table like: -Last Edited Date -Edited By User -Reason for Edit Great for the audit trails. This is frown upon by developers but screw that, optimization over tradition any day of the week I say.
@599CD
@599CD Күн бұрын
599cd.com/QQ
Chain Game Strong ⛓️
00:21
Anwar Jibawi
Рет қаралды 23 МЛН
VIP ACCESS
00:47
Natan por Aí
Рет қаралды 9 МЛН
黑天使被操控了#short #angel #clown
00:40
Super Beauty team
Рет қаралды 53 МЛН
How to Display Text Instead of ID Numbers in Microsoft Access Combo Boxes
18:39
Computer Learning Zone
Рет қаралды 1,2 М.
Inserting and Customizing Shapes with Transparent Backgrounds in Microsoft Access
15:18
5 Microsoft Teams Productivity HACKS
23:18
Labyrinth Technology
Рет қаралды 3,2 М.
SQLModel + FastAPI: Say Goodbye to Repetitive Database Code
19:50
How to Push, Pull, or Populate a Value Between Forms in Microsoft Access
17:41
Computer Learning Zone
Рет қаралды 2,7 М.
How to Remove Time Part from a Date/Time Field in Microsoft Access
16:15
Computer Learning Zone
Рет қаралды 979
Change These 10 Settings Before You Use Excel Again
12:44
Kenji Explains
Рет қаралды 49 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 917 М.
Download Microsoft Access for Free? Don't Fall for the Illegal Scams!
18:41
Computer Learning Zone
Рет қаралды 1,7 М.
Chain Game Strong ⛓️
00:21
Anwar Jibawi
Рет қаралды 23 МЛН