800 Posted Topics

Member Avatar for Sevyt

Do you have a method to connect to the access database? If not, you will have to: 1) Connect to the database (Use [this](http://connectionstrings.com/) for your connection string) 2) Create a new command (Use [this](http://www.daniweb.com/software-development/vbnet/threads/407064/database-code-sample) for a simple guide on connecting to the database.) 3) Execute the command. (Use the …

Member Avatar for Reverend Jim
0
183
Member Avatar for Omnibus

You will have to add them to your project. Look in the toolbox when in design view, you will find PrintDocument under the printing tree. or Add it manually; Imports System.Drawing.Printing .... Dim pd As New PrintDocument

Member Avatar for Begginnerdev
-1
2K
Member Avatar for Iamateur

You have posted the same question repeatedly about 3 times already. Have you not received the answers you needed on the other posts?

Member Avatar for Begginnerdev
0
86
Member Avatar for Iamkenny

For one thing, you can't see if you do have an error. All of your catch's are empty. Try placing: MsgBox(ex.Message) In all of them, it will give you a little bit of an explanation of what happens. Are you allowing the user to select a range of products? If …

Member Avatar for Reverend Jim
-1
166
Member Avatar for imolorhe

[Here](http://stackoverflow.com/questions/2479403/stop-the-screen-saver-and-hibernation-temporarily-in-vb-net) is a post on stackOverflow about something related. Maybe it would be a good starting point for you.

Member Avatar for Begginnerdev
0
138
Member Avatar for Gus_19

Reading and writing from/to a text file is a VERY simple procces; You need to define a stream reader/writer Dim sr As New StreamReader("C:/Users/MyUser/Desktop/file.txt") Do While sr.Peek <> -1 Dim curLine as String = sr.ReadLine 'curLine now holds an entire line from the text file, from crlf to crlf' Loop …

Member Avatar for Begginnerdev
0
108
Member Avatar for xiiopao
Member Avatar for xiiopao
0
244
Member Avatar for Gus_19

Are you appending the data that is in memory back out the file? If so you are just adding everything back in again. Example: If you are reading into table > add more to end > post back out = Post all data in table, including data that is already …

Member Avatar for Gus_19
0
201
Member Avatar for vkk

Do you have any generational specific formatting? Example: Any Excel 2003,2005,2007 formatting that is not compatible with your interopt?

Member Avatar for Begginnerdev
0
291
Member Avatar for remya1000

You will have to create a custom print method. In this method you will have to loop through the datagridview and parse everything line by line. You will have to pass each line as a String variable. You can use [this](http://www.knowdotnet.com/articles/printgriddemo.html) as a reference. It is a tedious process. One …

Member Avatar for Begginnerdev
0
580
Member Avatar for jcgldr

Have you checked your projects publish settings? You can set publish settings by: Open the Solution > Click "My Project" > Click the Publish Tab

Member Avatar for Begginnerdev
0
123
Member Avatar for oskole

Do a string plit, storing the values in a array. Only look for the value at the 1 index. Example: Dim infoString as String = "mister.john#gotodaniweb.com2" Dim ar() as String = infoString.Split("#") 'ar(0) = mister.john' 'ar(1) = gotodaniweb.com2'

Member Avatar for Begginnerdev
0
95
Member Avatar for Gus_19

You will want to do the reverse of what poojavb has posted. Dim dr As Object If e.CloseReason = CloseReason.UserClosing Then dr = MsgBox("Do you want to save the changes?", MsgBoxStyle.YesNo Or MsgBoxStyle.Question) If dr = vbNo Then Me.Dispose() e.Cancel = False Else btnSave(sender,e) Me.Dispose() e.Cancel = False End If …

Member Avatar for Begginnerdev
0
129
Member Avatar for priyamtheone

You can do as poojavb has stated, but if you are using this textbox for input in a database, you will have to be sure that the user can't submit the changes when the textbox is empty (contains default mask) or it will blow up.

Member Avatar for Begginnerdev
0
228
Member Avatar for Iamateur

Possible duplicate of [this?](http://www.daniweb.com/software-development/vbnet/threads/423128/is-it-possible-to-show-only-particular-records-in-gridview-with-the-followi)

Member Avatar for Begginnerdev
0
108
Member Avatar for aditya barge

Are you wanting a data monitor for network activity and bandwidth? Your question is a bit vague, and is not very legible. Can you please give us a little bit more information...and possibly better typing? If you can't convey your point in english you can always type into a translator …

Member Avatar for Begginnerdev
0
114
Member Avatar for aminevb

Example: Dim Conn as New OledbConnection(ConStr) con.Open() Dim Save as New OledbCommand("INSERT INTO Client(Nom,Prenom,Adresse,Téléphone,date) VALUES(@p1,@p2,@p3,@p4,@p5)",Conn) 'Add parameters' Save.ExecuteNonQuery()

Member Avatar for Begginnerdev
0
92
Member Avatar for dimmslider

> Dim x As String = dsResult.Tables(0).Rows(0)(0).ToString() Dim x As String = dsResult.Tables(0).Rows(0).Item(0).ToString

Member Avatar for adam_k
0
172
Member Avatar for kiyu2keith

This does something very close to what you want, try to use this as a reference. Dim j As Integer = CInt(TextBox1.Text) Dim numOfPasses As Integer = j Dim numbers() As String = {"0", "1", "2", "3", "4", "5", "6", "7", "8", "9"} For i = 0 To j Dim …

Member Avatar for kiyu2keith
0
567
Member Avatar for UltimateJacob

If I understand what you are wanting, you will want do something like this: Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click TextBox4.Text = subjectWords(Get_Random(0, subjectWords.Count - 1)) & " " & predicateWords(Get_Random(0, predicateWords.Count - 1)) & " " & _ complementWords(Get_Random(0, complementWords.Count - 1)) & "." End …

Member Avatar for Begginnerdev
0
170
Member Avatar for abc_123abc
Member Avatar for Begginnerdev
0
3K
Member Avatar for beforetheyknew

You have SQL Server 2012 Express (Free from Microsoft's Website) You have Oracle(Some free versions, haven't worked with.)

Member Avatar for wen_cai
0
232
Member Avatar for sdevanab

I think what you are meaning to do is. Dim sConnection As String = "Provider=SQLOLEDB;Data Source="XXXX.XXXXX.COM:5000;Initial Catalog=IBMDADB2;Integrated Security=SSPI" Also, you might want to remove the user name and password from your string....This is a public forum, and is open to the unregistered public. At bare minimum, you could have a …

Member Avatar for Begginnerdev
0
1K
Member Avatar for SanRubik

We are not here to answer homework, If you have code or any attempt....please post. We can't just do your homework for you, or you would never learn anything.

Member Avatar for DeanMSands3
-1
137
Member Avatar for bigzos

You will need to make use of the Microsoft Office Interopt libraries if you are wanting to manipulate a workbook that is not open.

Member Avatar for bigzos
0
623
Member Avatar for Rabex

Change the name of resources in one of the .resx file. You will then have to change any references to the old name in the corrosponding source code. Example. My.Resources.Resources to My.Resources.ResFix

Member Avatar for Begginnerdev
0
179
Member Avatar for Iamateur

You will have to post your code, but at a 3,000 ft. glance; you just need to have only one execute statement.

Member Avatar for Reverend Jim
0
205
Member Avatar for gozo12

It is possible to have security permissons denying writing to the root of a drive. Also, are you getting the data from notepad or something of the sort?

Member Avatar for Gé48
0
145
Member Avatar for Iamateur

Create a connection to the database, using [this](http://www.connectionstrings.com) as a reference. Connect to the database and create/execute a query, storing the values in a table: Dim ConStr As String = "Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;" Dim con As OleDBConnection(ConStr) Dim cmd As OleDBCommand Dim da As New OledbDataAdapter Dim ds As New DataSet Dim …

Member Avatar for adam_k
0
103
Member Avatar for poolet
Member Avatar for hehehaha
Member Avatar for Begginnerdev
0
54
Member Avatar for AliAwwad

Access is a single user application, therefore; it is not possible. You might want to look into SQL or MySQL as an alternitave if you are wanting multiple users.

Member Avatar for Begginnerdev
0
117
Member Avatar for bigzos

What you will need to do is: 1) Loop through the workbook, comparing and storing all values that reference that person. 2) Loop through those values, adding them to the message (body?)** **It may be easier to write the values to a text file and attach the text file to …

Member Avatar for bigzos
0
102
Member Avatar for KushMishra

Do you mean something like this? Try Dim myDir As String = My.Computer.FileSystem.SpecialDirectories.Desktop & "/tmpOldLoc/" Dim toDir As String = My.Computer.FileSystem.SpecialDirectories.Desktop & "/tmpNewLoc/" If Directory.Exists(myDir) = True Then Dim di As New IO.DirectoryInfo(myDir) Dim diar1 As IO.FileInfo() = di.GetFiles() Dim dra As IO.FileInfo For Each dra In diar1 File.Copy(dra.FullName, toDir …

Member Avatar for KushMishra
1
155
Member Avatar for mistersalty

You will need to create the sub for the click and then add the handler on runtime. Example: AddHandler RadioButton1.Click, AddressOf RBC Private Sub RBC(sender As Object, e As EventArgs) 'Place code here End Sub

Member Avatar for mistersalty
0
877
Member Avatar for george8

One alternative is to place an open file dialog in the project, then allow the user to navigate to the data base. You will: 1) Place the dialog 2) Do some coding to prevent empty paths 3) Store the value from the dialog on the form. 4) Create a backup …

Member Avatar for Sahil89
0
291
Member Avatar for Iamateur

I have this feeling that Iamature is begging for homework. As Mitja stated, he has posted the same question, re worded, at least twice. He also PM'ed me, asking for me to code his project for him. I don't mind **helping**, but **doing** the work for someone is a different …

Member Avatar for Begginnerdev
0
131
Member Avatar for Animal Mother

[Here](http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/86a1eb3c-d731-4b28-b4ff-0a9d78609c3a) is a good reference I used when I did a small project with USB manipulation.

Member Avatar for Begginnerdev
0
199
Member Avatar for bettybarnes

Here is a tiny little recursive sub procedure I have written to do what you are needing it to do. Public Sub PlusOne(int As Integer) If int <= 1000 Then ListBox1.Items.Add("HelloWorld") int += 1 PlusOne(int) End If End Sub Just need to pass 1 in as int when you first …

Member Avatar for Reverend Jim
0
86
Member Avatar for Gus_19

Do you have any code in the form's resize event or any code anywhere that changes their location? Also, is the screen resolution any different when debugging/release?

Member Avatar for Mitja Bonca
0
232
Member Avatar for mistersalty

For loops are actualy pretty easy to use. Example: For Each object In Collection Next For Each Control in Me.Controls 'Loops through every control on the form.' Next For i = 0 to Me.Controls.Count Next 'Would be the same as coding' for(i=0;i=Me.Controls.Count;i++) { } Hope this helps.

Member Avatar for mistersalty
0
238
Member Avatar for mikeybware

You will have to right a for/each loop for each sub level. Each level is considered it's own collection. Example: For Each i As Control In Me.Controls For Each j As Control In i.Controls For Each k As Control In j.Controls If TypeOf k Is TextBox Then End If Next …

Member Avatar for Unhnd_Exception
-1
1K
Member Avatar for ZeroZen

You have actually posted this in the wrong forumn. There ASP.NET form can be found [Here](http://www.daniweb.com/web-development/aspnet/18)

Member Avatar for hericles
0
209
Member Avatar for Iamateur

You could write a sql statement to instert each one, then place it in a loop. Example: Dim conStr As String = "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;" Dim con As New SqlConnection(conStr) Dim cmd As SqlCommand Try For i = 0 To ComboBox1.Items.Count con.Open() Dim sqls As String = "INSERT INTO …

Member Avatar for Iamateur
0
104
Member Avatar for Iamateur

You could create a boolean check. Example: Dim canExecute As Boolean = False 'From the ComboBox's indexChanged event, do the following:' If ComboBox1.SelectedValue = "A" Then canExecute = True End If 'From the Button's click event, do the following:' If canExecute = True Then 'My Code Here' End If Is …

Member Avatar for Begginnerdev
0
116
Member Avatar for jamshi213

For one thing, > myDa.Fill(mydataset, "Old_info") and > search_data_DataGridView.DataSource = mydataset.Tables("Old_inf0").DefaultView Are refrencing two different tables. You have a zero placed at the end of > search_data_DataGridView.DataSource = mydataset.Tables("Old_inf0").DefaultView

Member Avatar for Begginnerdev
0
127
Member Avatar for Iamateur

Something like this: Dim conStr As String = "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;" Dim con As New SqlConnection(conStr) Dim cmd As SqlCommand Try Dim myValue As String = "This is a test." con.Open() Dim sqls As String = "INSERT INTO table (column) VALUES ('" & myValue & "')" cmd = New …

Member Avatar for Begginnerdev
0
136
Member Avatar for toomutch

Is it a possibility you need to instal the mySQL adapter? [Here](http://www.mysql.com/downloads/connector/) are the adapters available.

Member Avatar for toomutch
0
446
Member Avatar for Gus_19

There are a number of ways to do what thines is saying. Are you parseing the data in line by line or the entire file? Are you storing the data in a single string or in an array?

Member Avatar for Begginnerdev
0
208
Member Avatar for Iamateur

Example: Dim sqls As String = "INSERT INTO table (column1) VALUE ('" & DateTimePicker1.Value & "')"

Member Avatar for Begginnerdev
0
86

The End.