76 Reply by reteinformatica

(18 replies, posted in General)

Hi Derek and as always thank you very much. My aim would be to be able to display the customer list in the left TableGrid in the first form and by selecting the customer in the right TableGrid, show all the interventions relating to this customer. But I haven't gotten here yet due to the problem I was experiencing that was still to be solved.
Based on your suggestions I made some changes to my initial project and I'm faced with a problem that will be the usual stupidity but from which I can't get out of it.
In the 'frmSettings' form which is then also called by the 'Nuovo stato (New State)' button of the 'frmInterventi' form as well as by the 'Impostazioni (Settings)' button of the first form (frmMain), in the third tab (Stato) there is the TableGrid 'tbStato' which it is configured in exactly the same way as the other two present in the same form.
Only when running the program instead of making me write to create a new record, it opens a ComboBox for me.
I really don't know where to hit my head anymore.
A little help please.
Thank you!

Go to forum: General

77 Topic by reteinformatica

(18 replies, posted in General)

Hi everyone,
I was trying to make a program for managing a tech service lab.
I wrapped myself in saving the data of the form 'frmInterventi' in fact I must have made some mess with the tables and the relationships but I just can't find where.
Initially I had set the relationships differently but then I couldn't find the right field to assign to the ComboBoxes.
Thanks to all and greetings.

Go to forum: General

78 Reply by reteinformatica

(27 replies, posted in General)

Hi all, while browsing the forum I came across this thread. I really liked the sparrow project, it shows you the working hours in various ways and always gives you indications that you always have in sight.
But I'm also a bit of a pain in the ass and while studying the project I found a small problem: if the database is empty or there are no drivers, an error window pops up when the program is started (Exemption: List index out of bounce (- 1) Script position 76:2).
And it highlights line 76 in script.
What is the problem? I couldn't figure it out.

Go to forum: General

79 Reply by reteinformatica

(6 replies, posted in General)

Hi all,
Vladimir, when I see what you and others can do, I am amazed.

Go to forum: General

80 Reply by reteinformatica

(4 replies, posted in General)

Great Derek, thank you so much.

Go to forum: General

81 Reply by reteinformatica

(4 replies, posted in General)

Hi Derek,
in fact object and event are indispensable. Thanks derek for the usual correction and explanation. But if you want the record to be deselected by clicking on an empty point in the TableGrid as well as exiting an object with the pointer, what should you do? Thank you.

Go to forum: General

82 Topic by reteinformatica

(4 replies, posted in General)

Good morning everyone and thanks for your interest. Once a record is selected in a tablegrid, it remains permanently selected.
There would be a way that clicking anywhere in the program, either inside the tablegrid in an empty spot or anywhere empty on the form.
Thanks to all and a greeting.

Go to forum: General

83 Reply by reteinformatica

(6 replies, posted in General)

Another excellent solution from the usual sparrow

Go to forum: General

84 Reply by reteinformatica

(6 replies, posted in General)

Hi everyone,
I have seen all three projects, without taking anything away from desteny who gave a nice suggestion, I must always say that what derek manages to invent is always incredible.

Go to forum: General

85 Reply by reteinformatica

(7 replies, posted in General)

Hi everyone,
Thanks to Kostantin for code, I'll study it and try to apply it because it's very interesting even if I don't need it for now.

Go to forum: General

86 Reply by reteinformatica

(15 replies, posted in General)

Hi sparrow and derek,
I get what I have to do, I thought there was a more direct instruction.
A thousand thanks!

Go to forum: General

87 Reply by reteinformatica

(10 replies, posted in General)

Hi Derek,
I noticed this thing in your project: "Transaction types" records (Form3, Tablegrid2) can be deleted. However, doing so also eliminates all transactions from the accounts.

Go to forum: General

88 Reply by reteinformatica

(15 replies, posted in General)

Oh what nonsense!
Luckily I don't usually use swear words otherwise one would have been good here.
I had just written "Enable" instead of "Unable".
Attached I insert your project with some changes I made. Basically I made 'TableGrid1' of the form 'FormSetUp' editable and I removed the button to delete the record "Button2".
Now in the TableGrid with the right click you can find the command "Delete Record". The translated error message should appear here.
If you look at the attachment I tried with a completely broken code but I don't understand what are the right properties.
Look what I managed to combine on the attribution of "Sender".
Thanks Derek!

Go to forum: General

89 Reply by reteinformatica

(10 replies, posted in General)

Hi Derek and thanks for the reply and pointers.

Go to forum: General

90 Reply by reteinformatica

(7 replies, posted in General)

Hi v_pozidis and sparrow,
I find this discussion very interesting
I wonder how one could go about creating an automatic update.
Let's say someone updates a project and a table with related fields has been added to the new project:

INITIAL SITUATION

Table name = A
Table field name A = 1

CHANGES

Added table with name = B
Added field to table B with name = 2

Theoretically it could be:

1) in database 'name' create table 'B'

2) in table 'name' create the field '2', text, mandatory etc.

The only thing is that I really don't know how to develop it programmatically.

Go to forum: General

91 Reply by reteinformatica

(10 replies, posted in General)

Hi Jean and Derek.
derek, i looked at the project and it is as always very functional. If you don't mind, I have a couple of questions:

1) if in Form1 you click on the congobox but don't choose anything, it still shows you the operations of the first current account, the text in the combobox is not there but if you go to add an operation it asks you to choose a value from the combobox. What could be the solution to not show the operations carried out on the first account if I don't choose anything?

2) why did you decide to make the "transaction type" combobox inactive when choosing any transaction?

Thank you!

Go to forum: General

92 Reply by reteinformatica

(15 replies, posted in General)

Hi derek just what i wanted to know. A thousand thanks!
But I would immediately have a new translation question:
By right-clicking in a TableGrid and choosing an item from the menu that opens "Delete record", if you have not selected anything in the TableGrid, a new window opens (screen shot attached) "Enable to determine the record ID".
I tried with:

translate ('Enable_to_determinate_the_record_ID', 'Nessun record selezionato');

But it does not work. Is there any hope of translating for this window too?
Thank you!

Go to forum: General

93 Topic by reteinformatica

(15 replies, posted in General)

Hello everyone and thank you for your attention.
Is there a possibility to translate the error window (screen shot attached) that pops up when trying to delete a field that has links to fields in other tables?
Thanks to all and greetings

Go to forum: General

94 Reply by reteinformatica

(3 replies, posted in General)

But I wanted to ask that! big_smile

Go to forum: General

95 Reply by reteinformatica

(5 replies, posted in General)

Thank you derek for the elucidation. Don't worry that as you have seen if there are any problems I don't hesitate to ask, however, not before searching the forum and doing a "million" tests.. Let's just hope that, if I understand correctly by now MVD will no longer be developed, at least the forum will remain "alive".

Go to forum: General

96 Reply by reteinformatica

(10 replies, posted in General)

"As usual" you said well Jean. Derek number one.

Go to forum: General

97 Reply by reteinformatica

(5 replies, posted in General)

Hello sparrow and derek,
thanks for the link of which I am already reading several articles. Derek's project clarified how to do what I was asking. Thank you very much.

Go to forum: General

98 Topic by reteinformatica

(5 replies, posted in General)

Good morning, everyone, and thank you for your interest.
What would need to be written in a condition to determine that it is true if the place occupied by a letter is right?
Just to understand this, I give an example:
If in a word entered in an edibox, the third letter is C and the fourth is D then if the word in the written editbox is abcd then the condition is true.
Thank you all and regards.

Go to forum: General

99 Reply by reteinformatica

(5 replies, posted in General)

I did not understand. Would you like to update My Visualdatabase but are afraid that the projects already created won't work?

Go to forum: General

100 Reply by reteinformatica

(5 replies, posted in General)

I would like to bring you help but I really don't remember this project, yet in the last month I read them all.

Go to forum: General