Recent content by Draug

I finally got it working, using the first of the three lines I was trying: dvSingleTransaction.RowFilter = "u_varBarCode = '0617'" I create that line by using: dvSingleTransaction.RowFilter = "u_varBarCode ='" & FilterValue & "'" FilterValue is a String that pulls its value from the same...

HELP! I've been banging my head for hours on this. It seems that my dataview has no filter being applied after I've set the RowFilter property. I have the following: Dim daTransaction as DataAdapter Dim dsTransaction as DataSet 'Fill Transaction table of dsTransaction...

getChanges() is a built in method of the dataset class. It retrieves the changes made on a dataset during that edit session. There is hasChanges() and acceptChanges(), and maybe more.

Yeah, I have learned that is has something to do with the Edit of the current record not ending at point of leaving a box. From a dataset point of view, that record is still being editted. I fixed that by adding this before getChanges: Dim bmPS As BindingManagerBase bmPS =...

Greetings, I have a textbox that is bound to a dataset. The dataset is populated by a data adapter which pulls data from a table in the database. When I change the value in the textbox, I cannot get that change to be recorded in the database. It looks to me like what I have done should work...

It is the form of rounding that they employ. It is actually supposed to do that. Math.Round uses "Rounding to the Nearest". From the Decimal.Round documentation (which also uses Rounding to the Nearest")... "When d is exactly halfway between two rounded values, the...

Greetings, Is there an even similar to TextChanged that I can use that will fire when a textbox value has been updated? Let me explain the situation, and why I dont think TextChanged is adequate. I have numerous pairs of textboxes. One box for a metric value, and one for the corresponding...

Greetings, I have a datagrid that is linked to a Datasource. When a record contains null in one of its fields, I want to highlight the whole row for that record in Red. Does anyone have an example to do such a thing? Thanks, Draug

Good News! It is only the design time setting of that RowHeadersVisible property that does not work. I can successfully hide it if it is done in the code, as follows: Dim TableStyle As New DataGridTableStyle() dsOwner.TableStyles.Add(TableStyle) TableStyle.RowHeadersVisible = False Just...

Yes, you guessed it, I am using version 1.1. I had to update it because there was an issue with 1.0, in conjunction with XP Pro, that would not allow the server that a Webservice was running from to be found. That is pretty brutal that it works to hide that row header in 1.0, and not in 1.1...

Thanks Durkin. I too thought the RowHeadersVisible Property would hide that record selector, but it did not. As far as looking at the Listview, I just read up on it after you mentioned it, and it does seem to do what I had set out to do. Can you update a dataset with a ListView? Draug

Greetings, I am new to VB, but have managed to slog my way through the formatting of a datagrid, mostly due to the information I have captured from many posts in this forum. Let me express my thanks to all those that offer words of wisdom here. I have my Grid looking pretty much how I would...

Thanks for the help folks. Works like a charm! :)

Greetings, I have a combo box that is linked to a lookup table of possible values. The table looks as follows: ID | DESCRIPTION 01 | Inactive 02 | Suspended 03 | Active ...| ... Now, my combo box retrieves both colomns, but the first colomn (ID which is the Primary Key) is set to a width of...

Tracy, yes, I could do that. But, is there not a more elegant way to do it? I mean, validating data, alerting the user to an error, and then setting the cursor to the place that needs correction is a simple (in concept) thing to do. Can Access provide us no way of doing such a thing? Thanks...