Search results

I understand and thank you. I wrong the match key...now it works.

Because for each store I can only have one invoice at the end of the year, I archive the record (create a key to make it unique) and empty the fields of the invoice so that I can use it again the following year. Not the best solution, I know but I didn't know how to get the application to...

I cannot use the first option. The relationship is one to one. Can I share the DB?

The second option. The query match for IDs...and if I run the query It shows the result...the subform shows only After an update and click on F5

Hello, I have the following form. My issue is the following: when opening the form, the fields of the subform do not show their value even though they are filled in. If I enter any value in any field and press F5 it then shows everything. why?

I Will try...and thank you as usual

The form F_RICERCA open the form F_PUNTO_VENDITA for the selected record on the F_RICERCA. The ID_PV are Always set, i don't understand why It doesn't work

At open only the code for the side of screen. On current me.allowedit false

Sorry @MajP. I have a problem on the DB, before it worked. I need to select a specific record on F_RICERCA and then click on the icon open a form F_PUNTO VENDITA where I can see all the information of the Punto Vendita. It doesn't work, it open always the same record even if I select another...

It doesn't work. I solved set the property of the form to NO (allow addition, allow edit, allow delete). Removed the code on the current event.

" i wrong the tag

??? I Always indenting my code, the tags align all to left (see screenshot) I only asked if the issue was related to the requery.

So the issue Is the requery? Can i refresh the caption without requery?

Hello. I have a problem with the edit in a form. My issue is related the allowedit. It seems that the allowedit=false on the current event don't change. I tried to remove it and the code in CmdIstanza_Click works well (change caption etc). Could you please help me? Thank you

on change. Thank you Other suggestions about the layout?

Hello I would like to ask some suggestions about my DB. In the Clienti when I click on the unbound search it shows me an error. I don't understand why. I set the same VBA code of the others form. For your information, in the home page form, 3 buttons (Recuperatori, Report and Storico) are in...

Nothing, it doesn't work. I've created a new record. Ok, I find the error: the field is related to the table T_ISTANZA. T_ISTANZA is a T_PUNTO_VENDITA's table, so the field will be populated when I create the Istanza. How can I manage this field in T_PUNTO_VENDITA? Ho

This is the code on current event of the subform. This code works if I edit some information in the form, but when I open the form for the first time the field is empty till I edit some information. Here the code on click

In the table the value is N, only in the forms it blank. If I put any values on the form, the field shows N (see screen): I put Modulo, and the field is equal to N and the label is Create Istanza. I don't understand the reason.

Dear my situation: Main form F_RICERCA Sub Form F_ELENCO Button Istanza on the right If I click on the button it opens the correct form, linked to my client, it seems all is ok but I have an issue with this field: I set as default value on the table T_ISTANZA the value "N" for...