I've spent 2 days to figure this out, but no luck. I have an IIF expression what shows the correct value when the condition goes true (IPmt calculated), but the else always returns #error, although it should be just 0. =IIf(Fields!PaymentNumber.Value<>0,
[Code]...
I'm trying to update data to a Access data base using the following [code]...
View 3 RepliesThis is not a homework of mine and i had never tried ms access database with vb so i just gave it a shot. so this is my first time and i am just trying not asking anyone to complete my homework. I have been searching for this a lot on internet but couldn't find a solution to this so i decided to ask this question here.
i have this sql code. what i want to do is that create a basic login form where users puts it's username in the UsernameTextbox and Password in the PasswordTextbox. If the the information match then a message box appears saying that the user is valid and if the information does not exist, a mesage box appears saying the users is not valid. now everytime i execute(run) the code, i come up with this error: Syntax error (missing operator) in query expression ''UserName' = 'Admin' 'PassWord' = 'testing123''.
The field names(UserName, PassWord) are also correct they are same as in the database. the information put in the username and password textbox are correct and they match the information on the database. But i dont know why this error comes up.
My code module is the following:
Imports System.Data.OleDb
Public Class LoginForm1
' Cancel button
Private Sub Cancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Cancel.Click
Me.Close()
End Sub
[CODE]...
i use a database in access and I use a query for adaptor and dataset.
The query is next:
Select * from table1, table2 where table1.idsomething=table2.id and table2.name= 'Name1' AND datebirth>=#07.25.1988# AND datebirth<=#07.31.1988# order by datebirth asc
The error is: Syntax error in date in query expression
In the database the format date is dd-mm-yy.Why I have this problem? What is wrong at the query?
I get #Error in reportviewer when I use the following expression:
=IIf(Fields!PaymentNumber.Value>0,
IPmt(Fields!Annual_Interest_Rate.Value/1200,
Fields!Payment.Value,
Fields!No_of_Monthly_Payments.Value,
Fields!Total_Amount_Financed.Value),0)
When I remove the IPmt() function and use some static value instead, it works. Is there a way to find out the exact error ?
access is denied error thought updateresource returns true value and i am running vb.net as admin
View 9 RepliesWhere can I find resources on authoring Reports. Say, I have a VB project and I want to add reports to it, do I have to add a ReportViewer for each report or can I use one ReportViewer for all?
What is the difference between a Report created using the Report Server Project of the Business Intelligence Projects and one created using the Visual Basic/Reporting Project tab? Which one is more suited for creating reports?Only performance counts!
I have the following function:
Public Function CheckHasRoom(people_id As String, semester As String, year As String)
' Don't let folks already registered for a room register for another.
Dim RoomSelected As String
[Code]....
But it is bugging out at hasroom.Any() saying, "Input string was not in a correct format." Any thoughts on why? This is returning a collection of rows just like where I use this same code elsewhere without issue?
I've been trying to get the UNC path for a mapped drive in a web application written in VB.net 2005. I was able to get this code working[code]...
I tested this code out in a test application - just a simple web page. But when I plug the code into my actual project, it doesn't work. In my testing of other examples, I figured out that WNetGetConnection returns a system error of 487 - ERROR_INVALID_ADDRESS. But I don't understand why it would work in my test application but not my actual project application.
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 RepliesIn our code base there is a function which should return either an object or nothing. The exact code is this : Return NothingThe calling method looks something like thismyObj = theClass.function()if myObj <> nothing then // fails
View 1 RepliesWhen I try to save the picture and the picture is already existed it show an error
Me.Location = New System.Drawing.Point(50, 50) Create a new Bitmap object with the screen bounds Dim both As Bitmap = New Bitmap(166, 261, Imaging.PixelFormat.Format32bppArgb) Create a Graphics object that will process the screen shot front and back Dim bothgraph As Graphics = Graphics.FromImage(both) Copy the screen contents bothgraph.CopyFromScreen(0, 0, -506, -279, Screen.PrimaryScreen.Bounds.Size,opyPixelOperation.SourceCopy)' Save the resulting graphics
[Code]...
Ok, here is the problem,in vbscript, i was reading parts of streams
i.e.
teststrid = left (strLine,8)
teststrnm =rtrim( mid (strLine,15,30))
teststrx = mid (strLine,57,8)
teststr = left (strLine,3)
strFormcode = left (strLine, 10)
strSymmetrycode = left (strLine,14)
strSigncode = left (strLine, 10)
Even in cases that strLine length was less than the index used to split the string, the program kept running.Now i am trying to do the same in VB.net, but since the strLine is not always bigger than the index used to break the string, it ives an error.I do not want to use try catch, because i will have very dirty and uselless code.
I was thinking something like resume next, but i guess it doesnt exist anymore.
When I have a property within a class such as:
''' <summary>
''' Customer IP address.
''' </summary>
[code].....
I have a page in which one chooses from a selection of dynamically generated buttons. The ASPX code is as follows:
<div>
<asp:Repeater ID="rptrHalls" runat="server" OnItemCommand="Choose_Hall">
<ItemTemplate>
<asp:Button ID="btnChooseHall" runat="server"
[code]....
When I first tried running the code I received an error message of "Invalid postback/callback argument". I set the ASPX page to have a enableEventValidation="false" property and tried running it again. It generates the page fine but when I click on a dynamically generated button it acts as if it is loading something and then just brings me back to select_hall.aspx (the page all this code is one), when (as you can see above) it should take me to select_room.aspx.
<p>I cannot for the life of me figure out why the below code works when I fire it from my localhost but does not work when I publish it. I am unable to remote Debug </p><p>but it seems that I am getting Error 2250... I've tried searching for it but its too damned generic a code?</p><p> </p><p>All I want is the UNC, why is everything in .NEt so damned difficult?
View 6 RepliesI'm trying to update an Access database by using an OLE connection, retrieving the information from textboxes where the user enters the new information.All the fields in my Access table are required fields, so I have validated that some info is entered in each one of the textboxes and that is the correct data type.But when I run the update query I get an error message saying something like values haven't been entered for some required parameters (my Visual Studio is the Spanish version, so I can't give the exact error message in English).The bit of code where the error occurs is inside the procedure called by my "Ok" button:
Dim campo1, campo2, campo3, campo4, campo5 As String
Dim campo6, campo7, campo8 As Double
Dim campo9, campo10 As Integer
[code]....
(I didn't post the whole code inside the procedure, but of course I'm creating the connection and everything)
The table has 10 fields, and the data is read from the textboxes and stored in variables (campo1, campo2, campo3, etc.), which I'm then using in the "set" query command.
"id" is the first field from the selected row in the datagrid, which I'm sending as a parameter to the procedure called by the "OK" button.The error message shows at runtime, so I'm guessing it's something in the query. Am I writing it correctly?
I need to open a *.py file in the shell (DOS) box, but it returns an error that no file was found at the specified path. But this path is completely correct. Unless Visual Basic are referencing to paths in another matter than C#? 'Cause I am developing in C# and referenced to VB to do this.
View 3 RepliesError: ClassFactory cannot supply requested class.I installed 2003 Add-in: Office Web Components, you can download and install OWC11.exe from the following link:aunched a VB formadded the Spreadsheet 11.0 control and got the above error.
View 1 RepliesI am trying to use Authorize.net's SIM payment gateway process and am using the base code provided on the developer site. The problem is I am using Master Pages with my site and the hidden field names are getting concatenated with the nested control IDs as an example:
[Code]....
I 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 tried to convert following C# code into VB.NET and got "Expression does not produce a value" error while compiling the code
C# Code
return Fluently.Configure().Mappings(m => m.FluentMappings.AddFromAssemblyOf<MyEntityMapping>())
.Database(SQLiteConfiguration.Standard.InMemory().ShowSql())
.ExposeConfiguration(x => new SchemaExport(x).Execute(false, true, false))
.BuildSessionFactory();
VB.NET Code
Return Fluently.Configure() _
.Mappings(Function(m) m.FluentMappings.AddFromAssemblyOf(Of SubscriptionMap)()) _
.Database(SQLiteConfiguration.Standard.InMemory().ShowSql()) _
.ExposeConfiguration(Function(x) New SchemaExport(x).Execute(False, True, False)) _
.BuildSessionFactory()
The error happens on 2nd last line of VB.NET code, while C# code is compiled without problem.What is wrong with the converting?
Ok so I have alot of plans for programs coming up and I want them all to fade in and out so instead of copy and pasting from project to project etc I learnt about dll's
So when I added in the references etc and I typed in what I declared the Fadein function as which was "FadeIn" I got an error saying it needed to be declared
So I declared it as a string
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim FadeIn As String
FadeIn(Me)
End Sub
Then I get a different error saying Expression is not a method.
im migrating from vb6 to vb.net and have only very basic knowledge of .net. now i upgraded one of my projects, in which i had function cleartexts() which would clear all the text boxes of the forms. now to upgrade it to .net i converted it to sub (as it didnt return anything), so it looked like,
public sub cleartexts()
for i = 1 to 24
text(i).text=""
next
end sub
but .net 2005 gives the error, "expression is not a method", how do i call it then?? or what modifications do i need to make?
I tried to convert following C# code into VB.NET and got "Expression does not produce a value" error while compiling the code
[Code]...
After moving afew things baout on my main form i am getting an error:Expression does not produce a valuein mainly this line of code (various ones are all over my application)
If (checkboxTurnOnDebugging.Checked = True) Then
'Display code for debugging
formDebug.debugTextBox.Text = HTMLResponse
[code].....
Im getting a build error with the following code...
Private Property GridViewSortDirection() As String
Get
Return If(TryCast(ViewState("SortDirection"), String), "ASC")
End Get
[CODE]...
It is happening on the following line...Return If(TryCast(ViewState("SortDirection"), String), "ASC")
Error returns...Error 11 C:inetpubwwwrootTPSupportmainUserControlsgrid.ascx.vb(192): error BC30201: Expression expected.
Its a convert from c#
private string GridViewSortDirection
{
get { return ViewState["SortDirection"] as string ?? "ASC"; }
set { ViewState["SortDirection"] = value; }
}
I am getting a syntax error " Missing operand after 'Price' operator" with the following code, which should be right but obviously isn't. Any thoughts on where the error is?
table.Columns.Add("ADR Price", GetType(Double))
table.Columns.Add("ORD Price", GetType(Double))
table.Columns.Add("Currency Price", GetType(Double))
[code].....
Im trying to use a replace function ...that replaced bad words out of a textbox I found this example on the net but there is a little error
this is my code
Function ReplaceBadWords(InputComments)
Dim badChars, newChars, i
'create our array of bad words
badChars = Array("rubbish", "crap", "shit")
[code]....
the error is 'Array' is a type and cannot be used as an expression'
basically i have 16 checkboxes that indicate the status of digital inputs, either checked or unchecked, but rather than adress each and every one of them with a pile of repetative code, i set up a for-next loop and tried to change the status of the checkboxes with - is for index = 0 to 15, if blah=true then checkbox(index) = checked else checkbox(index) = uncheckedBut i get error- checkbox is a type and cannot be used as an expression.
View 1 Replies