Search options (Page 2 of 14)

Now if you also tell me how to save the 0s in front of a number in an integer (I tried real too) field because I tried everything but I couldn't. If I write 00123 he saves 123.
I am very grateful to you.

Ciao Domenico, grazie per la risposta. Questa cosa di più pulsanti di salvataggio nello stgesso form non l'avevo proprio immaginata. Cercavo di farlo più minimale possibile ma dovrò per forza aggiungere qualche form. Mi sembrava una buona idea quella di avere tutti gli inserimenti in una sola finestra ma dovrò adattarmi.
Già che ci sono vorrei chiedere un'altra cosa: siccome nella tabella 'Azienda' ci andrà solo un unico record sono i dati relativi alla propria azienda, quale potrebbe essere il miglior modo per, diciamo, "bloccare" la tabella ad un unico record? Cioè una volta inseriti i dati dell'azienda si possa solo modificare i dati e non che venga creato un altro record.
----------------------------------------------------------------------------------------------------------------
Hi Derek,
I hadn't thought that even though I put a TableSheet things are not divided but the form remains the same. It seemed like a good idea to have all entries in one window but I'll have to adapt. Thanks for the explanations and the possible alternative.
While I'm at it, I'd like to ask something else: since only a single record will go in the 'Company' table, it's the data relating to your company, what could be the best way to, let's say, "lock" the table to a single record ? That is, once the company data has been entered, it is only possible to modify the data and not create another record.

The way is to install MySQL on the same computer or on another one that acts as a server, choosing MyVisual Database MySQL instead of SQL Lite, as you showed in the image and as you did in your project.
The only thing I didn't understand is if you need to know how to configure MyVisual Database or if you need help with MySQL. Xamp already has everything you need.

Hi derek and sparrow,
thanks for the explanations and the always very interesting methods.

Hi Derek,
I have seen your project, beautiful as always.
I'd like to let you know what I've discovered and maybe if you make corrections, explain to me what was wrong.
In the delete buttons you have chosen not to ask for confirmation to delete the record. Instead, I set each delete button to ask for confirmation.
Here is how the program behaves at this point:

1) if you create a task in the first tablegrid, select the record and then exit the tablegrid with the mouse, the record moves to the second tablegrid. If you then select the record, passed into the second tablegrid and exit the second tablegrid with the mouse, the record returns to the first.

2) if you create a record in the second tablegrid it is saved in the fourth. Not always but most of the time.

3) if you delete a record from any of the first 3 tablegrids and when asked to confirm the deletion you say no, the record moves to the fourth tablegrid

Hi sparrow, of course everything is ok, in the end the result is achieved, but I will always have the doubt as to why pieces of code work in certain situations and not in others.
Also the photo control in DB, in another project I translated it without problems and in this one it does as it wants.
Thanks anyway because you always help me too.

In this case, if I put the code between "Begin" and "End." it gives me the same error you get when starting up. Then the program starts anyway and the some tablegrid not all are translated but at every start it opens that error window. Up to the "Caselle di posta" tab are translated, the following ones are not.
I checked and double checked and the identifiers should be right, then with all this code I might as well have gotten lost and wrong.

Thanks derek, the menu that appears on hover is very very beautiful!
Can you also give me an explanation why I can't translate the tablegrid and the image in db?

Hi derek,
thanks for the clarifications and also for, let's call them, tricks like hiding all the controls by simply placing them in a panel.
Hi sparrows,
Windows is in Italian. I'm getting a little confused trying to figure out what's going on. For example, in the project I am attaching, I created a file to translate messages in tablegrids in the same way and, as you can see, without using £procedure" yet the translation works.

Hi sparrow,
thank you very much for describing the structure to me. I edited the file successfully. Really thank you very much.