Search:

Nevermind - I understand that the code could be used maliciously, I suppose. I don't mean to do anything malicious - and I figured out a workaround using a timer and getasynckeystate. :)

Hi! Thanks so much for the reply. Well, the mousedown works pretty much everywhere, but the mouseup never works anywhere.

Hey folks -

I'm using .Paul.'s Windows API to detect mouseclicks out of the form.

Using the following code works beautifully to detect RightMouseDown:

Private Sub...

Haha, thanks for the laugh! I'll do some more research!

Yes please! I would appreciate that greatly! I don't know how you would want to do it: do it here on this thread, over PMs, over email, I'm open to anything - I just want to learn :).

Well, shoot. I suppose I'll go back and Google some more. If you want to though...you can totally show me how it would work in this situation. :x

Shaggy Hiker, thanks! I'll take a deeper look!

kpmc, You have great memory! I'm still pretty new to coding - I'm trying to teach myself as I go as a hobby of mine during the downtime at work....

I have a form that loads a database (Microsoft Access) of about 100 rows, and 30 columns and populates it into a DataGridView. The form then displays the information of each row in the DGV in...

Thank you very much to you both!

@kpmc Well, from my very limited experience with DataGridView, it's just a little clunky to edit and multiline entries (which I have several of) are a mess.

@kpmc Thank you! I'll just clarify a little bit!

Basically, I have a database of miscellaneous household items with about 100 rows and 20 columns. Those household items are numerically categorized...

@techgnome Sure! Sorry - I probably should have done that from the start.

Declarations

Dim Connection As New OleDb.OleDbConnection
Dim dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
Dim...

@techgnome Honestly, I was just following a tutorial online. I did as you suggested and just skipped the DataSet.
@GBeats Thanks! I just skipped the DataSet.

So I am using the following code now....

Thank you both very much - quick question - how do I reference the datatable that is within my dataset? In the original post, I have declared "Dim DataSet As New DataSet" which is the DataSet that I...

@techgnome, thank you! I'm actually not displaying the data in a DataGridView. Instead, I'm going to be pulling information from there into textboxes.

So for example, I have 5 columns filled out...

Hello,

I have a DataSet with about 1,000 rows. The first column of this DataSet (other than the key column) has the numbers 1 through 4 depending on the row. I'm trying to display the row...

Thank you! I'll use this method!

It works beautifully, but in the event that the original sheet had a cell with multiline text, when the sheet is opened in the DataGridView and then copied over,...

kpmc, ooh, you know what? I actually had thought of that but didn't know how viable it would be. I'm glad that this is something that you've done before! Just as a quick question, is there like, a...

Haha, alright thanks. I don't know how extensible that method is going to be then, since I expect this sheet to get very, very large.

I'll keep working on figuring out a way to get your original...

kpmc, thanks for the reply! My only concern is that according to the internets, the interop method (I think this is what you are using?) is very slow when the excel sheet to be created is very large...

kpmc, thanks for the start! I'll keep googling to see if I can figure out how to do the actual updating. It honestly looks like this method is used almost exclusively for updating single cells...

Thanks - I really appreciate it. Trying to learn, but it's honestly so confusing.

kpmc, thanks very much! I tried updating my code using what you posted (and I tried to use "Using" as per your recommendations), but the code gets caught as an exception:

Try
...

Shaggy, thank you! I think you set me on the right path here as far as updating the sheet. I've come up with this so far:

Try
Dim sql As String = Nothing
Dim con...

Hi all,

So what I am trying to accomplish is this:

I open an excel sheet (100 columns and 100 rows as an example) and populate it into a DataGridView control.
Make any changes to the...

Hi LuckyLuke, I actually need to have that existing (original) workbook to remain open. But otherwise, you are 100% correct. I opened a workbook, read from it, and then created a new workbook...

Hey guys, I have a bit of a puzzler.

First, my declarations:
I have an application that will read/write/save an existing spreadsheet (through a background worker):

Dim APP As New...

Hey guys. After a lot of Googling, I'm certain that I can't solve this on my own. Whenever I close my application, the Excel process that was opened will not close. Here is my code. Does anyone see...

I got it! Thank you guys!

TysonLPrice, thank you!

Sitten Spynne, I did what you outlined and it worked. Thanks!

6th line down from Button1: Entries = worksheet.Range("B1048576").End(Excel.XlDirection.xlUp).Row 'Count how many entries there are (the first row always counts as an entry)

Hey everyone. I have an application that loads up a spreadsheet from a network drive. Since the spreadsheets are quite lengthy, it takes a bit of time, and I've been struggling to implement the...

I just laughed so hard, thank you!

Okay, so I actually got this working last night. But I have a question. Is there a way I can change the way the control looks? I think this is it: Private...

Hey guys, I'm trying to implement Paul's eyedropper tool into my own program:...

Well, that's just embarrassing. Thank you!

I have a rich text box and when I click on it, I'd like there to be a tooltip for 1000ms that says something like "Hello" where the mouse is. I keep getting a NullReferenceException was unhandled...

I'm stupid. Sorry. I got it! Thank you so much!

Thanks! I don't know what kind of magic you used but it works! Just one little extra request (I know, I'm so sorry!), but is there a way to get the "delete both" requirements slapped into that code...

I'm sorry. I know I'm not being very clear with what I'm trying to get to happen. Thanks so much for being so patient!

So let me try to explain!

I have a form. There's an RTB and 2 checkboxes...

Hey thanks! It works pretty good but I have a few questions if that' s okay.

For chkBox2, when you click it, nothing happens unless you already have something in already in the richtextbox.
...

Yes, so I want any similar existing text overwritten and readded, in addition to the addition of Text Here 2, etc.

So, chkBox1 that checks to see if "Text Here 1" exists, and if so, delete it....