Limit the rows in Access table
Hello Is it possible to limit the number of rows in each Access mdb database table? Will need to apply the limitation via VB.NET OLEDB and using Access database engine. Thanks.
![](https://techprofile.blob.core.windows.net/images/oZy-DvHL5UC1mJTFG3q7Zw.png?8D8D1D)
Copy List Of String to another List Of String
Hello I need to know the difference between the 3 paths to my goal: Dim MyList as New List(Of String) MyList.Add(str1) ... and so on ... Dim NewList As New List(Of String) Now I have 3 ways: 1 NewList.AddRange(ResumeFailed) 2…
WebClient via EndPoint
Hello When using WebClient to send and/or receive data, how can I pass an EndPoint instance to the WebClient to connect via the specified IP and…
![](https://techprofile.blob.core.windows.net/images/J_TYKjg7AEiX7AvF9jc5sA.png?8D8651)
Make KeyChar Accept Decimal
Hi I am trying to build a custom calculator to make my data entry more efficient. I am trying to limit a textbox in Visual Basic to only accept one decimal point. So far this code only accepts integers and the Backspace button. Dim Ch As Char = e.KeyChar…
Make Class disposable
Hello, Here's a class I use to log off the user, etc, the usage: Dim IExitWindows As New WinExitClass IExitWindows.PowerOffWindows() How can I make this class disposable? Couldn't figure out how to add disposable so instead of: Dim IExitWindows As New…
![](https://techprofile.blob.core.windows.net/images/J_TYKjg7AEiX7AvF9jc5sA.png?8D8651)
.net framework forward compatibe?
Hello, my app in .net framework 4.6.1 runs on Windows 8.1 with .net 4.5.1, but why? On a new Win8.1 setup, .net framework 4.5.1 is pre-installed, but I have set my app to require minimum .net 4.6.1, so why it should run on lower .net versions? Very…
Get data with post method using webclient
Hello There's a POST sample at the bottom of this page: https://ws.interfax.net/admin.asmx?op=GetAccountPPCardsBalance2 Sample HTTP POST request and response. The placeholders shown need to be replaced with actual values. POST…
Show form from thread
Hello, How can I call / invoke this code from inside thread? Using F As New blahForm F.Text = "xyz" F.Tag = "abc" F.ShowDialog(Me) End Using I think Invoke(Sub() ...) is single line command? If InvokeRequired then... Thanks :)
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",…
![](https://techprofile.blob.core.windows.net/images/hBj0LQgf0UCJ70ENoTldCA.png?8DB7E4)
How can I open Microsoft Excel in Visual Basic.NET
I am using Visual Studio 2023 for using Visual Basic. I have latest version of Microsoft Office. I want to open Excel using Visual Basic (not VBA). Please tell me how to go about it. It is very important for me.
Webrequest populate UserAgent and Headers
asp net version 2.0 asp.net forms with vb.net Dim strData As String = String.Empty Dim wr As HttpWebRequest = Nothing Dim wrRes As HttpWebResponse = Nothing wr = DirectCast(WebRequest.Create(URi),…
Query is too complex.
Hello To delete many selected records at once: In a loop I populate question marks: QuestionMarks = QuestionMarks + "?, " Then: "DELETE FROM table WHERE theID = ? AND fld IN (" + QuestionMarks + ")" And: For Each MyRow As…
Memory access violation when writing a combobox in Visual Basic
I've had a program since 2004. I've been updating it since then. The GUI is in Visual Basic. Suddenly a statement that simply takes the text from one combobox and puts it in a second (invisible) combobox is giving me a memory access violation during…
Rename mdb table
Hello I use Access Database Engine and OleDbReader to work with mdb and accdb files, need to rename a table: ALTER TABLE <table name> RENAME TO <new table name> OleDbException, anyway using ADE? Thanks
VB support in VisualStudio 2022 for ASP.NET Core Web App
Hi, There is no more Visual Basic support in Visual Studio 2022 for ASP.NET Core Web App? Is Visual Basic EOL program language now and their will be no future support for it? Thx
Simple program using a Background Worker freezes anyway
Program gets every filename from a folder, then creates a text list of unique extensions found and the frequency. In this case there are around 35000 files. I put most of the work into the Background Worker but the UI freezes anyway until it is finished.…
FileIO.TextFieldParser
Hello, Dim Blah As New FileIO.TextFieldParser(src) MyTextParser.TextFieldType / .SetDelimiters / .TrimWhiteSpace etc While Not MyTextParser.EndOfData Blah.ReadFields()... End While Before entering the While loop, how can I get how many times this…
DataGridView column alignment header vs data
In the pic below, the DataGridView column header (Column1) is misaligned with the data cell text below it (XXX). The misalignment is nearly one character width. It is more visually obvious with a larger font. The pic comes from a minimal Forms app. …
How to get specific image coordinates from within bitmap
hi Is there a special (Library/Class) for such an achievement? which can find and return the coordinates by giving a symbol of a specific image from within the larger image
![](https://techprofile.blob.core.windows.net/images/hBj0LQgf0UCJ70ENoTldCA.png?8DB7E4)
Integer equivalent in Access
Hello I work with Access mdb with OleDbRader (Access Database Engine) in vb.net and need to set the data type to Integer (NOT Long Integer) so: Dim cmd As New OleDbCommand("ALTER TABLE Blah ALTER Column colm ???",…