With ActiveChart .HasTitle = True .ChartTitle.Characters.Text = "DIRECTIONS" .Axes(xlCategory, xlPrimary).HasTitle = True .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "DIR" .Axes(xlValue, xlPrimary).HasTitle = True .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "DISTANCE" End With
View 2 RepliesWhenever I open any VBP file in Visual Basic 6.0, I get Method '~' of object '~' failed error. After that project compiles without any error i.e I can create either EXE or DLL without any error. Originally, all files are Visual Basic 5.0 vbp files and we are converting Visual Basic 5.0 to Visual Basic 6.0. We will be converting to .Net after converting to VB6. Application uses microsoft access as data storage.I am running Windows XP on my machine. I have got .Net 3.5, Jet 3.5 Sp3, Microsoft Office 2003 installed on my machine.
View 8 RepliesRun-time error '5200' Method 'endMessage' of object 'ISoapConnector' failed
Dim Serializer As SoapSerializer
Dim Connector As SoapConnector
Dim Reader As SoapReader
Set Connector = New HttpConnector
[code]....
I created a typed dataset a day or so ago, then I added a whole bunch of tableadapter/tables with some relationships etc... suddenly out of nowhere it decides my dataset "is not defined". everywhere in my code where i use this dataset now has an error. I tried not to pull out my hair and do a Clean then Rebuild solution... out of nowhere it just refuses to generate code. Object reference not set to an instance of an Object. It would be nice if it was my object so i could find it but it's not.
Curiously I also lost the little database icon on the dataset in the solution explorer.I can still open it in the designer and preview my queries etc... it just wont make the code. it's driving me insane. anyone got a solution?
VBA error 1004 - select method of range class failed
View 2 RepliesI am getting following error whenever I want to use IIf function inside entity framework query.
LINQ to Entities does not recognize the method 'System.Object IIf(Boolean, System.Object, System.Object)' method, and this method cannot be translated into a store expression.
Does anybody know why I get the error 'that method is not available on that object' when I try to interface with Word 10? Our software works fine with Word 7 and previous
View 1 RepliesI have developed a website that allows users to upload office documents then uses the office object model to convert the document to an HTML file that it then displays in an iFrame. I have, of course, included references to Office.interop.word, and the site works fine on my development machine. When I uploaded it to my production server the site functions fine until I try to upload a document. I initially got a similar error that said "COM object not registered". I realized that Word wasn't installed on my production server. So I installed word and now when the server tries to access the word object model I receive the following error:
Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
I searched the registry for the corresponding CLSID and found a corresponding folder. I added full control to the IUSR_ account and due to the persistence of the error I eventually added full control to "everyone" and ensured these permissions inherited down to the rest of the folder. I then added full control to IUSR_ and again eventually added full control to "everyone" to my microsoft office folder.
I don't know what other permissions to grant and where in order to make this "Access is denied" error go away. I must be granting them in the wrong place, because as far as I know I can't be any more permissive than "Everyone" "Full Control".
I am working on a large spreadsheet with Macros. It worked fine when I only had one spreadsheet that the code was pulling from. When I added an array, I get the an error on the Activesheet.unprotect stating 'unprotect method of worksheet failed'.
View 2 RepliesI'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service. The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 1 RepliesPart ot my program is to simple copy a range of cells ~21 000 rows from one WB (oSH) and copy it to another WB (oSHOut).I've red a lot of posts,tried a lot of variants, but nothing helps..Strange here is that if I copy less than 8500 rows, the paste to the destination range is OK.But if I copy the whole range ~21000 rows, vb.net trigers an error - "Copy method of Range class failed".So I tried to do this in several parts - 1 row to 8000, 8001 to 16000 ect.The first copy-paste works OK, on the secon - there's an error.[code]
View 5 RepliesFirst time poster, so if there is any formatting, or guidelines I failed to adhere to, please let me know so that I can fix it.
So I am basically asking the user for the file directory of the excel file, then I setup some variables (originally set at public as project variables, since these were being used and changed in other places). I have also added the lines to set these variables to nothing (just in case, I do not think that it should matter). I then set these variables to the excel file, workbook, and sheets that I want to access. [code]...
I am getting some wierd errors when using the ReportViewer control in Visual Studio 2008. When I try to access the LocalReport property, it displays with this error: "Cannot find the method on the object instance.". Also, I am getting invalid cast errors saying I cannot cast from Microsoft.Reporting.Winforms.ReportViewer to Microsoft.Reporting.Winforms.ReportViewer. I am getting this using either CType or DirectCast. This is really frustrating as I can find almost no documentation on this error.
View 1 RepliesThis is the code that I'm currently working with, and I'm getting this problem. I'm novice at Excel and I can't figure out what's wrong.[code]...
View 2 RepliesPart of my program is to simple copy a range of cells ~21 000 rows from one WB (oSH) and copy it to another WB (oSHOut). I've red a lot of posts,tried a lot of variants, but nothing works. Strange here is that if I copy less than 8500 rows, the paste to the destination range is OK. But if I copy the whole range ~21000 rows, vb.net trigers an error - "Copy method of Range class failed". So I tried to do this in several parts - 1 row to 8000, 8001 to 16000 etc. The first copy-paste works OK, on the secon - there's an error
Imports Microsoft.Office.Interop
Imports System.Data.Odbc
oRNG = Nothing
oRNGOut = Nothing
oSH = Nothing
oSHOut = Nothing
[Code] .....
I have created a web application in ASP.NET using VB.NET as code behind file. I am using a COM object of ProvideX.Script class to connect to Sage MAS90 ERP. Everything was working fine in visual studio 2010. Now when I moved to the deployment phase, the problem gets started. I deployed my application in Windows Server 2008 in IIS7. When I run the application I get the following exception.[code]...
View 2 RepliesI get this error when I try to publish: Error 2 An error occurred while signing: Failed to sign binReleaseapp.publish\setup.exe. SignTool Error: ISignedCode::Sign returned error: 0x80880253
The signer's certificate is not valid for signing.
SignTool Error: An error occurred while attempting to sign: binReleaseapp.publish\setup.exe MITS 2008
I downloaded the .net 3.5 sp1 and it performed a repair but it still will not publish.
WTF, here's my code...
Public Class Form1
Dim BIT01 As Integer = BIT_01.Text
Dim Value As Integer = TB_OutPut.Text
[code].....
I have a custom class with constructor, the class is setup such that it would legitly fail to init in some conditions. How do I return nothing?
View 2 RepliesWhy does my the declaration of my string in the code result in the following error? Is there a workaround?
Code:
<script runat="server">
Protected Sub form1_Load(sender As Object, e As System.EventArgs)
Dim x As String = "</script>"
[code]....
Error: Statement cannot appear within a method body. End of method assumed.
Note: The following page did not fix my issue and instead resulted in the string </script> being output in my page. ( VB.NET hates </script> tag in string literal )
I'm trying to code a class of RandomNumber. One of the class methods needs to populate a "List (Of RandomNumber)" ... which was passed as a parameter to the method ... with 10 random numbers between 1 and 50. DEAD SIMPLE :)
View 6 RepliesWhat do I need to convert?
Dim CEESearchByAppNo = From CEEsearch In dbCEE.tblScanneds _
Where CEEsearch.AppNo = iAppNo
[code].....
I created a SQL DB named MainDB.mdf and a small VB 2010 application with some forms and datasets.Everything was working OK until i got a new computer and re-installed Visual Studio 2010 and SQL server 2010 on it. I copied my DB from the old to the new computer and also copied by VB 2010 project to it. I used Windows Authentication to connect to the DB in the old computer and also in the new one, i am using different Windows user account names though.
I was able to connect to the DB in the new computer in the Server Explorer section, i created a new connection string to the DB and i can seed there is data in the tables. When i run my VB 2010 application created in the old computer get error:
"Cannot open database "MainDB" requested by the login. The login failed. Login failed for user 'D630Admin'."
I need to get rid of that error and be able to add/mod/del data from my DB using my VB application as i used to.
following error message:
Method not found: Void Excel.Range.set_Value(System.Object,System.Object)
(VB.NET) I get this error as soon as I open the application. It works fine on my machine, but when we installed it on a test machine, we get this error.
46 PM -- An error occurred creating the form. See Exception.InnerException for details. The error is: Retrieving the COM class factory for component with CLSID {857C49E7-ADC6-11D1-98C1-0060948CAA0A} failed due to the following error: 80040154.
at SLSClaimantWorkbook.My.MyProject.MyForms.Create__Instance__[T](T Instance) in 17d14f5c-
[code]....
I am writing a program to try and centralise alot of data i have on my network so i can use them as templates and guides. My intension was to have an easy to browse program with links in the program which open the particular file (eg. Word document, excel spreadsheet, pdf file etc).I have very limited programming knowledge and in my research i came across this code in VB which allows the program to open the determined file:
Public Class _010101ProgramTemplate
Dim procstart As New ProcessStartInfo("explorer")
Private Sub btnProgTemp01_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnProgTemp01.Click
Dim winDirProgTemp01 As String = System.IO.Path.GetDirectoryName("g:Project Management SystemPMS TemplatesSetupProgramDD-IFC PROGRAM.xls")
[code]....
I am getting this error. An error occurred creating the form. See Exception.InnerException for details. The error is: Retrieving the COM class factory for component with CLSID {662A2901-FF10-11D1-BE10-00A0C9204FDC} failed due to the following error: 80040154. i tried many thing such as register dll , modfing CPU to 32 and i still see it.
View 2 RepliesI have completed a VB.NET app .its working very fine from vs2005. Now I am trying to publishing app. My problem is that i got an error when i tried to run exe.I was using five VB6 dll in my app.1)
[Code]...
So i've coded a simple vb project in MS VB 2008. I then copied the contents of the 'bin/release' folder, and tried running the program on another machine. I'm getting 'the application failed to initialize' error. I'm assuming this is because i'm missing certain files, dll's or something. Or should I have copied the obj/release folder?
View 2 Repliesim using the query builder to create my sql queries I have made many SELECT statements but when i try and use UPDATE i get this error
"Failed to get Schema fro this Query"
I am able to create a "NonQuery" but i dont know how to implement The query will execute when i build in the query builder but when i try and save it the error appears?