Flexgrid or data grid and how?

Oops :blush: it was just the person column not the time. Sorry! I have also decided to add a textbox to search by name. I can do that part. I think.. :)
I'm also having I guess a problem when I switch between queries sometimes it makes an appointment at 7:30 appt on the first column until I restart the app but that not a big deal. I'm thinking I'll play with refresh and redraw and see if that will fix it.

BTW. Is there a way to make a right-click on an appointment go into edit appointment mode? Or what would you say would be an appropriate way to edit an already scheduled appointment. I had forgotten all about this part?

I thought as much, but it's better that you know why the Time message would appear (just in case it ever does).

As to why the switching queries is a bit odd, are you running both subs to fill the grid? (you should be).


The editing of appointments could be awkward, I'm not really sure what would be the best way.

To detect a right click, use the MouseUp event (to keep the same style as other Windows apps & controls), and check that the Button parameter is 2. The next thing to do (or possibly before the check above) is to store the MouseRow and MouseCol properties into variables - just in case the mouse moves while your code is running.

Here's where things get debatable... I'm thinking that the first thing to check is if there is text in the cell (using TextMatrix with the variables you stored MouseRow and MouseCol in), if not then add a new appointment.

If there is text, you can tell the person (from ColData which we used in FillAppts), and the time of the row that was clicked in (using TextMatrix with a column of 0, and your MouseRow variable). From these you could use an SQL statement to load the appropriate record for the 'edit' form.

I'm sure there's a better way to do this, but I cant think of it at the moment!

Hi

I trying to do something like this, but I'm using Spread 3.0 , It do not have a Merge Cells :( :(

Are there way to do it, without user Control?

You can use the FlexGrid, as it comes with VB (you just need to select it in "Project" -> "Components").

If that isn't suitable, but the control you are using still has a "grid" style, you could do something fairly similar but without actually merging cells. What you could do is set the background colour of the cells that "should" be merged, and just place one line of text in each of the cells.

Thanks

I do not know, how Can I to resolve this :


appt1 09:00 - 10:00

If I want to do apointment in 08:00 -11:00 , How can I to verify that APPT1 is using 09:00- 10:00 ?

I have no idea what you mean I'm afraid.

As this thread is already so long (and as your problem isn't quite the same thing) it would be better to post as a separate thread - perhaps the one where I told you about this one. ;)

Hi graphixphantix,

I need you help, I need your project.

Can you help me?

graphixphantix, help me.

I need your help.

I have a problem in "Column person not found!"

Do you have any idea?