Problem: In “Stock Card” table, it records the stock movement, “In” and “Out”  of each item (ITEM ID).  There are different items that belongs to same group (GROUP).  And there are many groups (GROUP).

How to get the sum (TOTAL BALANCE) of each group as below?

Solution: using this SQL statement

SELECT `Group`,
(SELECT COUNT(Stock_Description.`Group`) FROM Stock_Description WHERE Stock_Description.`Group` = sd.`Group`) As `TOTAL RECORDS`,
(SELECT SUM(COALESCE(a.`IN`,0) – COALESCE(a.`OUT`,0)) FROM Stock_Card a WHERE a.Item_ID LIKE CONCAT(sd.`Group, ‘%’) AND a.Balance IS NOT NULL) AS `TOTAL BALANCE` FROM Stock_Description sd GROUP BY `Group`;

SELECT SUM(COALESCE(a.`IN`,0) – COALESCE(a.`OUT`,0)) FROM Stock_Card a WHERE a.Item_ID LIKE CONCAT(sd.`Group`, ‘%’) AND a.Balance IS NOT NULL) AS Total_Balance

the above SQL statement will display  a “TOTAL BALANCE” of each “GROUP” by:-

• summing all “In” records of “EKONOR” minus the sum of all “Out” of EKONOR”
  • (20 + 40) – (10 + 10 + 20)
  • = 20
• summing all “In” records of “SAGA” minus the sum of all “Out” of  “SAGA”
  • (10 + 5 + 10 + 10) – (5 + 20)
  • = 10

SELECT COUNT(Stock_Description.`Group`) FROM Stock_Description WHERE Stock_Description.`Group` = sd.`Group`) As `TOTAL RECORDS`

the above SQL statement will display  a “TOTAL RECORDS” of each “GROUP” by:-

• summing all records in “EKONOR” group
• summing all records in “SAGA” group

Source:-

• COALESCE MySQL function — https://docs.microsoft.com/en-us/sql/t-sql/language-elements/coalesce-transact-sql?view=sql-server-ver15
• CONCAT MySQL function — https://www.w3resource.com/mysql/string-functions/mysql-concat-function.php

Determine whether the application saves the user settings on exit.

The SaveMySettingsOnExit property allows the user to change how the application saves settings, at run time. You can explicitly save setting changes by using the Save method of the My.Settings object.

The changes to this property are not persisted when the application closes. To change the SaveMySettingsOnExit property permanently, you must change the setting in the Project Designer:

There are two types of application settings, based on scope:

• Application-scoped settings can be used for information such as a URL for a web service or a database connection string. These values are associated with the application. Therefore, users cannot change them at run time.
• User-scoped settings can be used for information such as persisting the last position of a form or a font preference. Users can change these values at run time.

The path that store My.Settings config file differ depends upon the scope that has selected and the Visual Studio version. For Microsoft Visual Studio 2008 Version 9.0.30729.4462 QFE, the config is stored in:

C:\Users\<username>\AppData\Local\<companyname>\<appdomainname>_<eid>_<hash>\<version>\user.config

Source:-

• https://stackoverflow.com/questions/8691858/where-are-my-settings-saved-in-vb-2010-net#:~:text=They%27re%20definitely%20not%20stored,in%20the%20%25AppData%25%20folder.
• https://docs.microsoft.com/en-us/dotnet/visual-basic/developing-apps/programming/app-settings/how-to-read-application-settings
• https://docs.microsoft.com/en-us/dotnet/api/microsoft.visualbasic.applicationservices.windowsformsapplicationbase.savemysettingsonexit?view=netframework-4.8
• https://docs.microsoft.com/en-us/visualstudio/ide/managing-application-settings-dotnet?view=vs-2019

1. Open LibreOffice that containing the macro
2. Click “Tools” -> “Customize…”
   
3. In Customize, Click “Keyboard” tab and scroll down the “Category” section until you find “LibreOffice Macros“. Select the macro.
   
4. Select the function that you want to assign the shortcut key in “Function” section and find the available keys in “Shortcut Keys” area. Select the key and click “Modify” button. Click “OK”
   

Conclusion: Hotkey (AutoHotkey) can have a maximum of 1 character key (alphanumeric)  only, e.g.

• ^1 — accepted
• ^10 — fail

In order to use more that 1 character key, then refer to https://mobitek-system.com/blog/2020/06/autohotkey-how-to-define-2-alphabet-keys-as-hotkey/

Continue reading →