Creating a custom calendar form

[polytimi8]

Hello,

I want to make a calendar form for scheduling of surgery operating
rooms in a hospital which shows in horizontal bar(columns) the
operating rooms and vertical (rows)the times for which a room is
closed. In the blocked box I want to be appeared the name of doctor,
patient and the kind of operation.
All above information are found (room id, patient id, doctor id,
beginning time of surgery, ending time of surgery, kind of operation)
stored in a SQL Server table. The whole aplication's forms have been
constructed in VB.

Do you have any ideas how I can make this form quickly? Is it a good
idea to use Excel and a build a form there which sees data in SQl
server or to make directly a form in VB that sees the SQL Server
table?

Thank you in advance!

 

[Keith Willshaw]

Hello,

I want to make a calendar form for scheduling of surgery operating
rooms in a hospital which shows in horizontal bar(columns) the
operating rooms and vertical (rows)the times for which a room is
closed. In the blocked box I want to be appeared the name of doctor,
patient and the kind of operation.
All above information are found (room id, patient id, doctor id,
beginning time of surgery, ending time of surgery, kind of operation)
stored in a SQL Server table. The whole aplication's forms have been
constructed in VB.

Do you have any ideas how I can make this form quickly? Is it a good
idea to use Excel and a build a form there which sees data in SQl
server or to make directly a form in VB that sees the SQL Server
table?

Personally I'd do it in VB using ADO and the Data Bound Grid

Read the data into an ADO recordset and bind the grid to the
recordset

Keith