Search options (Page 29 of 42)

Hi Dmitry,
Are above complicated and requires too much of your time?

Thanks a lot Dmitry.............

Script is beyond me in most parts. How can I change clock face, size, use numbers such as 9-3 12-6 or IX-III XII-VI etc. instead of o? And resizing pens length according to clock face?

Thanks a lot Derek...........................

I love derekscroll... in this case myscroll as you have changed it to demonstrate it could be any name.
I didn't need a tgrid on adding editing details  form (frmEmpployee), so I deleted it. Added couple of lines for save button on frmEmpployee so that it focuses on newly added record and display details.

-------------

Hi Derek,

Thank you very much for the latest update..........
Very kind of you and appreciated

I liked your custom/global procedure that makes tGrid auto row selection great if I understood correctly. In this case there is no need for refresh after delete/edit/ save.

I prefer the approach of; if a button is not clickable then it should be displayed as disabled. I'm not saying it's better but just a personal preference.
So, I did buttons enable/disable with panels version. I also added clear script to cancel button. If I didn't make a mistake attached sample project is exactly what I wanted do. I couldn't have done it without your help.

I may have made a mistake without realizing. My understanding of "Enabled=false means that the user sees the object but can't click" and Visible=false means that the user cannot see or click into the component where property visible set to false. i.e. I put a button on a form with Visible=false, on run I cannot see or click on it. Perhaps you are trying to explain something else and I'm not getting it?

Tried the following but no luck

procedure Form1_OnClick (Sender: string);
begin
      if Form1.Worcester_L.Visible then
         begin
              Form1.Worcester.Caption:= '- WORCESTER';
              Form1.Worcester_L.Visible:= True;
              Form1.Height:= 331;
         end;
end;

I haven't started the project I'm thinking to use accordion. The idea is not to show every fields on the form to user immediately so that they would choose which fields are needed for the task in hand.

Hi Derek,

Thank you very much for the example.

I like it to do bit more. Here is the illustration of what I wanted do:

As you can see form is expanded where not enough space and following accordion header also pushed down.
Also when new accordion header expanded, previous open accordion is collapsed.

Hi v_pozidis,

Perhaps you may find some details here:
http://myvisualdatabase.com/help_en/

More help links are here:
My Visual Database → General → Documentation in English

As it was asking for onCellClick so I added an empty onCellClick procedure as below and naturally error disappeared:

procedure Form1_TableGrid1_OnCellClick (Sender: string; ACol, ARow: Integer);
begin
end;

procedure Form1_Button3_OnAfterClick (Sender: string);
var
i: integer;
begin
      i:= Form1.TableGrid1.RowCount;
      Form1.TableGrid1.SelectedRow:= i-1;
      Form1_TableGrid1_OnCellClick('',0,0);
end;

procedure frmAdd_Button1_OnAfterClick (Sender: string);
begin
      Form1.TableGrid1.dbItemID:= Last_Insert_id;
      Form1_TableGrid1_OnCellClick('',0,0);
end;

However, I'm not sure the above is correct way of doing this... Is it possible to put refresh script above under one procedure?

Following refresh after add/edit/delete script returns - Undeclared identifier: "Form1_OnCellClick.."

procedure Form1_Button3_OnAfterClick (Sender: string);
var
i: integer;
begin
      i:= Form1.TableGrid1.RowCount;
      Form1.TableGrid1.SelectedRow:= i-1;
      Form1_TableGrid1_OnCellClick('',0,0);
end;

procedure frmAdd_Button1_OnAfterClick (Sender: string);
begin
      Form1.TableGrid1.dbItemID:= Last_Insert_id;
      Form1_TableGrid1_OnCellClick('',0,0);
end;

I have checked form, tGrid and buttons names... Cannot get rid off it.

bemorhona-qt's sample project fix works but this one is not. What am I missing???

I have updated the test project. Please see the attached...

1. I have changed courses table to library so that it makes better sense in respect of what I'm trying to do. Issue of displaying library details of selected school on form1 / School Library tab?

2. Another issue I have noticed. When double click on a record on SCHOOLS tGrid it opens two form; frmSchool and frmLibrary. When clicked on edit button it opens the correct form only. How can we make it to open active tab specific form on doubleclick too? This item is SOLVED thanks to Dmitry's script. However other items are still not resolved.

3. I have tried to use different method (thanks to bemorhona-qt) to refresh records display after add/edit/delete. However, my implementation works partially. On schools tGrid/details only delete refreshes.  On Students tGrid Edit and Delete refreshes but not Add. Perhaps bemorhona-qt could offer a help again?

4. I couldn't find the way to work DateTime component spinbox arrows?