- Strength to Increase Rep
- +12
- Strength to Decrease Rep
- -3
- Upvotes Received
- 149
- Posts with Upvotes
- 134
- Upvoting Members
- 81
- Downvotes Received
- 6
- Posts with Downvotes
- 6
- Downvoting Members
- 3
- PC Specs
- Intel i7-3770, 8GB RAM, GeForce GTX 650, Windows 7 64-bit
|
|
Intro: I am Almario and I would like to discuss windows installation especially and more specifically out of the box installations. Why it should be partitioned to at least two drives. Body: A drive is volatile to a user and easily damagable. A drive when given super user access to … |
|
i have a mssql datagridviewer. i only need when user load the form..they must get empty datagrid...data only show when they search any item or add item....i worked on search and add but i am confused on load event ....please help with code |
|
Try Dim Adapter As New OleDbDataAdapter Dim Command As New OleDbCommand Dim xFrom As String = dtpFrom.Value.ToString.Substring(0, dtpFrom.Value.ToString.IndexOf(" ")) Dim xTo As String = dtpTo.Value.ToString.Substring(0, dtpTo.Value.ToString.IndexOf(" ")) sqlQuery = MainQuery & " Select TOP 100 LOANS.LoanID," sqlQuery = sqlQuery & " Borrowers.NAME," sqlQuery = sqlQuery & " Barangay.BRGYNAME," sqlQuery = … |
|
Hi Guys, im facing problem at cmd.ExecuteNonQuery() kindly correct me wer is the mistake? n how to correct? Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim sqlinsert As String ' We use the INSERT statement which tells our program to add the information ' from … |
|
i want to insert invoice values into databade invoice amount limit and split into multiple row if amount is grater than limit and insert it indicia or group |
|
I am having a table with nvarchar feild in which values are entered like 1 4 8 25 I want a sql query to find the missing sequence of number in the above series... Thanks in advance... |
|
my code is this: Me.Validate() Me.CFTINVENTORYBindingSource.EndEdit() Me.TableAdapterManager.UpdateAll(CFTDataSet) At first I can insert data into the cells and save it... but when i try to edit the same cell with data already saved in it I get this error... sqlcelexception was unhandled There was an error parsing the query. [ Token … |
|
i want to update row after union conection code conect Dim cmd As OleDbCommand = New OleDbCommand("SELECT tb1_type ,tb1_price FROM tb1 UNION SELECT tb2_supp,tb2_debt FROM tb2 UNION SELECT tb3_name,tb3_price FROM tb3", con) con.Open() DataAdapter1 = New OleDbDataAdapter(cmd) Dim builder As OleDbCommandBuilder = New OleDbCommandBuilder(DataAdapter1) DataSet1 = New DataSet() DataAdapter1.Fill(DataSet1, "tb1,tb2,tb3") … |
|
Hi... does someone know how to CONVERT NUMBERS INTO WORDS IN VISUAL BASIC 2008 until millions by using recursion??? if yes... can you please share to me the code??? thanks a lot!!! |
|
So heres my issue: My works VB program uses Code 3 of 9 to put a barcode on a members card; This issue only pertains to one computer, all other networked computers print member cards just fine with the barcode on them. BUT, when I go to print a member … |
|
I'm implement if else in stored procedure with and oprator . If both Conditions are true the if statement should return 1 else -1. here username and email should not be duplicate please review query below. alter proc spUserdetailss @name Nvarchar(50), @passwords Nvarchar(100), @emailadd Nvarchar(50), @Gender nvarchar(50) as begin declare … |
|
I am developing a inventory software in VB6 using MS Access 2010 as Database, We have a main Store where we receive Products from different Vendors and then distribute the products to our sub-stores located at different locations. I want to create a Periodic activity report of (Inventory) Products at … |
|
How do I get average of the duration for multiple weeks. Currently I get something like Student Avg completion time Week Year STUDENT 1 0 1 2013 STUDENT 1 5 1 2013 What I want is Student Avg completion time Week Year STUDENT 1 2.5 1 2013 <code> select a.student,avg(a.duration) … |
|
I have a simple sql table with four columns The data types are Athlete nvarchar(30) Mydate date Mytime varchar(8) Session nvarchar(40) Sample Data **Athlete Mydate Mytime Session** Jerry 14/07/2014 00:00:32 200M Jerry 14/07/2014 00:00:31 200M Jerry 16/07/2014 00:00:59 400M Jerry 16/07/2014 00:00:57 400M Jerry 16/07/2014 00:00:58 400M Now what i … |
|
I am receiving a Code in sms like "yyyy/mm-digit" (digit increments with every message). so i want to ensure that the code sent by user is exactly in that format otherwise another action. So how ? Here is my code to check but it always execute else block, why ? … |
|
Hi, I have an vb.net application linked to Oledb database. here is my code in Button_Click event to prevent duplicate entry with same ID, ID is not the primary key in database. Although it shows "Record Already" Exists", but I am not able to save data with new ID, to … |
|
Hi there. I am making an application in VB.Net. In which i am scanning some system folders and on the execution time it gives me the error; E.g, access to the path "C:\any system file" is denied. Is there any code you people have that is edited in to the … |
|
Hello! I have a remote database that will be accessed through a client program. The thing is, I want the client to auto detect the IP Address of the machine where the database is located, so that when I initialize the value of my connection string it would be like … |
|
i like openoffice much better than ms office, what do you think? After having to use ms word 2007 and other products under the ms office package and vista OS, i started to like non-microsoft products. Thanks to these crap(i dont remember it can be crab), i even started to … |
|
[b]TEAM A[/b]: includes members whose BC username start with A C E G I K M O Q S U V W [b]TEAM B[/b]: includes members whose BC username start with B D F H J L N P R T X Y Z [b]SCORE Board[/b] Team A: 4 Team … |
|
I want to retrive data from table to combobox I used this coding though I didn't get an error the outpiut(data) is not displaing in the combobox Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click MessageBox.Show("Please Insert the Sample note no", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information) Try myConnection … |
|
Hi all! I have a user interface where I want to filter a datagridview.. I 've achieved to create filters but I 've failed to filter tha data by date.. I have a sql db and the column of date is of datetime type. When I try to filter the … |
|
[CODE]Public Class Form5 Dim connection As OleDb.OleDbConnection Dim mystr As String Dim cmd As OleDb.OleDbCommand Dim adp As OleDb.OleDbDataAdapter Dim ds As New DataSet Private Sub Form5_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) connection.Close() End Sub Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load mystr … |
|
Hi Guys, the project im currently creating is a basic form with calculations, which all works great, my task now is to save the form data (labels, textbox data etc) to a word document, now i have achieved it to do this, but i had to specify the name of … |
|
I have 3 tables as mentioned below: Users Code Name NW London 1 Bill ---- ---- Contacts Code Country 1 USA Location Country City USA NW I need to update Users.NW = 1 in the Users Table. There are other cities like NW, London, Paris etc. In respective cities i … |
|
I am able to find and replace in word, however all I want to know is if the word was found, I have tried the following code: This works oDoc.Content.Find.Execute(FindText:=x, ReplaceWith:=y, Replace:=Word.WdReplace.wdReplaceAll) This never give the true statement oDoc.Content.Find.Text = x If oDoc.Content.Find.Found = True Then But why not? |
|
Ho Gents Is there any one who could help me on getting this sorted out? I want to save a unique indetification record considering this criteria: FULLDATE/PROCESS#. I.E: 03[COLOR="Red"]05[/COLOR]2012/1 03[COLOR="red"]05[/COLOR]2012/2 03[COLOR="red"]05[/COLOR]2012/3 ... 03[COLOR="Green"]06[/COLOR]2012/1 03[COLOR="green"]06[/COLOR]2012/1 For each date, I want it to start from one allover again. I have currently have … |
|
I have installed two windows XPs in my PC, how to delete one ? |
|
Hi folks Im a newbie. I have a combobox cboTeachersName that is bound to deptTeachers table. At runtime, it contains teachers of given subject (Course). I then select a teacher and save in a field in another table called Summaries. PROBLEM IS When I load the form and load the … |