Search:

I had thought about that but the query also has variables. Declaring variables does not make a recordset either. My current workaround is to make two separate SQL statements and put the select...

I have a query which creates a temp table, inserts data into that temp table then selects data from that temp table.




connection.Open "Provider=SQLOLEDB.1;Data Source=server;" & _
...

No. There is no macro running on the excel file.


The excel file stores data.

I have shown my code



Dim xlApp = New Excel.Application

Dim wb = xlApp.Workbooks
Dim xlWorkbook As Excel.Workbook = wb.Open(MacroFilePath & MacroFileName)

Dim xlWorksheet As...

This might be an issue. My code is in a console application not in a form.

Also I took the code you wrote and ran it and I still had the excel process running. Once the console application...

not really. If it's a late binding or an early binding does not help me understand what i'm doing wrong when trying to dispose of my com objects.

I really read that thread and tried to figure out what i'm doing wrong but I can't. I'm following rules 1, 2, and 3 listed above



Here I am opening and closing excel and trying to dispose of my...

I found out what was causing the problem when i switched the variable from a string to an array there were other places where i was just trying to say


if MCO = "active" then
end if

instead...

I'm currently writing the inner text of an XML node to a string variable like this:



public MCO as string
MCO = node.SelectSingleNode(xml_subsPlanNode).InnerText

This is working fine. Now...

This makes so much more sense.

I've tried researching online and have been having a really hard time with understanding how to write data to the CSV file? export the towndata to a CSV file which...

This makes so much more sense.

I've tried researching online and have been having a really hard time with understanding how to write data to the CSV file? export the towndata to a CSV file which...

Also I found some code online that i'm kind of able to use to read a CSV file but there are parts of it that I don't understand. I'm really struggling with understand exactly what is going on when...

This should work. I'm running into issues with how to write data to a data file using the console application.

Can a console application even write data to an existing CSV file? I don't think I...

I currently have a server which runs various scripts and macros. Many of them are in VB script files.



I'm wanting to build some sort of DLL, class, or function or something in visual studio...

Well just as bizarre as it was when it started it went back to normal without me really doing much of anything (other than playing around with commandtimeout) which I ultimately changed back because...

That's what is so bizarre. The query itself is the exact same.

Front end users never used to get the timeout error and now they are. I didn't even know how to handle it because it's never...

I have an application that has been working. It populates a datagridview based off a value selected in a combox. The query which populates the datagridview has been running in anywhere from 4-6...

It looks like this was caused with internet explorer security settings being too high on my computer.

So what is the correct syntax for adding a document complete event handler to an internet explorer object?





Do Until IE.ReadyState = 4

In this code if IE = internetexplorermedium the...

I found that internetexplorer causes the error and internetexplorermedium does not cause the error.

I tried googling to understand the difference and I had trouble finding a good answer.

...

This does nothing to help me understand why i'm getting an error. You did give me an alternative. handle the document complete event. I tried that in the code below and the document complete event...

I have a form and the user is to click a button and have it open internet explorer, navigate to a URL, wait for the readystate to = 4 then stop. I've done this in other applications so this error is...

Any ideas on this?

100% positive

The "network" id shown below can belong to one of many service elements. The image shown below shows the element with the id "network" belonging to the "service30" element, the...

I'm wanting to read the innertext or innerhtml of the element id "network" highlighted in the image below.

The problem is that if I say document.getelementbyid("network") there are many elements...

I tried that and it didn't work. If the mouse is idle on top of the webbrowser then the webbrowser needs to refresh.

Anyone with any ideas?

The error is: Event MouseMove is not valid on this ActiveX control.

I'm wanting to refresh the webbrowser if the mouse has not been moved or click within the webbrowser for 10 seconds.

I try to add event handlers for webbrowser1 onmousemove and onclick but they...

I have a windows form application where users use a datagridview as a worklist with a SQL server feeding the data to the datagridview. Changes they make to the datagridview are written back onto the...

I knew it was something like that. It was right in my face the entire time and I simply couldn't see it! Thanks!

I have a situation where i have a column full name which is [lastname comma space first name] and I need to split it into one column for first name, one column for last name.


This is something...

Anyone?

Question 1: What property is it that controls the distance between the X axis ticks?

Question 2: My chart area has a lot of empty space to the right. What property will stretch out the x axis to...

I have a query that fills a tableadapter. When I run the query in SQL the query runs in about 100-200 ms. When I preview the data on my tableadapter the query runs in about 30 seconds. How can...

142317

I have a chart bound to a tableadapter with a bindingsource

The chart is populated with 20 something points but only a few of them have labels.

What chart/series/chartarea setting do i need to...

This is perfect! Do you know anything about why the code below will return the axis label for a bar graph but not for a pie chart?


Dim htr As HitTestResult = Chart1.HitTest(e.X, e.Y)
If...

I have a bar graph with the totals for each team lead. If a user clicks on the bar then other charts are populated with information about the team lead.

We had a situation where the bar for a...

It had something to do with the fact that I put the tableadapter on the form. Removed it and then added it again. The original time I added productivitytableadapter to the form the name was ...