Search results

  1. P

    Solved 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?
  2. 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...
  3. 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...
  4. 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...
  5. P

    Trying to execute some commands after a calculate control is done

    Hello, friends! In the following image, there is a calculated field (3.303). It gives the number of records in the subform (=Count(*)). Depending on this value I want to enabled or disabled some buttons. I tied the "After Update" event on it, but it is never executed. Please, do any of you...
  6. P

    Manipulating an independent check box field in a form

    Hello! I have a form that its details is fill with fields from a query. I would like to have an independent check box field for each detail that I would like to change. I create the field in the form but when I change it on one record it chages all the records. I am thinkig to create a temporal...
  7. P

    Trying to order a report using VBA

    Buenos dias, amigos! I created a report that gets inputs from a form using OpenArgs. When the report opens (Report_Open), it manipulates a query saved in a string (txtSQL) replacing the where condition. <code> Const txtSQL As String = "SELECT a.lo_cedula, a.tx_nombre, a.tx_nucleo, a.tx_sexo...
  8. P

    Getting error: Could not update: Currently this element is locked using ado transaction in VBA

    Hello! First, I do not know if that is the error in english. I am getting "No se pudo actualizar actualmente este elemento está bloqueado". I am trying to do an ado transaction that contains several query, basically UPDATE's and INSERT's using a form (in the image, beside the error popup...
  9. P

    Creating a table in the backend Database with vba

    Hello, people! I have been looking into google and I have not found it. I have an access database file that I am using as backend with the main (or shared) tables and the local one as frontend. Now I would like to create a table, only the structura, in my backend database. I used...
  10. P

    Updating a column table in a form with a join query as a RecordSet

    Hello, I have a form that its a record set is a join query with four tables and I would like to update one column of the main table. The RecordSet query is: <code> SELECT t.au_control, t.fe_fecha, t.tx_operacion, t.tx_documento_contable, t.tx_referencia, t.tx_descripcion, t.mo_ingreso...
  11. P

    Database name of the database that contains the tables to which my tables are liked

    Hello, people! I have been looking into google and I have not found it. I have an access database file that I am using as backend with the main (or shared) tables and the local one as frontend. In my local database file, I link the local tables to the tables in the server. If I want to know...
  12. P

    Concatenates two numbers instead of adding them in a text box, using plus sign (+)

    Hello! I created a control text box that calculates the sum of two numeric columns that comes from a query. (the two numeric columns are in text box controls, too). Something like '=[monAhorroAporte]+[monAhorroPersonal]'. Instead I am getting the concatenation of the two numbers...
  13. P

    Working with Control tabs with subforms in each tab in Access

    I am trying to make a form using control tabs. I thought it was ideal for my requirements. I need a form that using the same query gives me 13 prints, one for each month (even month 0). I am using "on change" event. I change to any tab and gives me the same result, corresponding to the last...
  14. P

    Getting the description information from a table column

    I am tryng to print the table information: Table name And for each column ("x" represents the index of the column): Column name: CurrentDb.TableDefs(tableName).Fields(x).Name column type: CurrentDb.TableDefs(tableName).Fields(x).Type column length: CurrentDb.TableDefs(tableName).Fields(x).Size...
  15. P

    Using docmd.SetParameter to pass an string to a report/query

    Hello! I am a kind of a new access user. I have a report using a query. I have a form that call the report. I am passing parameters from the form to the query throught vba using docmd. setParameter. Like: DoCmd.SetParameter "cta", cta Everything goes well when cta has numbers inside. But give...
Top Bottom