Search:

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...

The issue is because bytesPerMillisecond is an Integer.

The value of 176400 / 1000 should be 176.4, but because you are storing it in an Integer only 176 is stored, and that difference creates the...

We're happy to help, and we're glad you've joined our community :)

Well yes, my caveat of "basically" wasn't really good enough... I was just trying to avoid confusing the thread starter. :)

'Is' and 'IsNot' aren't meant for checking values (they are basically for checking if two object-variables have the same pointer).

Use = and <> as you did in the other parts of the code.


...

Those lines of code (especially the savebutton line) are much longer and more complex than ideal... and that means they are very hard to read, which increases the chances of issues like you are...

Not quite, the For loop is set up to start at item 1 (instead of item 0).

That means for the first item you have no Newline, but you add a NewLine before each of the other items.

Try it without specifying the folders, ie:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|MasterBase2.0.accdb

In modern versions of Visual Studio you can spread a single line of code across multiple lines, in order to help readability.

In this case, those first four lines are the exact equivalent of this...