Working with Access database via OleDbReader
Hey all I have no problem when all my access mdb are string! I'm using Access database engine 2010 to connect to mdb. The problem occurs when I have Boolean / Integer / Date fields: New OleDbCommand("INSERT INTO tableblah (strfield, intfield,…
Error 429 only if Outlook is already open when try to automate an email
Good day Gurus of .Net Since I started trying to get my app to be option strict compliant, I've suddenly started getting error 429 Unable to create active x component BUT only when Outlook is already open. I have the following code to get an instance of…
How to lose the focus of the selected cells when it is done with the 'Clipboard.Clear()' command in Visual Basic?
hi Private Sub tsmFillNumberMerged_Click(sender As Object, e As EventArgs) Handles tsmFillNumberMerged.Click 'Trying to (Fill Auto Namber) cells when they are merging If Clipboard.GetText IsNot Nothing Then Dim sttClip As…
VB.NET SQL Connection and SQL Command Error BC3002
Hello, I'm in the process of converting VBA to VB.NET with SQL statements. One of the changes is utilizing the "ExecuteNonQuery". Since I'm still learning the syntax, I simply copied the VB.NET statements from a web-site. But I'm getting 2…
Check self signature status
Hello Using VB.net or C# .net framework 4.0, is it possible to add a self check for the digital signature of assembly file? So assembly file should check itself to make sure if it's signed using my code signing certificate and if not, or file is modified…
Binding Errors in a Simple Project
I have carved out a simple project from a larger one to demonstrate the binding errors I am getting so the names I use might seem ... odd. The following is the ENTIRE project: Window…
How to add a MaskedTextBox On The ToolStrip
hi . Is such a thing possible?
Allow firewall via registry instead of netsh?
Hello Going to allow an app through Windows firewall in vb.net Instead of using: netsh advfirewall firewall add rule name="blah" dir=in action=allow program="C:\Program Files\blah\App.exe" enable=yes May I just add this registry…
How to Get Description of Column_Flags by function GetSchema
hi . What are these numbers and how can they be translated? Dim cn As New OleDb.OleDbConnection(Conn_String_Access) cn.Open() Dim dtSheama As New DataTable dtSheama = cn.GetSchema("Tables") 'indexes'columns'Tables
RemoveRegistry Table in MSI
Hello In MSI project installer, I need to remove these 2 values from…
Why VB.Net projects that were working OK suddenly fails to start now?
Hi all, I have written many trial projects using VS 2013, VS 2019 and they were working fine for few years; Since the 1st week of March 2024, when I click "Start Debugging" / "Start without Debugging" any of those projects in Visual…
For Each Drive in batch file
Hello These commands inside a .bat batch file will disable bit locker for C:, D:... manage-bde -off C: manage-bde -off D: ... Is it possible that using batch file (not powershell) I loop through existing drives and run the above command for each drive in…
ADD Column will not show CheckBox
Hello, Using Access database engine + oledbreader on mdb, this code will add a new boolean yes/no column: New OleDbCommand("ALTER TABLE BlahTable ADD Column BlahOption BIT NOT NULL", strConnection) :: ExecuteNonQuery This will add a yes/no…
SSIS script is aborting sometimes with Directory Not Empty error message.
Recently we have been getting an error with our SSIS package. Error happens sometimes, not always. The package has been running without any error since begining. SSIS Script Task Error - Failed to compiled scripts contained in the package. Open the…
ManagementObjectSearcher will fail in some conditions
Hello I use this code to get some hardware info, ie MyQuery("BusType") etc: Using MySearcher As New ManagementObjectSearcher("root\Microsoft\Windows\Storage", "SELECT * FROM MSFT_PhysicalDisk WHERE DeviceId = 1") Using…
import export xml
Hello Using Access database engine and OleDbDataReader I need to open a table, read all columns of a single row and save the data in xml, or import back to the database. Using MyConnection As New OleDbConnection(dbstring) MyConnection.Open() Using…
GZipStream to compress/extract 2 files
Hello Here's an excellent sample to zip and unzip a single file using GZip: https://learn.microsoft.com/en-us/dotnet/api/system.io.compression.gzipstream?view=netframework-4.0 Any idea how to include 2 files to compress and how to extract them back?…
VB.net desktop Forms App //Trojan:Win32/Wacatac.B!ml
Hi, I have created a VB forms application. Surprisingly it was detected as Malware by Windows Defender. This app was created a while ago, but recently it was counted as : Trojan:Win32/Wacatac.B!ml Any thoughts?
Read comments with XDocument
Hey This is the xml I have: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <!--Comments Are Just Here--> <TheOnlyNode> <ID>15</ID> ... </TheOnlyNode> There's only one single…
Why isn't Visual Basic developed like C#?
In fact, I feel very upset with Microsoft's strategy towards the Visual Basic language. You are practicing euthanasia for this language and losing a large base of programmers who prefer to deal with this language. You have wasted the expertise of these…