Recent content by Saviolin

Thank you!

Thanks Pat by all your advices, I'll keep it in mind in future proyects, i could solve my problem changing the way I made the Form Thank you so much for everything

Hi All! After reading all your questions, you all make me think again in what I was doing, so I decided to change the Form and Subform way by just a Form, I put the textbox, Label and command button on the header of the Form, I use the same VBA code with the suggested line by DBguy, and...

Hi Cronk! Prod is a Text Box´s name in the Form and its control origin is this: =[Form]![Prueba3Form]![SubForm Busqueda Mail x Cod Productor Piloto].[Form]![Productor] Thanks

Hi, I try, and now the error changes to "Runtime 2447 There is an invalid use of the .(dot) or ! operator or invalid parentheses"

Hi CJ_London! I try to open the subform, and when I type a number not included in the Table, the subform opens, but without any data on it. I suppose the null value makes this Thanks!

Hi DBguy! The InputBox comes from an Access Query and this is the SQL code: SELECT Productores_mails.Codigo AS [Código Productor], Productores_mails.[Apellido y Nombre] AS Productor, Productores_mails.Mail AS [E-Mail], IIf([Deudores]="S","Si","No") AS [Envía Deudores por Premio]...

Hello Everybody! I'm am getting this error "Runtime 2427 You entered an expression that has no value." I've tried others solutions, that it brought other errors (2447 / 424 / 13) It is a Form with an Input Box, you type a value number and then it check this in a Query. If the "value...

My name is Miguel, i'm 53, live in Buenos Aires, Argentina, fan of River Plate, I´m too an Access and VBA beginner user. I'm sure you will help me when I need it, and maybe in the future I can help someone too. Thank you for reading. Bye!