Search:

Welcome to VBForums :wave:

Go to the home page of our site: https://www.vbforums.com/forum.php

..then pick the forum that is most appropriate for your question, and click on it.

When the...

Welcome to VBForums :wave:

Thread moved from the 'CodeBank VB.Net' forum (which is for you to post working code examples, not questions) to the 'VB.Net' forum

Base your code on TysonLPrice's example, especially including ReleaseComObject and using that - as that is what should ensure that Excel closes.

An array (or an alternative such as a List()) needs to store the items within it, plus a small amount of extra data for itself.

It should be noted however that the extra memory usage is totally...

Welcome to VBForums :wave:

This style isn't valid:

ElseIf Grade >= 50 < 60 Then
You need to write it out more fully, like this:

ElseIf Grade >= 50 And Grade < 60 Then

Tthe only new information that seems relevant is that you don't seem to have a variable/property that refers to the control, so you need to get it somehow, perhaps something like this:

Dim UC1 as...

You should not use an Event for this, a Property is the way to go.

To understand the difference between the two, think about a TextBox:
the .Text property allows you to set/read the text
the...

Welcome to VBForums :wave:

In UserControl1 create a Property to set the text of the label. If you don't know how, see this: ...

Welcome to VBForums :wave:

Initially a List(of ...) is not set to anything (it is not even an empty list), so you need to initialise it appropriately by assigning an empty list to it.

You can...

Assuming that the values that end up in updatestockquery look OK to you, try using a different format for the date values.

Instead of:
"yyyyMMdd HHmmss"
try:
"yyyy-MM-dd HHmmss"
or:...

What are the values in Cells[10] and Cells[8] when the issue occurs?

The code in Timer1_Tick moves it up

The code in PictureBox1_LocationChanged checks if it has moved down past a certain point (which it wont have, because it is moving up).


You probably want...

Welcome to VBForums :wave:

Thread moved from the 'VB.Net' forum to the 'Office Development/VBA' forum... note that while it certainly isn't made clear, the "VB Editor" in Office programs is...

You can simplify it using an array and a loop, eg:

Private Sub StateColor()
Dim controlsToColor() as Textbox = {tbALMiles, tbAKMiles, tbAZMiles,
...

You can just add a Join to the SQL statement, and return the appropriate field, eg:

SELECT STATE, ISNULL(SUM(MILES),0) AS TOTAL_MILES, ISNULL(SUM(GALLONS),0) AS...

If I was the successor I would prefer it had been changed, but would understand if it wasn't.

Doing a few at a time (and potentially giving up after a while) is certainly a valid approach :)

Those two code blocks can be changed to these variations:

frmCustomerService frmCustomerService = new frmCustomerService(txtCustNo.Text, tab, sdc)
{
StartPosition =...

Debugging is examining what happens as the code runs, for example seeing which parts of the code actually run (due to If statements etc), what the values of variables etc are, and so on.

There is...

I'm fairly certain he wont do anything dangerous himself (he doesn't want to look bad), but I am concerned about what he will inspire his fans to do.

The amount of weaponry they turned up with the...

I think that is one of the features you get as a PowerPoster (2000+ posts)

Time for some good news... Twitter has permanently banned Trumps account.

I wonder what he'll do with his time now, does he still have access to the Nukes? :eek:

If you only call it once in total then it doesn't matter.

If you might ever call it more than once while the program is running, then Delaney's suggestion is better (and the other is dodgy).

...

If the length of text on each line can be different, you do basically need to read the whole file (and store the data, at least temporarily), so your method is certainly valid.

A List is a...

The signature is the bottom part of the post (in my case starting with the MVP logo, in Jacobs case starting with "Useful Forum Tips:").

If you can't see them, at the top-right of the page click...

Neither of them are wrong.

.Net Core can be installed on those different platforms.

it is not installed on Vodahost.


If your host doesn't have it installed (and wont allow you to install...

Our 'Office Development/VBA' forum is more appropriate for this question, so I've moved the thread there.

The good news is that for VB6 you can edit the watch so that you automatically break when the value changes, it makes the hunting much easier.

You will repeatedly get values from the same record, unless you use .Read to move to the next record.

It certainly doesn't look very modern... hopefully that is because they are focussing all their efforts on the software they make, but it isn't ideal.

Welcome to VBForums :wave:

I'm afraid this is nothing to do with VBForums, it seems that you are referring to this site: http://nuke.vbcorner.net/default.aspx
(which has a link to VBForums, but...

The drivers market seems to have settled now, and there are some potentially interesting things there, especially with the new people and the returning Alonso.


In terms of teams, things are...

Actually the IsNull function used there is basically "If (field) Is Null Then 0 Else (field)"

So it is just a way to avoid returning Null - any rows that are Null will be treated as 0 instead. In...

I've moved this thread to the .NET Architecture & Design forum

Welcome to VBForums :wave:

Your seem to have missed an SQL statement, or got confused with your variables.

This is the important section of code:
You assign an SQL statement to sqlStr
You...

Rather than generating the number yourself, set the field to be an Identity field (or called AutoNumber in Access based databases). The details of how you do that vary based on the database system...

George had a brilliant race - shame about the team (radio fail led to the wrong tyres), and the bad luck (the puncture).

He is certainly a star of the future, and will get a good chance soon...

Welcome to VBForums :wave:

Due to our spam protection features, posts from some new members don't become visible until they are manually approved by moderators - and the system has chosen you to...

I expect George Russell to be a bit slower than Bottas, but it is a good chance for him to show off his skills - and if he does perform better than Bottas, it could boost his career a lot (maybe even...

In that case you just need to use the same kind of code for each of the tables you want to add data to (so for 3 tables, you would have 3 blocks of code like that, one for each table).


As...

It's hard to keep the driver away from others, for example if there is a crash (even a small one) then the marshals are likely to need close contact with the driver.

There are also several...