Here is the code:=First(Fields!Asiakas1.Value, "DataSet1") & vbCrLf & First(Fields!Asiakas2.Value, "DataSet1") & vbCrLf & First(Fields!Asiakas3.Value, "DataSet1")
how do i make First(Fields!Asiakas1.Value, "DataSet1") Bold?
I am working on an application in Visual Basic Express using an Access 2000 database.I am trying to get athe following SQL query to work but get an error in Access.
The query is:
SELECT [ID], [Title], [Author], [Series], [YearPublished], [ISBN], [CoverPrice], [Style], [Condition], [Signed], [Comments], Count([Title]) AS CountOfBooks, Sum([CoverPrice]) AS TotalCoverPrice FROM tblBooks WHERE ID=[@ID];
The error is:"You have tried to execute a query that does not include the spec ified expression 'ID' as a part of the aggragate function."
The query works fine without the 'Count' and 'CoverPrice' count and sum to the query.
I must convert string data from a CNC that is arithmetic expression to a number that I can use in a VB application that I wrote. The following is what I get out of the cnc. [18722*65536+19377]/67108864. I need to evaluate this expression in my VB ap. The format of the string is not always the same as what I have illustrated.
I have a string of 5 characters out of which the first two characters should be in some list and next three should be in some other list.How could i validate them with regular expressions? [code]My Strings are going to be: VBBEG, CSBEG, etc.My regular expression should find that the input string first two characters could be either VB, CS, HT and the rest should also be like that.
One number is represented with four hex values.First two hex parts are my "whole number" part, third and fouth hex numbers are my "decimal" part. I just wanted to store my complete number (whole and decimal) in an excel table.My problem is following when I am storing whole part and decimal part of my number separately, then it works fine am getting f.e. 3017 and 0,9445123 in my excel table, but when I am concatenate them, then I am getting following expression in my excel table f.e. 30,179,445,123 but I want 3017,9445123.
I am building an application to update a database.I have a Map table where row 0 holds the target table field name Row 1 holds an update value or Source table Column name Row 2 holds a Where condition eg
In this example I am going to update the Target Table Field 'Val1' to 25 where the Target Table Rows have Field 'Val1' data > 14 AND Target Table Field 'CustNo' = the Source Table Field 'CustNo' AND the Target Table Field 'Val1' > the Source Table Field 'Fld14' Where I am stuck is I at the moment is wondering how I should convert the strings into test conditions as I iterate the Target Table eg Say my test string is stTest and it holds " = 25" For each dr as datarow in dtTarget
some code
... stFld = "Val1" if dr(stFld) { convert stTest into literal '=' and then 25}
... do something the only way I can think is to build up a series of test cases like:
I'm looking for some code in .net to allow me to test an xml file to determine if it is well-formed. I am not validating the file against a schema at this point in my code, just testing that it conforms to xml specification for being well formed.
How do i detect a part of a string from a string? For example: i want to check if the part of the string "mummy" exists in a string:"Mummy loves Daddy and loves me too"
How to cut part from this string..."abb.c.d+de.ee+f.xxx+qaa.+.,,s,"... where i know position by this: Result is always between "." (left side of result) and "+" (right side).I know number of "." from left side and number of "+" from right side, to delimit resulting string.Problem is right side, cause i need to count "+" from end.
Say... from left side: begining is at 4th "." ( this is easy ), result is =
I would like to display only part of string. I am able to do that as long as my string is constant, how the string is not constant. How would display only the last part of my string. The string will actually be displayed by using a browse button and selecting a file.
i have the folowing problem: i made a combobox on my form and in order to add items to it i use a normal textbox and a string in application settings, the textbox add's the item in both the combobox( with this code ComboBox1.Items.Add(TextBox1.Text) ) and the string in application settings with the folowing code:
How can I remove all of the text to the right of the second to last / in a string. Before = ftp://sylenttechnologies.com/text/test/another test/ After = ftp://sylenttechnologies.com/text/test/
I would like to have a only part of a string... I have a string[URL] and i want only the part thats past the last / so i would actualy get only "file.part4.rar"I know that this can be done through Regex, But I have never used that, and I read the documentation on it, but I do not understand the part of...
Dim rx As New Regex("^-?d+(.d{2})?$")
What dose each of those characters do and how dose it effect the output...