Search:

I have a project and am trying to place about 50 PDF files directly into it and have the code display the files.

Currently, I have setup a folder structure under the project name, thus

...

None of this is working...
In the first, I get an error that says method or data member not found. I have tried Publish as well as Publish Objects. PUBLISH is the named cell selection

Dim i...

This produces run time error 1004
With ActiveWorkbook.PublishObjects.Add(xlSourceRange, website_path _
, "CCR LOG", "PUBLISH", xlHtmlStatic, "CCR_log_24100", "")
.Publish...

No column or semi-colon (as shown) seems to do the trick.

I can export this no problem...

With ActiveWorkbook.PublishObjects.Add(xlSourceRange, website_path _
, "CCR LOG", "$A:$AA", xlHtmlStatic, "CCR_log_24100", "")
...

I have a program that runs great in debug mode. When I install the compiled version I get a few read only errors not at installation, but at run time. Specifically, I am getting the two errors...

First: The file exists and is not open
The Microsoft Jet engine cannot open the file 'c:\path\filename.mdb'. It is already opened exclusively by another user, or you need permission to view its...

Thank you for your reply. Things seem to be going better. My only other issue is that at run time on the compiled installed version, I am getting some errors on dependent files being read-only. ...

Short term, is there a way to register this control until I can reprogram that part? Is that regasm or reg32? Thank you!

Hi:

I am getting this error: system.runtime.interopservices.comexception (0x80040154) class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))

I am doing a deployment in...

Thanks again. I'll dig into it some more.

Thanks for your response.

My filter problem is the filter problem, generating the error Missing operand after 'Nbr' operator. I believe dt4 is happening correctly.

dt is a function that dt4 is...

dt4 is an entirely different set of data, using the SO Nbr from dt2. I am looking to onlu look at the three or four items required in dt4 to get the right data information.

Hello:

I am trying to query a vb.net datatable. In this case, the data table is dt4 and is created like this...


' Look at LUII Specific Data Dump
' Get the latest dated...

Thank you...

That's great, because this is not what I'm looking for. In the data above, if dt3.Rows.Add.Item(x) is used, I am getting the staggered rows/columns:
ROW0 ROW1 ROW2 ROW3 ROW4 ...

Thanks for the information.

I have one more small question. In this code:

If dr1.Item("Eng").ToString = "Y" Then

Try
...

Hi:

I had some code working to my satisfaction. As a final step, I added a reference to 'Microsoft.Office.Interop.Exce', and now my Data Tables produce errors. Apparently, I am no longer allowed...

Hi:

I am struggling with type mismatch issues.

Specifically with this line of code: If Not IsNothing(dr2.Item("Actual Eng# Hours")) Or Len(dr2.Item("Actual Eng# Hours")) > 0 Then

In this...

Hi:

I am writing a program that reads data from one database and copies it to another, using ADO.NET. My only question is, how can I read the data type (not just string, but string length, not...

I can only guess that it has to be done at event time.

Thanks!

Kevin's solution worked great. Why the other one did not goes back to my original question, for which I have no idea!

There were six rows in my dataset, and all of them showed up white. There must be something else??

Everything is white.


Public Sub LoadDataGridViewM()
Debug.WriteLine("Loading the data grid")
InitializeTable(dt)
Dim dt2 As New DataTable("Table 2")
...

I am trying to change the background color of specific rows in my DataGridView. Nothing is happening here.


dgvFBOM.DataSource = dt ' This works, data is populated!
...

I'm getting the error from the immediate window. No data ever makes it into the datagridview as a result.

There are 7 columns and the rows very. I'm certain it was not the rows, since it works...

Getting closer...

This produces A first chance exception of type 'System.IndexOutOfRangeException' occurred in System.Data.dll

Code...


Private Sub LoadDataGridViewM()
Dim ds...

dt is declared at the top of the class.


Dim dt As New DataTable("Table 1")



Perhaps it is not recognizing it in the GetVantageData function???

abom(6) produces an error of 'Explicit initialization is not permitted for arrays declared with explicit bounds.'

Could it be that I need to redim?

Yes, better efficiency is a good thing - once...

The issue may be that it's not running the function right, for whatever reason, as the MessageBox.Sow is not being shown:



MessageBox.Show(dt.Columns.Count)

Listing


Private...

No errors, it's just not looping...

If I rem out some stuff and do the first action, it works great!


For x As Integer = 0 To adoc.GetUpperBound(0)
dr =...

Do you see any reason why it is such a struggle to return the array inside this loop? Let's say x=30


For x As Integer = 0 To adoc.GetUpperBound(0)
dr =...

In doing this...


Private Function GetVantageData(ByVal index As Integer) As String

I get string conversion errors...

I want to return an array from a function.

dt is a DataTable that is global


Dim dr As DataRow

For x As Integer = 0 To adoc.GetUpperBound(0)
dr =...

Not that I am asking you to do this for me or anything, but I've read several tutorials about datasets to come up with this already. I'm quite frustrated. What you are saying makes sense.

I need...

Hello again...

So, I made the variables global... Nothing changes...


Public Class Form2
Dim cn As String = ("Data Source=SQL2;Initial Catalog=SharePointProgress;User...

Is there a mathod to append to an existing DataTable??

dt.columns.count produces the same issue. Basically, the columns are not being counted, as far as I can tell.

I am trying to poppulate this thing manually, since there are multiple data sources...

I would like to count the columns in by dataset. Why is it laways zero? Overall, I want to populate a DataGridView and related DataSet from multiple data sources. I am pulling data from a Vault,...