In MS Access you can set the background to a specific colour when the field has the focus. This is done through "conditional formatting", using the "Field has Focus" feature. How is that done in VB.NET?
View 5 RepliesUsing VB 2008, I have a form which includes a richtextbox which is bound to a database field. When i bind the datafield to the richtextbox, I get an unformatted display unlike the control in VB6. How can I bind the data from the database to the richtextbox so that it displays formatted?
View 1 RepliesI have a DGV that is bound to an Access DB DataTable. I have added a column in the DB that is either a 0 or a 1. When the program loads, I want to change the backcolor and forecolor of each row based on the value of this column's cell. ie: a 1 makes the row red, a 0 makes the row green. this column would be hidden in the DGV.
Is this possible to do at runtime even though it is bound?
I'm not sure when I would actually do the color swap, formLoad?
Second question, as I iterate through each row of the DataGridView and need to change the value of this column, will this update my DB automatically, or do I need to call an update() after each row?
I want to add BarType conditional formatting for my range !
I have :
sheet.Range("F3").FormatConditions.AddDatabar()
How to add :
MinPoint
MaxPoint
BarColor
???
I tried :
sheet.Range("F3").FormatConditions(1).MinPoint = New ConditionValue(ConditionValueType.LowestValue, "0")
But It gives Error : ConditionalValue is not defined.. ??
I have following imports :
Imports Excel = Microsoft.Office.Interop.Excel
Is there a way to conditionally format an Excel Chart? For example I have a bar graph. Currently I have the bars a purple color. I would like to turn a certain bar red if it meets certain criteria. Is there anyway to do this?
View 1 RepliesI have a column 'A' in worksheet 'two' and another column 'B' in worksheet 'one' !I want to copy the conditional formatting of Column A in two to Column B in one !Basically, I want to copy everything from Column A in two to Column B in one except the data
View 1 RepliesI am frustrated that I cannot solve this seemingly easy problem:
Here's the code:
If Date.Now.Day = vbSaturday Then
Label6.Visible = False
[code]....
I have to Visual Basic 2008. DataGridView I want to make Conditional formatting. Date Column type based on the rows that meet condion want to paint.
View 2 RepliesI want to update contacts in a database from VB, where the field value is N/A. The following will update all fields where phone = @Phone, however I want to update those fields IF they have N/A in already. Can it be done in SQL?
[Code]....
I'm trying to format a datetime field to just show the date. The datetime is bound to an asp:label and for the Text attribute I have tried the following....
Text= String.Format("{0:D}", '<%# Bind("CReviewDate") %>')
and
Text= String.Format("{0:D}", <%# Bind("CReviewDate") %>)
[code]....
In all cases I get a green wavy line under the equation and the tip help says "Validation (ASP.Net): If this attribute value is enclosed in quotation marks, the quotation marks must match.
String.Format("{0:D}", DateTime.Now)
is the syntax that I have been told should work.
I am loading a form in a tabbed window but when the form loads it does not default into any field on the form. I want it to automatically default to the first field on the form, how do i do this?
View 12 RepliesI have a VB Application that is loading an Array with Numbers from the Sequel Server that have numbers 315054 no cents and leaving the .00 off even numbers. I need to write out the number to a textfile that has 14 zero's to the left removing the decimal point from the number.
The Number should format and be written out like this:
00000031505400 in the text file.
My coding does this as long as the even number has a decimal point .00 but if the number comes in as 315054 into my array my coding gives an Argument error with the coding below.
SCreditTextBox1 = Microsoft.VisualBasic.Right("00000000000000" & Microsoft.VisualBasic.Left(_sData(Irow, 7), _sData(Irow, 7, ".") - 1) & _
Microsoft.VisualBasic.Right(_sData(Irow, 7), 2), 14)
Is there a way to check for no decimal point and then place the number with no .00 as 00000031505400?
The accounting people are entering the numbers into the server this way incorrectly. The .00 is suppose to be entered with it, but not all even numbers are entered this way without .00, just a few, but I need to check the number to see if there are decimals and without decimals do something. Could my coding be re-written to account for not having the .00 and to format the number correctly to avoid the argument error?
I need for any number to format with:
$3,000.00 would appear in server as 3000 or 3000.00 and should write out like this below: I need to check for decimals and without decimals and writeout the format like this below:
00000000300000.
I'm working on this project, and when the form loads it should automatically put the Focus on the username field if it is empty, however if there is a username - put the focus on where you write your message.Below is the code, and it simply doesn't seem to work for whatever reason. I have tried several methods of it, and even commented out every other line of code in the application to make sure there was no interference, and there was none. is there anything that could possibly overwrite the ability to do this? Some setting I need to change? etc etc?
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If String.IsNullOrEmpty(txtUser.Text) Then
txtUser.Focus()
Else
[code].....
I'm working on an access database and there is a problem I can solve in a circumvented way but I was wondering if it can be done by using a function in query.The case: I have a main data table and 2 other tables joined to it.
maintable
country | city...... | postalcode [code].....
From one of the tables I select the respective zone for the postal codes in the main datatable, ie. if the row's postal code column contains 1000 (just an exmple) then the postal code is searched in the "zone" table "from" & "to" columns using "between", and it results in for example "zone1" (zone column). This is a clear thing, it works okay.However I need to select the respective rate column (based on the rows' weight column) from the rates table selecting the appropriate zone.
I can solve this by a switch statment (select country, city.... switch( zone="1", [1], zone="2", [2] etc.) but it gets very tedious when for example I have a rate table with 15 columns, you can imagine that.My question is if I could create a custom function which returned the respective column based on the result of the zone column.is there some way to get the function's return value to be translated in the select statement? for example select country, city....getzone("rates",[zone]) .....
I know that the rates table do not follow the relational database's main principle and it should look like fromkg | tokg | zone | rate and it would work like a charm with "where"but these tables are changed regularly and I receive them in excel...but maybe transforming the tables each time by unions would easily solve my problem doesnt it?I'm still interested if VBA custom function could be used for such a purpose.
I would like to give permission to use this project to say, 10 users. The following code is fine for a single user. How can I write conditional code to provide the access to other nine users?
Submit button
If txtUsername.Text <> "Mahajan" Or txtPassword.Text <> "mh745" Then
MsgBox "Access Denied! Either Username or Password is incorrect!", vbOKOnly + vbCritical, "Security Login"
txtUsername.Text = ""
txtPassword.Text = ""
[code]....
I am working on a carputer app, and it will be relatively basic with common tools. I am going to make an onscreen keyboard that fits the style of my app, but I want to make it a seperate application from the main app. All I want it to do is is have my keyboard become visible whenever I enter a text field of any application, whether it be programmed by me or a third-party app. Think about this in the way of a smart phone... Whenever you enter a textfield the system keyboard is displayed.
View 2 RepliesUI is created in VS 2008. I'm using C# .... I need to let the user move/focus between text fields from top to bottom by clicking tab button. How can i do it?
View 2 RepliesI have my form connected to an access database. Two of my fields for example are Date of birth and money. In the access database the DOB field is set to a data type of date/time(shortdate) and the money field is set to currency.When I run my app if i type 5/23/09 into the DOB field it'll auto update the textbox in the form to 5/23/2009 (which is great). If I type 200.4 into the money field it wont add a $ sign or update to two decimals but it will save as $200.40 in the DB. How do I make the money field auto update like the DOB field to format to currency right away?
View 3 Repliesi have to update the values in my database some of them are integer, some string and some date (as you can infer from the formatting)
i am using the following query:
UPDATE PatientProfile SET HospitalRegNo=" + hregno + ", PatientName='" + pname + "', PatientAge=" + page + ", PatientSex='" + psex + "', Address='" + add + "', ContactNo='" + cno + "', AdmitDate=#" + adat + "#, OperDate=#" + odat + "#, DischargeDate=#" + ddat + "# WHERE PatientNo=" + pno + ""
but its not working... i think there's a problem in formatting the date type variables
With two of my forms, which present empty text boxes, I execute a statement of the form frmAdd.txtBox.Focus(). This places a blinking insert bar at the begining of an upper left text box, which is what I want. For a third form, in which the text boxes are filled in, the statement frmChange.txtBox.Focus() not only sets the insert bar, but also blocks the entire text; any inadvertent keystroke could delete the whole text, which is NOT what I want.How can I place the focus on the text box without pre-selecting the whole field?
View 3 RepliesI can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 RepliesI download a file into access. One field contains one to many numbers always separated by a colon and a space: I have no control over the download. TheNumbers have a 1 to many relationship to a customer. Each number must then be verified against two separate reference files, and if the numbers match the description related to the number will be displayed.I'm just learning visual basic. I've made the changes manually (yuk-this took forever); I've tried various string/conversion commands; I've taken the data and placed it into excel and tried to manipulate it, without success.In this case is always numeric. In another field, similar problem, it's a combination of text and numbers.
Example: Cust# TheNumbers
99 1234; 12345678; 123123; etc...
88 87654321, 345654, 98989898. etc..
The numbers can vary in length and quantity. For each customer each number must be loaded into one field.
Example outcome:
Cust# TheNumber
99 1234
99 12345678
[code]....
I am trying to get the Sum values of a Column and want to check if entered value in Textbox is valid. Here is my code below
[Code]...
i have a table name product , when i m inserting data into product i need to first check if Product Name already exist in database if yes i want to exit. basically i want to know how to get data from the database and how to access columns in asp.net .
View 4 RepliesHow to get access Field name and type in VB.net Listview?
View 5 RepliesI am new in VB.net. I would like to display picture in Attachement fields in Access table ina Window form with VB.net.I created a Window form using Visual Studio ( sorry, I am new in Visual Studio too and set the Access table as the data source.
View 2 RepliesI have some VB .NET software that interfaces to a load of old (but sound) COM objects. The VB provides a GUI for the COM objects, part of which consists of setting various options on the COM objects - several of which relate to string formatting.I have a simple pair of VB .NET functions that convert basic %f, %d, %g formats to/from .NET equivalents using a large select case covering specific common strings, but they don't cover all formats.[code]Before I start diving in and making it more versatile with some parsing, does anyone know of a class (eg VB or C# .NET) that provides a decent ready-made implementation? Or perhaps some regexp wizadry could be used?
View 2 RepliesI have a query which I test and work fine in Access[code]...
When I try it, it comes up with an error: "Undefined function 'Nz' in expression.
I need to create a field in my database access throught code... I had this code in VB6 to do the job,but i'm a little confused with the way to do this in VS2008.Off course I know the way to open the database,but the way for create the field I don't know!
Dim tdf As TableDef, fld As Field, Top As TableDef
Dim nCtr As Integer
Dim bFound As Boolean
[Code]....
I'm using VB2005 and I got a message error in a runtime: Abstract does not belong to table tblBooks. I don't think that the problem is its datatype. I'm currently using MEMO datatype because I need to load it more than the capacity of string. Is it possible to use this code in order to accomplish it? txtAbstractInfo.Text = MyTable.Tables(0).Rows(Counter)("Abstract").ToString
txtAbstractInfo is the name of my textbox and my field's name is Abstract.