Search results for query: *

  • Users: Runescope
  • Content: Threads
  • Order by date
  1. Runescope

    Question Use Accounting format in Datagridview

    Hi! Just curious if anyone knows if it's possible to format numbers in the DataGridView so they look like the Accounting format in Excel. This is different from the Currency format (which I know how to do). for example: $5000.00 $3000.00 $2500.50 _$100.00 That is currency formatting, the...
  2. Runescope

    Resolved Using Alpha Vantage API

    I was curious if anyone has ever used the Alpha Vantage free stock feed API in VB.Net. I've looked at several pages, but my knowledge of installing third-party ... things into VB is dismal at best. Sorry I can't be more specific about what I want. I know so little, I don't know how to...
  3. Runescope

    Question Putting multiple texts into an image.

    What I have is a couple hundred patterns that I want to paste or insert or what have you onto a picturebox at a particular spot. I can get the pattern to show up where I click with no problem. What I can't do though is get more than one pattern to show up in the picturebox. Every time I click...
  4. Runescope

    Question DataGridView padding still there even though it's set to zero

    Greepings, I've been banging my head on this for a few hours now and I can't seem to figure out a way to get around it. I've got a datagridview setup with lots of empty columns and rows. The user clicks into a cell to fill it with a pattern they've picked. I want the patter to go right to...
  5. Runescope

    Resolved Pick from DataGridView ComboBox with Pre-Filled Collection

    So I have a DataGridView control, it has a few columns, one column is a DataGridViewComboBoxColumn. I have pre-filled it through it's own Items collection with the numbers 0 to 9. I want to pick one of the numbers as a default when the program loads, how do I select it's index? Here's the...
  6. Runescope

    Question How to do a perspective graph

    So I want to do a perspective graph, but when I google it, all I get is information on how to do 3D. Now, what I call a perspective graph might be known as something else so here is an example of what I call a perspective graph. The distance between 1 and 10 is the same as 10 and 100 and...
  7. Runescope

    Question Concurrency Violation. Can't force an edit into the database.

    Greetings, I have an unbound Access Database that I'm trying to fill with almost 20 years of data stored in text files. Each file is one day's prices of items, each file has around 10,000 different items. Sometimes the name of the item changes slightly, and I want to write that change...
  8. Runescope

    Resolved RTF Font properties not changing on second append.

    So what I've done is created a sub where I can format text going into a richtext control. It changes the font colour, size, and style. It works perfectly for the first text that goes into the control, but when I add a second set of text, it only changes the colour. I'm not sure what the...
  9. Runescope

    Question Extending lists past edge of TableLayoutPanel

    So I have a program that has to have a fairly complex layout design with automatic rescaling. I wanted to use a dropdown box to be able to select multiple things. You can't do that with a standard combo-box, so I went ahead and created a custom one using a textbox, command button, and checked...
  10. Runescope

    Question Can't change a button image using me.controls for some reason.

    So I have a series of buttons that I want the image to change when I click on them. Here's the code I have so far: Private Sub btnFilter_Click(sender As System.Object, e As System.EventArgs) Handles btnMainFiltIn.Click, btnHistFiltIn.Click Dim BtnName, BtnNameF, BtnNameE As String...
  11. Runescope

    Resolved make the field a text field

    I added this into my code: dbCMD = New OleDbCommand("ALTER TABLE [RegTable] ALTER COLUMN [RenewDate] Text", Conn) dbCMD.ExecuteNonQuery() dbCMD = New OleDbCommand("ALTER TABLE [RegTable] ADD PRIMARY KEY(RenewDate)", Conn) dbCMD.ExecuteNonQuery() It successfully makes the...
  12. Runescope

    Question Check if a table already has a Primary Key

    So I'm fixing a table from someone else, and they never put primary keys in all of their tables. I've figured out how to put a primary key into the table in my program, but now I want to check if the primary key has been set already so I don't try to set it twice, resulting in an error. I'm...
  13. Runescope

    Resolved Assigning a Primary Key to a database programtically

    So, I'm taking over a project from someone (always fun deciphering their code lol ) and they have a table in their access database that is an autonumber, but not an actual primary key. Now, if it was just on my computer, I'd go in and edit it so that it's a primary key, but it's been...
  14. Runescope

    Resolved Getting an odd Systax Error when updating.

    Okay, I have this code. Private Sub btnRSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPHSave.Click Dim PID As Integer Dim CBPH As New OleDbCommandBuilder(PHDA) Dim Foundrow As DataRow() PID = grdHistorical(12...
  15. Runescope

    Question Update command is not passing change back to database ... sometimes.

    So, this is quite frustrating and I'm not understanding what the problem is. To start it off, this is the bit of code: FFoundRow = FDT.Select("[Code1] = '" & Code1 & "'") FFoundRow(0).Delete() FDA.Update(FDS, "Info") FHCIndex = FHDT.Columns.IndexOf(Code1)...
  16. Runescope

    Resolved Setting drawstring color from fontdialog

    Greetings! I have text that I am trying to print and while I can get the font that is displayed from the font dialog quite easily, when I try and grab the colour it won't let me do it as the color in e.Graphics.DrawString is set using a brush, and the font dialog returns a color. I'm...
Back
Top