Search results

  1. P

    Getting an error using ValidationRule and ValidationText in a field

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

    Getting an error using ValidationRule and ValidationText in a field

    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?
  3. P

    Getting an error using ValidationRule and ValidationText in a field

    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.
  4. P

    Getting an error using ValidationRule and ValidationText in a field

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

    Getting an error using ValidationRule and ValidationText in a field

    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?
  6. P

    Using a subquery, just one column with csv result, as a set for using IN in the query

    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) ;
  7. P

    Using a subquery, just one column with csv result, as a set for using IN in the query

    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
  8. P

    Using a subquery, just one column with csv result, as a set for using IN in the query

    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...
  9. P

    Using a subquery, just one column with csv result, as a set for using IN in the query

    tx_clave is limited to 3 characters.
  10. P

    Using a subquery, just one column with csv result, as a set for using IN in the query

    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;
  11. P

    Using a subquery, just one column with csv result, as a set for using IN in the query

    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...
  12. P

    Using a subquery, just one column with csv result, as a set for using IN in the query

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

    Using a subquery, just one column with csv result, as a set for using IN in the query

    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...
  14. P

    Creating a constraint in a table in the backend

    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...
  15. P

    Creating a constraint in a table in the backend

    Hello! I have a backend with the tables and the frontand with queries, forms, reports and link table. Now I would like to add a constraint in a table in the backend using vba: DoCmd.RunSQL "ALTER TABLE diarios_det_2022 ADD CONSTRAINT RelacionCuenta FOREIGN KEY (cuenta) REFERENCES cuentas_2022...
  16. P

    Showing several accounting seats in a form

    Thanks, but I one a form because I want to include some buttons to manipulate the accounting seats showed.
  17. P

    Showing several accounting seats in a form

    This is like the purchase orden form where there are two table one is the header with the supplier information and the other is the items to buy. The two tables are related one to two or more. But In my case I want to show several accounting seats (like showing several purchase orders) in a form.
  18. P

    Showing several accounting seats in a form

    I showed the report just to represent what I want to do in a form. This is like the purchase orden form where there are two table one is the header with the supplier information and the other is the items to buy. The two tables are related one to two or more. But In my case I want to show...
  19. P

    Showing several accounting seats in a form

    Hola, amigos! I would like, a help, to show some accounting seats in a form. I already did it, but in a report using grouping and sorting, as shown in the following image: The thick lines separate the accounting seats (3 shown) and the thin lines separate the header from the details of the...
Top Bottom