I have the following stored procedure in MySQL that reads a JSON array of objects and insert the objects in a JSON column of a temp table: DELIMITER $$ DROP PROCEDURE IF EXISTS proc_json $$ CREATE OR REPLACE PROCEDURE myProcedure(IN…
I am trying to create a Word VSTO Add-In that adds a commandbar on VBE permanently. My environment: windows 10 (language: Traditional Chinese), office 365 Visual Studio Community 2022 (64-bit) – 17.5.2, .Net Framework 4.8 I have modified the macro…
I have JSON data string from which I try to extract the highest value of "id" without iterating. This is the JSON data string: "ball_coordinates": [ { "id": 3938706, "fixture_id": 18795544, "period_id": 4644037, "timer": "17:20", "x": "106", "y": "57" },…
the guy from the Baptism database is here again. In Visual Studio it's easy but here I don't get it done. I have form with two textboxes: login and password. I have a button to check the info Both must…
Thank you for taking the time to read this. I am trying to use the LIKE operator to open workbooks. Previously I went with this code which works really well Report_Name = "XYZ.xls" Workbooks.open Filename:= ThisWorkbook.Path & Report_Name My main…
I want to upload a photo from my local machine (e.g. a jpg) to a Facebook page I am the admin on, using the Facebook Graph API (using Access VBA). I can post an image that is on the internet…
I need help in working with big Excel Tables. Description I have an export of Data from our ERP System that has 400K Rows at least. In this report the format is quite messed up and I want to write…
I have issue with filling up recordset. I stored this query into txt file: DROP TABLE IF EXISTS "temp_invoice_id_amount_1"; CREATE TEMPORARY TABLE "temp_invoice_id_amount_1" AS SELECT ROW_NUMBER() OVER() "RN", c."ID" "CaseID", p."ID" "PackageID", trim(concat(d."LastName", ' ', d."FirstName")) "FullName", c."ContragentCaseID", i."ID" "InvoiceID",…
Assumptions The EventLists sheet contains a list of events by day of the week and start time. The Master sheet contains a list of events by date. The Master sheet contains only one month's data. The Master sheet is sorted…
I have two excel files, one is an export from Shopify with all the data of my products. The other is a list of barcodes and quantities that are available from the supplier. I want to be able to modify…