Datagrid MS Access and VB.Net

Please support our VB.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Aug 2007
Posts: 16
Reputation: jaytheguru is an unknown quantity at this point 
Solved Threads: 0
jaytheguru jaytheguru is offline Offline
Newbie Poster

Datagrid MS Access and VB.Net

 
0
  #1
Jun 16th, 2008
Afternoon all, I have taken up a task where end user should be able to enter information via vb interface into microsoft Access database. This then will be displayed onto the Datagrid via VB interface. The program needs to be setup in a way that first entry by end user will flash upon 3 hours.

Example:

VB Interface
=========
Basket Number | Number of Trays | Run Type | Time In
1 | 1 | CNC | 15:00:00

Where
Basket Number = Text Box (in Access field is set as Number (Int))
Number of Trays = Text Box (in Access field is set as Number (Int))
Run Type = Combo Box (in Access, field is set as Text (String))
Time In = Date time picker in Time mode (in Access field is set as DateTime (DateTime))

DataGrid
======
Values defined within database shows in this datagrid.

The Datagrid works fine and I can insert values into the database fine as well however, I am not sure how to setup a timer so that when 3 hours are up the first entry into the database(shown on datagrid) starts flashing.

This is needed so that the end user gets an alert when the time is up so that he can take the trays out of the oven.

In Summary: Can we really setup a timmer so that a value in the datagrid will flash at a particular time.

Many thanks

Regards

Jay
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 16
Reputation: jaytheguru is an unknown quantity at this point 
Solved Threads: 0
jaytheguru jaytheguru is offline Offline
Newbie Poster

Re: Datagrid MS Access and VB.Net

 
0
  #2
Jun 17th, 2008
Morning guys,

right I added a timer to the form. The rows gets filled with yellow colour after a particular time however, all the rows gets coloured instead of only one or two (whose time limit has been passed).

any ideas how I can setup something where it colours only the row (not all rows but particular row/s) which has passed a time limit.?

many thanks

regards

J
Reply With Quote Quick reply to this message  
Join Date: Feb 2009
Posts: 1
Reputation: almcnicoll is an unknown quantity at this point 
Solved Threads: 0
almcnicoll almcnicoll is offline Offline
Newbie Poster

Re: Datagrid MS Access and VB.Net

 
0
  #3
Feb 5th, 2009
Maybe you could post some code for us to see? I imagine you need to refer to myDataGrid.Rows(i)...
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC