Search options

@Sparrow,

Thank you very much for your help.

Very good example and useful.

Hello Derek,

Oh I see. Yes, you're right is much better option. Thank you for providing me this concept. I'll make sure to put it in good use
Still have much to learn.

Enjoy the weekend,
Tommy.

Thank you Sparrow.

I'll check it.

Hello everyone and thank you for all your help.

Sparrow, yes I did this as you mentioned and I created this based on a template from countries and cities replacing the actual tables with a different names and keeping the format and settings.
Vladimir your code was what I had in mind and I tried that as well but for some reason I was experiencing an unusual error. And thanks to both of you I found where was the problem. The issue was on a grid that was on a second form that was creating a bug and creating ghost entries. Once I deleted it and wiped out all data and re enter the data everything was working like charm.

Thank you for all your help.

Hello Derek,

You are right I should have attach the sample project, but for yet another time you gave me the answer with the autofill A sample. That's exactly what I was looking for by using SQL command but I hadn't manage to find the correct expression.

Hope that I won't  bother you more with my annoying questions ha ha ha.

Have a goodnight.

Tommy.

Good morning everyone and thank you for your answers.

As you can imagine I've just started the programming and every start is difficult, so I try to experiment with different stuff to obtain experience. I try to ask for help only in a situations that I'm cornered and I'm grateful for every help.
derek thanks once again for your explanation and your tips at thinking of how to solve the problems. Your example is great and it helped me figure it out on my other problem that I had. But this time maybe I was not mentioned clearly what was my idea and if it is a pain to create id I'll just use a simple checkbox and won't disturb anyone else.
So what I want to do is based on the machine type that correspond to a model I want to hide fields at another form. I thought that by using a combobox and the value that is used to store when adding a record to a table should work but then I noticed that it didn't because it has to read not the combobox value but the modeltype_id based on a model that is attached to. So the code should be something like:

if form1.tablegrid.columnname.id = 1 then form2.edit1.visible := false;

but as I mentioned earlier I'm novice and hasn't fully update my knowledge of programming haha.

Thank you in advance once again.

Thank you for your replies.

That's what I was thinking to make changes to the user authorities without the need of closing the application, but I found something else which also is useful at least in my situation.
I've disabled the main menu options that are shown in the main form (form1) by default using the code I've found posted in another article:

Form1.mniFile.Visible := False;
Form1.mniOptions.Visible := False;
Form1.mniAbout.Visible := False;
Form1.mniReport.Visible := False;

and create a checkbox item that is visible only to the administrator and whenever it is checked it changes the menu visibility to true and show all the options again and modify whatever I want to and by unchecking it, it returns to the custom menu that I created. This is the code that I used maybe someone else will need it:

procedure Form1_CheckBox1_OnClick (Sender: TObject);

begin

If Form1.CheckBox1.Checked Then
begin
   Form1.mniFile.Visible := True;
   Form1.mniOptions.Visible := True;
   Form1.mniAbout.Visible := True;
   Form1.mniReport.Visible := True;
end
Else
  begin
   Form1.mniFile.Visible := False;
   Form1.mniOptions.Visible := False;
   Form1.mniAbout.Visible := False;
   Form1.mniReport.Visible := False;
   end
end;

I was wondering if you can create dynamic submenu items. I found some codes from another sites but they don't work for some reason. Anyway I attach photo of how do I imagine the menu.

Thank all of you for your help once again.