Search:

One possible issue is that DataGridView1.CurrentRow.Index might not return the correct value (as clicking a cell might not set CurrentRow before the event is fired), so you should be making use of...

There are some fonts (such as Arial) which have a 'black' (ultra-bold) variation.

You can only use the 'black' variation if the font already contains it - you can't create it with .Net (except...

There is actually an issue with attachments on the forum at the moment.

If you use the features in the "Quick Reply" area they don't attach properly, but you can add attachments via "Go Advanced"...

For Access-based databases you need to write the joins in a slightly different way to most database systems, and put brackets around each join, like this:

.. FROM (TableMain Main INNER JOIN...

I have moved this thread to our 'Application Deployment' forum

You generally should not write to the app directory, and generally wont be able to - as Windows will block writing to protected folders (such as ProgramFiles etc), because that is what malware will...

From what I understand, the Community edition is almost identical to the Professional edition, just with different license terms (free for personal use and small business).

They have a decent...

Modern versions of VS (since 2017 or possibly earlier) do have the option to log in, but I think you don't actually need to log in. I did log in (so settings get shared wherever I use VS), but the...

As a general rule "far left" messages tend to be along the lines of "treat people from group-x as people", whereas a "far right" message tends to be along the lines of "treat people from group-x...

Welcome to VBForums :wave:

I have moved this thread from our VB.Net forum to our C# forum.

But you didn't delete Dim here if you mean this (In thick letters)?
[/QUOTE]That line of my post was referring to your save routine... meaning that you should use just the Dim I showed (which...

Your code in post #8 would be changed to this:

Dim hexString4 As String = Nothing

Private Sub InvisibleButton_Click(sender As Object, e As EventArgs) Handles InvisibleButton.Click
...

The problem there is that you have declared hexString4 inside each of the routines - and variables declared inside a routine only exist inside that routine (the ones inside other routines are...

A date value without a time is counted as being midnight, so your from/to dates are treated as:

From Date: 5/5/2022 0:00
To Date: 5/7/2022 0:00

This means that you will get all rows where...

There is a good debugging tutorial (with mini-videos where apt) here:
https://docs.microsoft.com/en-gb/visualstudio/debugger/navigating-through-code-with-the-debugger

You probably want to start...

We wont really need to learn new languages... there is already technology to translate spoken conversation in almost real time (and it will get faster and more accurate), so far fewer people will...

You can only do that when you are a PowerPoster (after 2000 posts I think).

Presumably the GUID is being interpreted as an index to the Dictionary (or perhaps as a parameter to the default method of a dictionary).

If that is the case, I would expect the item returned by...

How a stopped car is dealt with depends on various factors, primarily can the marshalls remove the car without risking themselves.

In this case it seems that they had all the...

I have moved this thread from the VB.Net CodeBank forum (which is for working code samples, not questions) to the VB.Net forum

I have moved this thread from the VB.Net CodeBank forum (which is for working code samples, not questions) to the VB.Net forum

Are you the Angle of Cod? ;)


edit: it seems you are: https://www.vbforums.com/showthread.php?895688-problem-with-Microsoft-ACE-OLEDB&p=5561199#post5561199

I don't know about that, but I have spotted an issue in the error message that is easy to overlook:

Microsoft.Reporting.WebForms.ReportParameter
Microsoft.Reporting.WinForms.ReportParameter

...

You should also specify the names of the fields, eg:

Insert into Table1 (field1, field2, field3, ...) Values(value1, value2, value3, ...)
Doing that avoids a wide variety of issues, including...

Welcome to VBForums :wave:

The comments above are correct... as part of our spam prevention measures, new users will often have their first few posts hidden until a moderator checks them.

That...

No it isn't, because they are very different technologies.

You can create Android/Apple apps (including apk etc) using modern versions of Visual Studio, as there are options such as Xamarin (which...

Assuming that you have a field in the InvoiceInfo table that indicates the year somehow, you can alter your Select statement to only return the values for that year, eg:

"SELECT TOP 1 Inv_ID FROM...

Instead of having a simple condition for each field like this:

Year ='" & ComboBox7.Text & "' AND ...

...you can extend them to also allow a blank value, eg:

(Year ='" & ComboBox7.Text & "'...

I haven't used that control much, but I'd recommend simply trying a colour with the Alpha component set to less than 255, eg:

Dim partlyTransparentRed as Color = Color.FromArgb(100, 255, 0, 0)

Done :)

It is just to initialize things.

The reason for using it rather than your own function is that it is called automatically (you don't need to know anything about the class, you can just trust that...

Doing it the way you are adds an extra trip to and from the database, which slows it down. In most cases that wont matter, but in larger systems (lots of simultaneous users), or a when there is slow...

As it is a CodeBank thread, and therefore a long-term resource, the title is something that matters (especially when adding an extra language), so I have altered it for you. :)

What is the actual error you are getting now?

That is not the case, ADODB was not an issue at all.

The previous issue was that the provider Microsoft.OLEDB.12.0 was not registered (and it wasn't, because it doesn't even exist).


As you...

The Workbooks collection only contains the files that are already open in that instance of Excel, and you haven't opened any.

What you should do is open the relevant workbook, work with it, and...

Your link is for VBA (rather than VB.Net), so various things are different - including the fact that there is a completely different ListView control (the VBA one has ComctlLib.ListItem as a data...

This part is still wrong:

...and that will cause the error.


Make sure you properly copy one of the examples in the link I provided.

According to a quick web search, 'Microsoft.OLEDB.12.0' is not a provider at all.

Presumably you intended to use the JET provider (but you can't, as that is 32-bit only) or more likely the ACE...

In that case something along the line of jmcilhinney's idea is probably the way to go.

Presumably you currently have two separate databases (one for the VB app, and one for the Xamarin app), so...