Search results

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

Thanks, it worked! Looks like DoCmd.SetParameter works only with string, using your suggestion or number.

Thanks, your code help me to soled the problem: Function descripcionColumna(campo As Field) As String On Error GoTo noExisteDescripcion descripcionColumna = campo.Properties("Description") salir_descripcionColumna: Exit Function noExisteDescripcion: descripcionColumna...

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

I know is a wildcard in the query. The problem is inside the vba: Private Sub Aceptar_Click() Dim cta As String, informe As String Dim fecini As Long, fecfin As Long cta = Replace(Me.cta.Value, "-", "") fecini = DateDiff("d", #1/1/1900#, Me.fecini.Value) + 2 fecfin =...

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