Recent content by sub_nitrox

HI, Is it possible to save data in a table, just doing a check on the value of a combobox? I need to insert a Num_CC value that I got from a table called TB_ANAGRAIFCA, in the table called TB_ALLEGATI. But the value of Num_CC depends on the value selected in a combo box. So I have to save the...

Hi, Thanks I already solved the problem. Iput the code on the command save function before to assign the ID to the recordet. Thanks however for your great support and patience. Now I have to solve the last problem, that regards the refresh of value inserted in a ListBox and a CheckBox inside...

Hi, Thanks for your support. Also with your suggestion I have a problem and in partcular, after I receive on screen the pop up that advertise the missing field, the user is not able to enter the missing data, because an ID to the records is assigned. Therefore, the users have to close the form...

Sorry for my ignorance, but I tried just a statement and i got an error in compile on the "End Sub". I know that I have a funciotn, but I'm not able to stop the saving after the pop up come up saying please fill the NuMMAM etc.... Colud you give me a solution on this part of code? Thanks for...

Hi, I tried to put this code in the Before Update event of the form but maybe there is something of wrong or what else .... Here the code: Private Sub Form_BeforeUpdate(Cancel As Integer) If Trim(Me.cboNOME_PROVIDER & "") = "" Then MsgBox "Please enter a Nome Provider"...

Hi, do you mean the two saving funciotn named save_termin_info_curr and save_termin_info_store? If yes, is only to have an history of all actions performed to the data, infact the second funcion store all data in a different table named TB_STOR_ALLEGATI2 that I haven't attached as example. This...

Hi ejstefl, thanks for your support. It works perfectly!!!!! Wonderful. Have you also an idea on what code to put in the save function to check if some field have been filled in? I'd like to make a check of some fields in the form, to verify if they have a value, before to click the save...

Hi I'm waiting for some help on the issue posted before. In the mainwhile, I want say thanks to robrob for the suggestion on how perform a check befpre to save all dates in the form. I have n that only a doubt, and is about the part in red Private Function Checkform() Dim strErrorMessage As...

Hi, thank you for yuor support. Please find attached a part of the DB I realized. In the frm_TERMINAL_ADD, you'll find the TIPO CANALE Option group with different checkbox. If you try to compile the form and try to select a checkbox, you are not able to see the checkbox selected but the value is...

Hi, thanks for your feedback. I don't understand why I have tro create a textbox. I'm able to perform what I want like save the value in my fiedl table after I check the checkbox and so on. The only problem maybe is in the ase statement, where after I select the checkbox preferred, I cannot see...

Hello, ANY SUGGESTION? Thanks in advance, Antonio.

Sorry, but what do you mean? I don't have a text box. I only have an Option Group named TIPO_CANALE with inside 5 checkbox named SMS, MMS and so on .... I'm right now able to save the value that I select fomr the checkbox, but the problem is that on the screen I'm not able to see the checkbox...

Hi, i found right now the solution with a Case statement to transcode the number value (1,2 and 3) to text and I'm also able to save it in the table. THE ONLY BIG PROBLEM now is that i'm not abel to see the checkbox selected in the form and I don't know why? The code i putted in the After...

Who has idea of why with the solution proposed (referred to the Case Selection code), the checkbox are not visualized correctly in the form, in the sense that the user is not able to see the checkbox selected but the value is stored correctly in the table? Thanks for any suggestion. Cheers...

Hi, I need an help on my DB. I have a form with some comboboxes and checkboxes inside an option group, which is a value of a table. The table is named TB_ALLEGATI and the field inside this table is named TIPO_CANALE (this also the option group name). the checkbox inside the option group are...