with access 07 + vb.net...i am calling an access Query ....the Query which uses a user defined PUBLIC function in access module...the problem is i am getting an error as "Undefined function 'DecideSON' in expression." in fact DecideSON is a function in the access database module?
View 2 RepliesIn my project i have to display the party name in a combobox and the user has to select a particular partyname. For that when the user enters the first character in a combobox all the party name starting with that alphabet has to display in the right hand side. So i created a list box when the combobox index changed. But when i execute the following code it is showing the error "Row handle is invalid". I have 2 records in my database starting with the alphabet "i".
[Code]...
I am inserting data from my vb.net application to msaccess db.I am confused in way of getting the last inserted record added to a table. IN MS-SQL we get @@IDENTITY for that but it didn't worked for me in MSAccess.
so what should be do for getting the last inserted record added to a table?
I am using following code for Insert records from LIstview to table in MsAccess:
[Code]...
I used following code searching records from a table in MsAccess and displaying in a Listview and it is working fine with the search criteria based on Discription.
CODE:
I also tried the above code to search records on the base of CustId and it worked fine too.My table DailyTransaction in MsAccess is as under:DTDate, DTTime, CustId, Description, Quantity, Price, Amount, AccountNumber, Name
Now I want to Search records on the base of Date I tried the following but it did not work.
Dim cmdText As String = "SELECT * FROM DailyTransaction WHERE DTDate=' " & TextBox1.Text & " ' "
Also i want to make following sort of query to retrieve data between two dates and to display the sum of amount group by DTDate. I could sketch following query and deifinitely it is so wrong with Syntex.Select * From DailyTransaction where DTDate Between textbox1.text AND textbox2.text Group By DTDate AND SUM(Amount)
I want to compress an ms access database using vb.net. If the database is open this fails. How can I close the database, compress it, then reopen the database using vb.net code to accomplish this. I've already successfully written the code for compression, but I can't find anything on closing the database while leaving ms access open.
View 2 RepliesI have a VB Solution with a dozen forms trying to implement invoice system.My main form (Say Form1) only has a design to create , Edit or Delete Customers.My form 2 will be opened if Create button is clicked. In my form 2, I have textboxes where user can enter Customer details and click on SAVE. My doubt is here....On clicking this SAVE button in Form 2, I want a INSERT command to happen on the MSAccess's Database table called Customer (which I have already created... this table does not have any records as of now). In my form 1, I added a MSAccess Database with a Connection String. In my Form1's code I have code like this[code]...I got this piece of code from this link [1]: vb.net - sharing mdb access connection among multiple forms/Now, I do not know what more code does this require to INSERT records from my text box into the Customer table's fields.
View 1 RepliesI am trying to export the contents of Array to Microsoft Access table. But as of now i could do it via creating a text file in the local HDD. I would like to find a solution bypassing this step.
View 2 RepliesHow can i use the ProductID to compare and call out the corresponding Product Name and Selling Price column from the MsAccess Database and display in the second DGV?
View 6 RepliesI am developing a program and stuck up with an issue. I am able to enter single value in MSAccess database however, when I create a programe to enter multiple entries I am getting an error. developing a code to enter multiple entries in MSAccess 2002 db with the help of VB based form?
I Following code I am using for single entry:
Private Sub Button1_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Enter
Dim query As String
[code]....
i am developing a point of sales system. currently i have my product code scanned and displayed in a listview. lets say that i have 5 product codes displayed in my first listview. By clicking on a button, how can i use these codes to call upon the details (prices, product name, etc.) of the corresponding codes and display in another listview?
i am using Visual Basic 2008 and MsAccess as my database. who have the idea on solving my question. (As my last thread has not been answered at all..
I was wandering is it possible to use a query within another query below is the code I am trying to use.
Public Function GetInventByComp(ByVal CompID As String) Using DC As New DataClassDataContext
'need to get company id's based off names? thats bad should be name from Id need to rethink this
Dim invent = (From C In DC.Inventors_Companies _
Where C.CompID = CompID _
Select C.InventorID).ToString
[Code]...
I was trying to us multiple values in a string like "1, 3, 5" but I can't seem to get that working either so I am trying to use just a single value now. Can anyone help me? "Yes I am new to this"
I am using Visual Studio 2008 to try and create a calculator program that can convert binary to decimal. I have some code but I'm having problems figuring out what to write as an "argument" when I was to call the function.
Here is the code I have so far.
Public Class Form1
Private Sub btnCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click
[Code]....
I have created a .NET assembly, clicked 'Register for COM Interop' on the properties page, strongly named it and compiled it. Then I GAC'd the .NET DLL manually. Calling the .NET assembly from my VB6 code with 'CreateObject("MyNETProject.class1")' gives me an automation error. I've gone through about 3 iterations of this for most of the day and cannot sort out what I'm doing wrong. I have a feeling it's got to do with my .NET assembly settings and GACing but it all seems right.
View 3 RepliesDo not care to stay at these forums when criticized by other members.
View 6 Repliesim in need of calling a function in another process, now from the last couple hours of digging ive found out that i need to use createremotethread for that, problem is - it has a bunch of parameters i dont know how to fill, especially the address part. I tried using getprocaccess and getmodulehandle for that but i dont think they return what i need.
View 9 RepliesI have 2 forms FORM 1 and 2 i got this code in form 1
vb.net
Private Sub starauto_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles starauto.Click
form2.Button1.Value = True
form2.Button1_Click()
End Sub
but both examples give me an error
error 1.- 'Value' is not a member of 'System.Windows.Forms.Button'.C:Documents and SettingsleijaiMy DocumentsVisual Studio 2008ProjectsIp On or OffIp On or Offform1.vb239Ip On or Off
Error 2.- Error3Argument not specified for parameter 'sender' of 'Public Sub Button1_Click(sender As Object, e As System.EventArgs)'.C:Documents and SettingsleijaiMy DocumentsVisual Studio 2008ProjectsIp On or OffIp On or Offform1.vb249Ip On or Off
error 3.- Error2Argument not specified for parameter 'e' of 'Public Sub Button1_Click(sender As Object, e As System.EventArgs)'.C:Documents and SettingsleijaiMy DocumentsVisual Studio 2008ProjectsIp On or OffIp On or Offform1.vb249Ip On or Off
i am trying to use a login form that is used to login after you select one of 7 forms. this login form calls a function that validates then it calls another function, if it's true, that will load the appropriate form.
here's what i have.
vb.net
'Here are the appropriate variables
Public FormName As Form
[Code].....
Is is possible to do something like:TextBox1.Text = Replace(TextBox1.Text, ".*", "", 1, , CompareMethod.Text)
View 9 RepliesIs there a way to call or pass a variable to another sub? I'm trying to reterive a variable (or even a field name) in somethign like this:
Private Sub PrintPageHandler(ByVal sender As Object, ByVal args As Printing.PrintPageEventArgs)
args.Graphics.DrawString(RS("field1"), New Font("arial", 8), Brushes.Black, 5, 5)
[Code].....
how should I go about starting to create a Win32 application interface to help user register an account from a website.The website have a form with a lot of controls which is not mandatory field, so my task is to create a form with a few controls and submit to the web server.What is the method that I should read about, is it HTTP Post/Get related thingy or is there any sample on how can I communicate the form action?
View 2 RepliesIf certain conditions are met within a given subroutine, I would like to execute two other subroutines. Note that the other subroutines I want to call/execute "handle" a lot of events
vb
Private Sub S2_Enter (ByVal sender As Object, ByVal e As System.EventArgs) Handles S2.Enter
If upltschanged = True Then
[Code]....
Here is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
how I can call an existing Access 2007 report from VB.Net 2008. I need not only to call the report but would like to be able to apply some VB.Net code to the report.
View 2 RepliesFor some reason, a certain Form in my project will change it's size all on it's own right after I call it. It's usually with small forms in the one I'm having a problem with is 95x25 pixels. The only thing on it is a Label with some text in the middle and this code
Public Class MessageForm
Private Time As Integer = 25
Private Sub fadeTimer_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles fadeTimer.Tick
Time -= 1
[Code] .....
As you can see the Form is meant to be a small pop-up that disappears on its own, like a balloon tip. Anyways I just added it to my project 5 minutes ago and as soon as I tested it out by displaying it with Form.Show(), it randomly changed to 123 by something else during runtime. I checked all the Form properties for any kind of resize properties and only found AutoScaleMode which was set on font, but set on None made no difference. Like I said I just added this form and have no code affecting it whatsoever in my entire project except for Form.Show and the code on that form. For the moment I'm just resizing the form on it's own Load event, and that seems to work, but I'd like to know what is causing this random form resize.
When calling API's or other external functions it is only possible to get thrown errors using "GetLastError". I made the following function for this:
[Code]...
I'm creating a certain number of objects based on some templates that I have available to the user. Then, I have a module created for each template where I will be doing some math operations, etc.
I know how many objects will be created, but of course visual studio doesn't at design time.
Dim newhydzone As PictureBox
newhydzone = New PictureBox
newhydzone.Name = "Zone" & Form1.hydzonecount
[Code].....
I have a Sub Routine in a module to iterate controls on a form. I get an error about an instance of the object not created.I have declared the object and set it to the form (ModelsBox = Me). I have done this between two forms previously. Is there something fundamental that I am missing. Is this where the "Friend Shared" comes into play?
[Code]...
I'm working on a base class right now, here's a basic rundown of it:[code]The problem is, in the Public Class bar example, some classes may implement MyInterface, and others don't. What I'd like to be able to do is have the sub New() in the structure in the base class "Foo" be able to tell if the class calling it (either the Base class, or the child class) implements MyInterface or not.
View 8 RepliesI am trying to use an unmanaged dll in my VBE2008 Project. My application works fine on my computers (3 Vista sp1 and 2 XP sp3 / all with .net framwork 3.5), but after the sp2 update for 2 of Vista machines, it throws often an AccessViolationException (on those machines with Vista sp2). The error message is:"Attempt to read or write protected memory. This is often an indication that other memory is corrupt."I have checked and found that the exception was thrown by the dll call-sub.
<DllImport("RefProp.dll", EntryPoint:="SETUPdll", SetLastError:=True, CharSet:=CharSet.Ansi, _
ExactSpelling:=True, CallingConvention:=CallingConvention.StdCall)> _
[code].....