Recent content by pacctono

Es Nulo O ((ALike "%_@_%._%") Y (NoEs ALike "%[ ,;]%")) Sorry, I do not know inenglish. Maybe, something like this: isNull Or ((Like "%_@_%._%") And (Not Like "%[ ,;]%"))

Ok, thanks! Can I check with vba that a Validation Rule (defined in the table design) is accomplished or I have to specify it in the vba code with a Before Update in the control?

I kown what it means. That text was put by me in the ValidationText field. I just would like to control it instead of getting an execution time error.

I use "On Error ...". The problem is that It give me an error number like -4233300098765

Hello, I have a field (email) with a ValidationRule and a ValidationText. I do not know if that is normal, but when the ValidationRule fails, Access give me an ERROR and try to open VBA. Can I control the ValidationRule with VBA to inform the user that the entered data is not valid?

Yes, Thanks!. I just have to add parentesis SELECT c.tx_clave, c.tx_descripcion FROM no_conceptos AS c INNER JOIN no_grupos AS g ON (g.tx_grupo = '05' AND InStr(g.tx_claves, c.tx_clave) > 0) ;

Friends, This is the solution for my question: SELECT c.tx_clave, c.tx_descripcion FROM no_conceptos AS c, no_grupos as g WHERE g.tx_grupo = '05' And instr(g.tx_claves, c.tx_clave) > 0; It gives what I was looking for

Thanks: SELECT c.tx_clave, c.tx_descripcion FROM no_conceptos AS c, no_grupos as g WHERE g.tx_grupo = '05' And instr(g.tx_claves, c.tx_clave) > 0; Trying with this, make me to create a more complicate query that I was really looking for: SELECT n.lo_cedula, p.tx_nombre, c.tx_grupo...

tx_clave is limited to 3 characters.

Horrible, too, but works: SELECT c.tx_clave, c.tx_descripcion FROM no_conceptos AS c WHERE instr(dlookup("tx_claves","no_grupos","tx_grupo = '05'"),c.tx_clave) >0;

If I execute this code: SELECT c.tx_clave, c.tx_descripcion, c.tx_grupo FROM no_conceptos AS c WHERE c.tx_clave In ('A01','A04','A07','A08','A10','A13','A16','A19','A22','A25','A84'); I get this: tx_clave tx_descripcion tx_grupo A01 SUELDO MENSUAL 00 A04 PRIMA COMPLEMENTARIA 01...

Well, the first query returns 11 rows, as expected. The second one returns none.

Hello, friends! I have a simple query, that works as expected: SELECT c.tx_clave, c.tx_descripcion FROM no_conceptos AS c WHERE c.tx_clave In ('A01','A04','A07','A08','A10','A13','A16','A19','A22','A25','A84') But I would like to substitute the set...

Is backend Access? yes Why don't you just open backend and modify Relationships? Can I do that in vba from the frontend? Is the foreign key field in diarios_det_2022 named cuenta? yes Why do you have table with a year in name - do you create a table for each year? bad practice If so, why? I...