I've tried to use the DMAX Function in my VB windows application to find the highest value in a column in one of my tables, however it doesn't seem to work. After doing some research, I think that the function is only relevant to VBA, although I could be wrong.
'show me the maximum HCCID - DMAX
'Dim HCCNUM As Int32
'HCCNUM = DMAX("[HCCID]", "tblHCC")
How to find the maximum value in a column in one of the tables in my database?
i am creating a maths program that works out five number summarys of a range of data. i am having trouble working out the smallest number in a group of numbers. i have used a bunch of if then statements to work out the maximum and i figured that by exchanging a few variables and swapping greater than signs for less than i could use the same code to work out the minimum, but all i get is zero, no matter what i input into my textboxes. below is the code i have used to work out the maximum number
If CheckBox1.Checked = True And CheckBox6.Checked = True Then
max = 0
min = 1000
[Code]......
I feel there must be a single line, more elegant way to find the highest page number in my list of report pages. The code below works fine but seems verbose. Is there a better way?
Dim numofpages As Integer = 0
For Each reportrow In reportlist
If reportrow.reportpage > numofpages Then numofpages = reportrow.reportpage
[code].....
What I need to do is find a string that can be any value, and is placed between ">" and "</" with a minimun length of 5 and a maximum length of 7 and contains exactly 2 dots.
So if I have a text file like this:
<a href="www.site.com">a site</a>
text<br />
More test<br />
[Code]....
I want it to find only the 5.0.77. And no, the number isn't always between h2 tags, and the number isn't even always the same. The only thing that is static about it is that is is between ">" and "</" and that it is between 5 and 7 characters and contains 2 dots.
I am working on this exercise where i have to find suburbs with minimum and maximum percentage POS (public open space).
I manage to get the minimum and maximum but i need a way to allow for two or more suburbs with same minimum or maximum.. for examplethree subrubs ( suburb A, suburb B, and suburb C) all has same POS of 2%, then i need to list the three in the list box as minimum with subrub name(from my code i can get only one) with the maximum values as well( allow two or more suburbs with same maximum in a similar way)..
Below is the code.. i have removed some codes to make it read easy whi are not relevant.. i got POS percentage correct and i wanna start from there..
CODE:
i need to do a macro. this is what my excel looks like
1 2 3 4
seq1 name name seq2
abcde vv1 abcdddd
abcxy vv2 abcdlmn
[code]....
We have a DataGridView with 3 columns: InvoicedOn, PaidOn and Amount
On the MouseDown event is this line of code which needs to be fixed:
MsgBox(DataGridViewPayments.Item("Amount", DataGridViewPayments.CurrentRow.Index), "")
We are trying to find out what the value in the Amount column of the curent row.
We also get this error message:
Conversion from string "" to type 'Integer' is not valid.
how to fix the MsgBox so it will show the value?
I'm connected to an access database using VB 2008.. there is information already located in the tables. But what I am looking to do, is find the "SUM" of all the data in a certain column.
View 35 RepliesUsing VB.NET i want find a specific string that occurs in column B of an Excelsheet and copy that entire row and paste it in a new worksheet. This string occurs a couple of times in this B column.I know how to open up an excel sheet in VB but I'm having difficulties searching for the string and then copying that entire row and do it multiple times (loop until the end of the column)
View 4 RepliesIn WPF, I have a Uniform Grid and would like to be able to find the row and column based on the index of a child element.
I know there is a mathematical way of doing this and would rather not use a normal Grid.
If it helps, I can get the total number of rows and columns by using:
Math.Sqrt([*uniformgrid*].Children.Count)
I have:
- Table1 with columns: PK_ID1, LOCATION, DIRECTOR, SELLER, SELLERID, WORKTIME (relationship), WORKCODE
- Table2 with columns: PK_ID2, WORKCODE (relationship) & WORK_DESCRIPTION
My DataGridView do a SELECT * FROM Table1;How can I replace WORKCODE with WORK_DESCRIPTION in DataGridView, please?
I am getting the error "system.argumentException; Column ' test_id2' does not belong to table Table. At System.Data.GetDataColumn( string columnname0 at system.data.datarow.get_item(string columnName).
This error is occuring right after I set the parametervalues in the report object of the Crystal report.(Note this a visual basic.net 2005 windows form application.)
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cryRpt As New ReportDocument
Dim sql As String
[code]....
The value for the first parameter @Parm_1d1 value to the crystal report version 11 is correct. However, when trying to access the second @Parm_1d2 parameter ,the values past to the crystal report is not correct.
I would like to be able to run a query that could tell me where a given table/query is used within all of my queries. I would like to do this with SQL but VBA is also fine.
View 1 Replieshow to find the row position/index in a data table, using a value from another table. For example, I use the row position from Linkingtable1 to get my value for CustomerID, but i want to use the CustomerID to search the CustomerTable for its row position, in order to show the Customers Name in a text box, As currently when loading the textbox shows the customerID. I understand the code to get the names from the rows in the datatable, its just finding the row position of the customerID.
View 9 RepliesI get a Syntax Error with the following code"ALTER TABLE receipts RENAME COLUMN payees TO payee"what I am doing wrong
View 18 RepliesI am going to make a invoices then.. they are going to have a id it is not going to be identity, it is not my idea, this is the idea's my professor's. then he want it so..he didn't want i change id to int, he want it was varchar..but now i have seen this is as identity.. id =1, next id=2, next=id=3.. but it doesn't mind he told me in the future it is going to be so..
abc000002
abc000003
abc000004
[code]....
then for that he doesn't want i change it to int how can i get the last? i want it one plus next i want it was
abc000010
how can i do it? i am working on visual basic and visual studio 2008i can use a loop-for, or a query for solve it?
I have two tables: a schedule table that contains information about how an employee is scheduled and a numbers table in which each number corresponds to a date.
[Code]...
I can do this on the SQL side or the code side. I have Linq at my disposal if I need it. The table doesn't need to be compiled by SQL. This will happen dynamically on a website and should be as efficient as possible.I don't want to have to iterate through each and look for breaks in contiguous days if I don't have to.
In my code i have succesful get table column name. But i want the first table column name showing not all. rs.Open(strSQL, adcLEDGER, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockPessimistic)
Flds = adrCURR.Fields
TotalCount = Flds.Count
For Each fld In Flds
MsgBox(fld.Name)
Next
I have a table called Table1 which already has a few other columns and 4 rows. I want to add three new columns to it. When the columns are added I want all the cells in the column to equal the variable I supply in the Add method. When I add the column named "BatchID" it works beautifully, but when I add "UserID" it gives an error "Cannot find column [iqz9]". Why? This is how Table1 should look like:
[code]...
i recently posted a code that i had that i needed assistance for and it was solved it was for displaying all tables in a database.but now i have this code for showing all column names in a table i was in the process of turning it from oledb to sqlclient. GetOLedbSchema can be turned to getschema but when it comes to OleDbSchemaGuid
Public Shared Function getAllColumnNames(ByVal tblname As String) As String()
Dim com As New SqlCommand
Dim con As SqlConnection
[Code].....
i have this code for showing all column names in a table i was in the process of turning it from oledb to sqlclient. GetOLedbSchema can be turned to getschema but when it comes to OleDbSchemaGuid
Public Shared Function getAllColumnNames(ByVal tblname As String) As String()
Dim com As New SqlCommand
Dim con As SqlConnection
[Code]......
Column 'XX' already belongs to another Table?
View 4 RepliesI have a problem i want to display value of a column from table i want view the value when form loaded. I am writing this code on form load but its not working
Dim cnString As String
cnString = ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\PaymentSystem\PaymentSystem\bin\Debug\Payment.mdb;")
[Code].....
I am writing an app in VB2010. My code parses a text file, assigns data to variables My? and then attempts to store this data in an access 2010 table. Yet, whenever my code gets to MyRow.Item("Artist") = MyArtist I get an error 5 'Artist' does not belong to Table T, but the field/column does exist in the table as do all the others.[code]...
View 5 RepliesVB has created the following code:
Partial
Public Class AwardsDataSet
Partial Class RevExpDataTable
[code]....
I am not sure of the command for format the Table 'Revenue' column for currency. Also is there a way to do calculations? I need to multiply the value by -1?
currently, what i want to do is, add a column in a table "default" during runtime. Well, I've got that covered already.
The problem is, the column names are actually taken from the users input through a textbox or drop down list and of course, if the same column is added already in the table, it generates an error since it has to be unique.
That is why i wonder if it is possible to know if a column already exists without viewing the form which contains the grid view of that table?
Is there a quick way to put unique value to column in a table? Assuming I want numeric values starting from 0.
View 4 RepliesHere is my problem:I have 2 tables Accounts and Transaction Logs.in Accounts table, it has column "Amount" which is a base amount of an account.and in Trans Logs table, it also has column "Amount" which is additional (add or minus to the base amount) amount of the account.and I don't know how to retrieve that base amount to edit it, then save it back to the table.That means I need to get a value of the right column by using Acc_No to find. I'm using DataSet, by the way.i think it should go like this:
Dim Amount as Decimal
Amount = *the code to retrieve the base amount*
Amount = Amount + txtAmount.Text
*the code to save the new amount back to Accounts table*
i am developing a software using microsoft visual studio basic 2010. I set up a connection string to my server and take the data from there. I am using gridcontrolview and put my "product" table in here. It contain 4 column: systemid, system, actualid, description. I want to display only system column (it's easy, just hide the others column) But, In "system" column, there are a lot of similar data, i want to display only distinct data from this column in the grid
example, the column consist: STSTEM
topaz
topaz
topaz
[Code]....
i try to user "add query", buat if i get rid of the other 3 column, there will be error message like "the output is different with the schema"
I need to add a column to an existing table in my database. I am having trouble adding a column to my database. I physically go into Microsoft Access and add the column, my problem comes up when Visual Studio does not recognize the table. Basically, I think I'm doing something wrong.
View 5 Replies