chanthung

Hello friends, hope you guys are dong well. problem again and really looking up to my expert friends here. I'm new and trying to write Edit code in VB.NET. the problem is [B]Select * From Application Where Sl_No='" + txteditno.Text + "'", con) [/B]is not displaying and record although it …

I have 3 tables, one fr[B] SALES, ITEM and SL_IT[/B]. SL_IT connects this two table with many to one relation with two [B]FK for SALES and ITEM[/B] respectively and with [B]QUANTITY [/B]as the third field. Now i want to INSERT records, i do for SALES, and QUANTITY part in SL_IT …

I am using MsAccess DB and Vb.NET 2008. This is a code to check the Database for duplicate entries but m geting an Error. [B]" Fill: SelectCommand.Connection property has not been initialized."[/B] And this points to [B]LINE NO 14[/B]. What could be the cause..? thanks in adv [CODE] Dim con …

Hi, i am trying to write a code to Insert new records, and while doing so, want to check if the ID already exist. Finding it difficult to code. here's my code. [CODE] Dim ic As Integer ic = Val(Me.TextBox1.Text) ' ic for ItemCode Dim foundRow As DataRow = ds.Tables("ITEM").Rows.Find(ic) …

hi all, Here is my code to insert and update my Access database. Problem is after the data gets updated, after a while, all the records in the database disapears...??? I am quite confused....pl help whth my code..thanks [CODE] Dim icode As Integer frmEdit_Items.ITEMTableAdapter.Insert(Me.TextBox1.Text, Me.TextBox2.Text, Me.TextBox3.Text) frmEdit_Items.ITEMTableAdapter.Fill(frmEdit_Items.KiranSDBDataSet.ITEM) frmEdit_Items.ITEMTableAdapter.Update(frmEdit_Items.KiranSDBDataSet.ITEM) icode = …

Hi all. I am trying to add a record into the database wothout much success. sometimes it works and sometimes it returns error "[B]overflow exception unhandled[/B]" And even the database is not all the time updated. How do you add the Datatimepicker value into the database...? Will really appreciate help …

this code works but it doesnot display multiple records.. like if i search for Andrew, i want my code to display all names similar to Andrew, Alex, Adam..etc can anyone please help me with the code. Mu code is listed below. thanks [CODE] Private Sub Find_Load(ByVal sender As System.Object, ByVal …

Hello, I have a problem again and will be grateful for a solution from anyone of you. i get this error while trying to make a setup file. how do i find out Which line it's refering to... i could make a setup before this without any problem. Thanks. [B]Compile …

hi, i have found this post somewhat close to solving my problem, but there seem to be a problem. Kindly help me with the code....i am posting the code [code] Set db = OpenDatabase(App.Path & "\libraryic.mdb") Set rs = db.OpenRecordset("Book_Details", dbOpenTable) ''Do While Not Form1.Data1.Recordset.EOF ''Data1.Recordset.MoveNext ''While Not Data1.Recordset.EOF If …

hi to all again, I want to know how to disable the Maximize option of a window using a VB code. I believe one way to have a fixed window size is to disable the Maximize option?? Can anyone here please help..... Thanks a lot again in advance. Have a …

Hi, hope everyone here is dong fine. Can anyone please help me with my coding. This is the code to fetch the book name from INPUT box and display it in a TextBox(which is limited). But I want the records to be displayed on a ListView with several others having …

Hi, hope all are doing fine.. need some suggestions. I am using VB and Acccess and am trying to fetch a record from database by: "Select * from accounts where emp_code='"+d+"' AND emp_name='"+n+"'"". The inputs are fetched from an Inputbox. but i get a compilation error... [B]Run-time error '13': Type …

Hi, Badly need help again. I have completed one project and have tried making a setup file using Microsoft Visual Studio Package and Deployment Wizard. It showed no error. I ran the setup file but could not as I saw a message(Error?) and after completing the setup I tried running …

Hello, I am interested in a web site which is on sale. Actually its is an existing page and they want to sell it, for $200 or Rs 8,000/- plus Domain $15 or Rs 500 + 500 = 1000/- , design already done. I was thinking to buy and change …

Hi guys, I have completed one project and have created a setup file also. I have taken help from one of you guys and corrected a setup error, about "[B]DllSelfRegisterEx[/B]" to "DllSelfRegister". But now the problem is after complition of installation, i get the following error message during installation to …

Hello, My problem is, after i have deleted all the records fromt the database, all the buttons like First, Next, Last, Previous and delete are disabled. A message is displayed "There are no more records." Ok, till here no problem. But after i add new records, say one record, i …

hi all, i am trying to installing WinXp using SMARTDRV but i ran inro problem. I started Xp installation from a floppy by first running a:\SMARTDRV from DOS mode then typed WINNT by accessing winXP cd. But i get error message saying insufficient memory(virtual). I cant reproduce the entire error …

I am at the ending part of coding for a Library software but I am unable to move forward as I can’t figure out the way to change the color for DBGrid row. I am using MsAccess as the database. I want the color of a particular grid row to …

M writing a program to display the date ie. 15 days later after a given (present/todays)date. Wel its actually like this. As soon as i write todays date, in the next text box, the date shd be automatically displayed adding 15 days to the present date which is already displayed. …

i have developed a small software. its more or less bug free. i wanted to make a setup n c if it works fine. but after making the setup software, i tried running the software but halfway it stopped and showed this error. visual basic error msftqws.pwd\$(DLLselfregisterEX) cant figure out …