Recent content by pacctono

Hello, guys! I solved it! I forgot to say that I could control the text file (It is created with BBX a business basic). This was my solution: Sub cargarComprobantes() Dim oFSO As Object Dim oFolder As Object, objFile As Object Dim strSql As String, txtFile As String Dim...

Hello, guys! I am reading a long text file (>140.000 lines) to get the values to be inserted in a table using VBA, but it takes too long (more than 40 minutes). This is my code: entFile = FreeFile() ' Returns an Integer representing the next file number available for use...

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.