Simple Math Opertation
Hello I need to calculate how many parts an SMS text is, the text is US Ascii so here's the long code with minimum of 15 lines: .Length > 0 AndAlso .Length <= 160 Then Return 1 .Length > 160 AndAlso .Length <= 320 Then Return 2 .Length >…
How to disable "the attachment is open. don't forget to save the file if you made any changes" error in outlook auto save macro. Every time any new attachment received i got this error
I have a remote system which was working fine for last 3 years but suddenly i am started to received attached error when any new item received in Outlook. My outlook have macro which save all the attachement in specified folders but this error have…
How to extract part of the text from the line with a special format
hi Bolded areas need to be extracted. I don't know how to use Regex library. my Format [One of the tags] is Sample '10LBA04CT004-XQ01' Start text with 150,000 lines and have different tags. thank { N 3-SH 3-sh 3-sh 3-SH N 10LBB09 EQUIPMENT =…
Select Delete commands
Hello, I've been given this samples for insert into and update: Using command As New OleDbCommand("INSERT INTO Table (Column1) VALUES (?)", connection) command.Parameters.AddWithValue("@param1", field1) …
Can I put a cell into the subject line of an auto email from excel?
My job has an excel sheet for employee attendance tracking that send out an email when an edit has been made. However, currently the email subject just shows the name of the sheet (ex. 05-10-24 attendance infraction) and then the email prompts you to…
Define Thread
Hello, In this code: Dim ThreadBlah As New Thread(AddressOf BlahThread) vs Dim ThreadBlah As New Thread(New ParameterizedThreadStart(AddressOf BlahThread)) ThreadBlah.Start Private Sub BlahThread(ByVal InParam As Object) ... End Sub I can define…
How to get the index of duplicate elements along with the range of empty elements after it. LINQ
hi Dim ComplexArray As String() = Split("A C A B C A B A B C") Dim Arr3D = {({"A", ({"0-2", "5-9", "16-16", "19-20"})}), ({"B", ({"10-12",…
Why is Copy / Cut / Paste NOT working in RichTextBox? It works my previous projects.
Hi All, I am unable to "Copy" the text output in a RichTextBox in a project created in Visual Studio 2013. In my previous projects, I can "Copy" text from RichTextBox. I found out on Googling that for RichTextBox, it is necessary to…
How to get the range index of repeated elements. LINQ
Thank Dim MyArray as String()={"A","A","A","B","B","C","A","A"} 'Need Result as Array 0-2 3-4 5-5 6-7
How do I stop an MDI parent form from being resized when moved ?
I have an MDI form (VB.net) which contains about 10 child forms which are permanent and fixed in place and which take up nearly all the whole parent form except for a small margin around the edges and between child forms of about 2px. When I move the…
Add a row to a TableLayoutPanel at runtime with a textbox in each cell of the row
I've tried and tried to add a row to a TableLayoutPanel but I can't. Can anyone tell me a tutorial to do this? Thank you Fabrizio
How do I add a CAPTCHA to a web site written with ASP.NET/VB
A bot seems to be using my web site to send out emails via AmazonSES. I want to add a CAPTCHA to it to prevent this. I came across https://stackoverflow.com/questions/71515717/how-to-add-captcha-in-asp-net-project which appears to be what I want, but…
How to get the length of strings in array elements LINQ
Dim MyArray as String()={"AB","ABC","DFG"} Need Result Dim int1 as Integer=8
Excel script for filling cells within a specified range with a specific fill color if any cell within the range is selected
Using scripts in Excel (NOT VB macros), I need to be able to fill any cell within a specified range with a specific color if any cell within the range is selected ("clicked on"). Note that the spreadsheet will have different columns that need…
UPDATE fields
Hello, This works when using insert into: Using command As New OleDbCommand("INSERT INTO Table (Column1) VALUES (?)", connection) command.Parameters.AddWithValue("@param1", field1) command.ExecuteNonQuery() …
WebView2 fit to page
I am using a WebView2 control in a WinForms app. It is working fine. However, I'd like the "Fit to Page" button sizing to be the default when a PDF file is displayed in the WebView2 control. How do I make this the default setting in my VB.net…
How to convert normal date to solar date(PersianCalendar)
with System.Globalization.PersianCalendar NameSpace Need function to convert to solar date
Opening a Window Using Its Name
From my MainWindow I am trying to open another window knowing only its name. In my MainWindow ViewModel, I have: Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (lpClassName As String, lpWindowName As String) As…
Declaration expected
Public Module GlobalVariables Public gDataGridShowing Public gDatabase As String ```End Module Public Class Form1 gDatabase = "ganswind" **<<< error "Declaration expected"** Function HideMenuPoints(ByVal…
efficient way to add csv to database
Hello I read a csv text file line by line and use oldb sql command insert into table to add each line's fields to the table's row. But it takes a very long time, I wonder if there's faster achievements, please advise the most efficient and fastest way to…