here is my Query. What is wrong with this?
rs.Open "SELECT * FROM Installment_w_DueDate where LastDocDate < (SELECT LastDocDate FROM Installment_w_DueDate where AccountNo = '" & txtAccountNo.text & "')", MDIMain.strConnect, adOpenStatic, adLockReadOnly
I have been developing a VB6 app for 4 years. Just this week I cannot make an EXE file. When I try to make an EXE (from the command line or the IDE), I get the message System error &H80004005 (-2147467259) Unspecified error
[Code]...
We are getting this error on one PC every time we turn on any add-ins in Excel. Googling the issue has not produced any useful results nor has searching the Microsoft KB. The problem occurs when any add-in is turned on in Excel even those that come with Excel (like the Euro conversion tool). The problem began when the user was having issues with Outlook not working with his profile. I first tried a 'repair' of the Office install (which created this problem, but did not solve the other.) I solved the Outlook issue by creating a new profile for the user. I have since uninstalled Office entirely and reinstalled.
OS: XP pro sp3.
Office: 2003 Pro.
An object at rest cannot be stopped
I'm developing a chart that is frecuently updated.This chart works with a macro to display the period of time the user wish. The worksheet is protected because it can't be edit by the user. The user can just enter the dates between the period that he wants to be display by the chart. When I use the file on Excel 2003 its runs without any problem. But, when I use it on Excel 2006 or 2010 it gives me the following error:
Run-time error '-2147467259 (80004005)':Method 'MinimumScale' of object 'Axix' failed
I am new to this and have almost 0 programming knowledge. I want to automate transferring data from excel spreadsheet to access. i surfed around on the net to see if there were examples of codes that i can copy.this is what i currently have.
[Code]...
I am having major problems with creating my tables and populating them.The problem for the creating seems to lie when I try to create my table named WeeklyUnitStaffRota. I get the run time error 2147467259(80004005) No unique index found for the referenced field of the primary table. This has only started happening as I have been tinkering with my tables to get them to populate properly.I seem to have a problem when I have two columns with the same info but relating to a different college ie two MSC being run at 2 different colleges.[code]...
View 1 RepliesI have an error that is during the query to a database ExecuteReader 'phase' of my program, i am assigning an .OleDbDataReader to a variable RetVal and then, i am giving this RetVal = Query.ExecuteReader, and then in the while the query is being read loop(While RetVal.Read) i am getting an error in runtime that is "Invalid attempt to call Read when reader is closed." I know this means i have to open the reader, but i don't know how to do this, as i have been using this process for a few weeks and haven't had this error pop up. (and i have managed to use the while loop)If you're not living on the edge, you're taking up too much room
View 7 RepliesI am trying to build a ActiveX DLL using VB6. The IDE finishes the compilation phase and starts writing the DLL when it gets the error. I've searched MSDN and google without finding any answers.
View 1 RepliesI have a Visual Basic 2005 program which runs fine if I execute the built Executable. However if I start the application in VS2005 debugger it gives a weird error
[Code]...
I know this topic is all over the place, but I am not doing an INSERT, UPDATE, DELETE. My statement is a plain and simple SELECT statement and so far has worked with 116 different items in my database until I got to one.
I have a search engine and am going through every single product in our database to add information to it. This is all done through the website, but when I search for ProductID 331 and click on it, it goes to the error page that says Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
It doesn't make any sense to me that the website would error with only this one product. This is the statement I am using. Does anyone know why 1 product would be causing this error?
WebService:
Public Class ProductSearch
Inherits System.Web.Services.WebService
<WebMethod()> _
[Code]....
I get the following errors: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. If the subquery only return one result,then it works fine,but if the subquery return more than one results, then the error occurred,how can I resolve this error?
View 3 RepliesSoemone recently downloaded my software and they got this error: microsoft common languages runtime version 4.0.30319.0 how do i fix this
View 1 RepliesHere is my SQL query..
SELECT EqID, MakeID, Model, Description,
(SELECT MAX(EvDateEnd) AS MaxOfDateEnd
FROM tblEvent WHERE (EqID = tblEquip.EqID) AND (Event = 'REG')) AS RegExpire,
[code]....
For example, I want to get the Max EvDateEnd from the Events table for each record in tblEquip, but not all records in tblEquip have the "REG" event, while others have multiple REG events.Some events (like EAE) I leave the tblEvent.EvDateEnd field blank to show the event is open and ongoing, such as issuing a vehicle to an employee(entity). when the vehicle is returned I enter the date in EvDateEnd essentially closing the event.
I've got a subquery that returns the most recent value from a child table. In some cases the subquery returns nothing. The query below fails at runtime because the inferred type of MemberPrice is decimal and is not nullable. [code]...
View 4 RepliesI need to find all records where the status is in the local list of Integer's.
In SQL I would do
Where Status in (select i from my list)
But I can't figure how to make it happen in Linq.
ListData = New IssueTrackerEntities2()
Dim queryString As String = "SELECT VALUE CallList FROM IssueTrackerEntities2.CallList AS CallList"
Dim Status As New List(Of Integer)
[Code]....
I wrote some code to update the count of a field in a table, but it is very slow. So I'm trying to do it in a subquery to speed things up, but I'm not very good with subqueries. I'm getting the error "Subquery returned more than 1 value".
[Code]...
[Code]...
I want to use a stored procedure to populate a label on my asp.net page and a dropdownlist @tourname will be populated into a single label while @tourdepartures will be multiple dates, that i want in a dropdownlist however when i run my sp i get this error
[Code]...
i have created a com class library with vb.net. i have registered the dll with regasm. Then i imported and used it to a vb6 project. I have noticed that if i unregister the library and register it again then i get the following error:
Runtime error '-2147024894 (80070002)': Automation error.
In order to make the library usable again, i have to rebuilt the library with different ClassId, InterfaceId, EventsId at the classes and then register the new dll.
PS: it also does the same thing if i overwrite the registered file with the same file or if i rename its folder and then rename it back to its previous name. Rebuid and re-registered is needed.
I'm trying to query old Access database tables and compare them with SQL Server tables.They often don't have primary keys, or they have extra fields that had some purpose in the nineties, etc., or the new tables have new fields, etc.I need to find records - based on a set of fields specified at runtime - that are in one table but not another.So, I do this kind of query all the time in SQL, when I'm comparing data in different tables:
dim fields_i_care_about as string = "field1, field2, field3"
'This kind of thing gets set by a caller, can be any number of fields, depends on the
'table
dim s as string= ""
[code]....
It tells me it can't convert a Boolean - Is there any way to do this without Linq expressions? They seem far more complex than what I'm trying to do here, and they take a lot of code, and also I can't seem to find examples of Expressions where we're comparing two fields in a subquery.Is there a simpler way? I know I could do the usual EXISTS query using JOIN or IN - in this case I don't need the query to be super fast or anything. And I don't need to use a DataTable or DataSet - I can put the data in some other kind of object.
I work for Southwire Company. We are owners and developers of a program called SAG10. It is set in VB6. When trying to run this program on Windows Vista, I get a runtime error 440. Not all installs on Vista behave this way. I have had multiple successes in installing and running SAG10 on Windows Vista. I have changed settings to mimic the successful runs and I still get this error. I have disabled the User Account Contro
View 4 RepliesI am having a problem with this code. I have used this code before on other apps and it works, but I don't have a clue as to what is going on here.
This is the whole event. I get a runtime error msg thats says "Syntax error(Missing Operator) in query expression"
I think this is Legacy SQL coding but I don't know how to make it better.
Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click
Dim Question As Integer
[Code].....
I have a class classed class1.vb, it has a public property named prop1 with a get and a set clause. I add one to the value passed in the set clause and in the get clause return the value variable as determined in the set clause. However, I get an error on the variable in the get clause...
Public Property prop1()
Get
Return value
[Code].....
I have a function that returns a double. If in the function I decide the value is invalid, is there any way to return "error" instead of a double? Of course I could pass a boolean by reference and set it false and then check for that back in the calling function, but that seems awkward.
View 5 RepliesI'm trying to save a decimal number (like 7.28 ect) on Database.Database field type is float.Note that in Italy decimal separator is < , >
Dim Credito_Aggiornato As Single = Convert.ToSingle(FormatNumber(Credito_Residuo - ((Numero_SMS_INVIATI_per_calcolo_credito
* Costo_Singolo_SMS) / 100), 2))
[code].....
I got a stored procedure to compare dates and if the date is not valid it returns an error in sql server.I need to know how i carry that across to vb.
View 2 RepliesIs there a way to display an error message from SQL server to VB application. I have created a stored procedure and I would like the errors to be displayed in my application.
View 1 RepliesI just converted my project over to 2010 from 2008. Everything seemed to be working fine (no errors came up). I ran the program and found no run time errors either. I then proceeded to update my program by adding user controls. These controls where already used by the program (through references), but were originally external. Due to issues with them not updating updating (no matter what I tried) I decided to build them directly into the project. This did not cause any issues at first, the program continued to run without errors or execptions. I replaced some of the old controls that referenced the external project with the new internal ones. The old ones were completely deleted first, and then the new ones (named same as the old ones to reduce programming errors...and yes I am sure the names are spelled EXACTLY the same) were added.
Now, the progam is throwing an exception during the variable declaration of a form I had been using with no errors: "Unable to cast object of type 'OldControl' to type 'NewControl'". I have run into cast exceptions before an am fairly good at solving whatever the problem is (usually a simple issue). Here is the kicker (actually 2 kickers)... First, NO LINES OF CODE HAVE BEEN CHANGED from when the program was working fine. I have basically changed out 'old_textbox' for 'new_textbox' in the graphical interface (and have given the new ones the old one's names) and made sure no errors came up (which didn't happen). Second, this exception is being raised on a line that has NOTHING to do with the old or new control: Public AllowCopiesMode as Boolean = False
I know that sharing code is usually helpful in situations like these, but I wouldn't know where to begin concidering where the execption is being thrown. If anyone knows if there is an issue with vb.net 2010 or a 'quirk' that rquires me the do something slightly different, please let me know. Out side of that I am completely lost
I have an old Visual Basic 6 project that was brought to my attention for updating. The project is a label program that reads an Access 2000 (so it's labeled) database. The labels the program prints has headers and such hardcoded in the code and all of the fields that are selected are pulled in from the database. All that needs to be done is to have the hardcoded labels changed and the program recompiled, sounds easy enough right? After attempting to debug the program the error in the title of this post is displayed.
View 2 RepliesI am trying to run a .VBS script from Windows explorer and am a novice VBScripting programmer I am getting above error when running the following code.Error detail: Line 54, char 5; Object doesn't support this property or method: 'MimeMapArray'For code:
' This script adds the necessary Windows Presentation Foundation MIME types
' to an IIS Server.
' To use this script, just double-click or execute it from a command line.
[code].....
I recently created a windows service that starts other applications that I use on windows startup. Basically this service is for virtual computers i use to test software and web sites. The service starts and stops just fine but when a custom made application actually is run within the service I get a .Net error in my event logs. Ive read up online and found that this is caused by an unhandled exception (As a result of this error in version 2.0 of the framework the application is killed.) so i added the correct handler and it didn't work. Then i found that another issue could be .net being corrupt so i uninstalled and reinstalled still no fix. I know theres an issue with one of my applications but i cant find were. I don't get any errors when i debug anyone know what i should do? [code]
View 2 Replies