Search results

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

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

I solved it using (form).Recordset.RecordCount or in my case me.Recordset.RecordCount

Because I just want to know if the value is 0 or not. I did This: <code> Static hecho As Boolean If Not hecho Then Debug.Print SinError(Me.entContarRegistros, 0) Else hecho = True End If </code> It prints nothing. NOTE: <entContarRegistros> is the calculated...

I tried form after update event, putting some "debug.print", but it is not executed.

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

Wow! That is a lot of suggestions. Thanks you boys. I am going to try some. But I did not say the resordsource of the for is not a table is a aggregate query: SELECT n.CONCEPTO, co.tx_descripcion, Sum(n.VALOR_FIJO) AS monFijo, Sum(n.VALOR_VARIABLE) AS monVariable...

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

Wow! I Will have to have one report for each sort.

They did not work.

But can I these properties: Me.OrderBy = txtOrdenar & ", tx_parentesco" Me.OrderByOn = True Me.OrderByOnLoad = True

Do you mean the report field, like this: tx_nombre, lo_cedula, tx_parentesco it does not work.

Sure! Can be: a.tx_nucleo, a.tx_nombre, a.lo_cedula, c.tx_parentesco a.tx_nucleo, a.lo_cedula, c.tx_parentesco a.lo_cedula, c.tx_parentesco a.tx_nombre, a.lo_cedula, c.tx_parentesco

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

It helped. Thanks! Muchas gracias.

I solved my problem. I went aroud it. If somebody else have another solution I will appreciate it. My first command was an UPDATE, that was using the table that is the source of the form. name it "local". I am updating a different table (name it "pendiente") but I think access does not like...

I got your point and I am agree. I live in Venezuela and sometime is difficult for people out of our country to understand our economy. In three years we have changed our coin two times. If I had trillon bolivares in july, 2.018; now I have 10 bolvares. Our zeros to the right does not have any...

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

Sorry, it took so long to answer you. You wrote> "If you'd care to share the reason for the request, we can probably offer a different solution that will work better in business application for the user community." I am making an accounting system. Every year ( just one time on a year). I...

I found my answer: SELECT * INTO <TABLENAME> IN '<RUTA DE LA BASE DE DATOS BACKEND>' FROM <TABLENAME> WHERE 1=0; I still, do not know why for each table created (and deleted the data) using <Access.Application.DoCmd.CopyObject>, windows 10 opens an access section.