Moishe

Thank you very much I got it!

Thanks for your reply. I converted to vb.net and it didn't work not only BETWEEN but als AND keywords and how can I also selec customer name in the same rowfilter Thanks for your help

Hi All I have a textBoxName, startDate and endDate What string should I put in the rowfilter so after it would give me the name rows for all days like between these days in my dataview. this is how it is in the select comment select textBoxName from table where [date] between startDate and endDate Thanks for your help

Hi All I have a column (Time) in the tablestyle collection I want to format it to "00:00" when user enter 1100 it woud format it to 11:00 and also validate if it is a valid input? I tried doing it in the designer propeties for the format something like format: "00:00" but it didn't work. Thanks for your help.

That didn't work. I want it to be visible but not accessable right now I have it readonly but I still can navigate or click there.

Hi All, Does anyone know how to block access to a column in the datagrid? Thanks

Hi All I have a datagrid and a list box in the other form when I insert records inside datagrid cell it inserts it and selects the whole row and prevents arrow buttons from navigating through the grid. Does any one know how to fix it? P.S How do I update dataset while typing something in the cell without going into other cells or rows?

Thank you very much

Thank you very much

Data Access from 2 Forms Hi All, I have a datagrid in oneform and a list box in the other form Does anyone know how can I put an item from the list box into the selected cell in the datagrid in the other form upon pressing enter? I have a short cut which brings out that listbox in a particular cell in the datagrid. Thanks

Hi, Does anyone know how do I novigate through DateTimePicker in the way that when I press leftbutton it would go to the previous day and the same thing for the next day. I know how to do it in the monthcalendar but I need to use datetimepicker. Thanks

The short key works when I'm on the form but it should only work when the cell in the datagrid is selected. Thanks for your help

Hi, I want to make my datagrid column cells to accept short cut keys defined by myself. I created a textbox control and I want to press F5 when the cell is selected my groupbox will be visible on the form. Private Sub dbrDay_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles MyBase.KeyDown 'If dbrDay.CurrentCell.ColumnNumber = 3 Then And e.KeyCode = Keys.F5 Then e.Handled = True grpVendor.Visible = True Else grpVendor.Visible = False e.Handled = False End If End Sub This doesn't work! Thanks for your help

Thanks

KeyCode is not a member of a system.windows.forms.keypresseventargs

KeyCode Hi, I'm using VB.Net the vbKeyF5 code is &H74 and it givese me invalid synax error If e.vbKeyF5 = Keys.F5 Then blah end if Thanks for any help

Creating table with date and time Thanks for your reply. How do I set that anything in the dataview was changed than update what ever being changed Thanks for your help

Hi All Does any one know how to update dataview and/or dataset by just typing inside the fields. It should work just like MS Excel which save data automatically in the "some windows databese" when going to another cell I'm using vb.net and dataadapter.update(dataset) dataset.acceptchanges() but it only works when I press the save button and press enter to go the other row and last row cannot update by pressing enter and then save button I want to work without pressing the save button Thanks

Hi All Does anyone know how to make a cells in a collumn to accept "CustomerID" from a lookup table. Basically when cell is selected the user presses a shortcut key like F5 and the Customer form view is selected and upon choosing a customer and pressing enter the "CustomerID" is placed inside that cell in the datagrid. Thanks

Hi All Does anyone know how to bind calendar control to a button so when I press button "Next Day" it would move to the next day in the calendar just like "--> button on the keyboard does" Thanks for your help

Thanks

Hi All I'm using data view for filtering my dataset. Does anyone know how to update dataview so my dataset will be updated also like I can update dataset with update method Thanks for any help

Thanks for your reply

Hi All Does anyone know how to create a table with times on one side having 2 columns per time like this: --------------------------------------- 6:00 --------------------------------------- ---------------------------------------- 6:30 ---------------------------------------- ----------------------------------------- and so on create table time ( time datetime ?????? date datetime ?????? ) insert into time values(????????????????????) Thanks for your reply