Haz tu Pregunta

perfil de Pumper - actividad

2021-04-09 21:08:59 +0200 recibió una medalla  Pregunta Notable (fuente)
2021-04-07 04:17:35 +0200 recibió una medalla  Pregunta Notable (fuente)
2021-04-02 19:11:04 +0200 recibió una medalla  Pregunta Popular (fuente)
2021-04-01 22:28:22 +0200 comentar respuesta Macros in Subform

Thanks for your time in that, but I also use similar macro in main form and it works. Could you please try it in a sub f

2021-04-01 21:20:55 +0200 realizó una pregunta Macros in Subform

Macros in Subform I have this macro which clones a record in the subform grid. It does clone a record to table, but the

2020-12-27 20:46:53 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-12-06 02:28:14 +0200 realizó una pregunta Help with Base Copy Field or Clone Record

Help with Base Copy Field or Clone Record I need help with the macro in this DB example.Base Copy Field or Clone Record

2020-11-20 18:31:57 +0200 recibió una medalla  Pregunta Famosa (fuente)
2020-11-10 02:45:46 +0200 la mejor respuesta fue marcada Macro To Open Query

I am trying to write a macro to open a query while in a form. I tried this and got the message,BASIC runtime error.An exception occurred Type: com.sun.star.container.NoSuchElementException Debian10 LO 5.2.2.2 Could someone please help w/this. Thank You, Pumper

SUB QueryChange( sQueryName )
  Dim ObjTypeWhat
  Dim ObjName As String
  Dim sName as String
  Dim sTitle As String
  Dim iStart As Integer
  ObjName = sAVAILABLE1
  ObjTypeWhat = com.sun.star.sdb.application.DatabaseObject.QUERY
       ThisDataBaseDocument.CurrentController.Connect() 'If the query exists connect to the database'
     ThisDatabaseDocument.CurrentController.loadComponent(ObjTypeWhat, ObjName, FALSE) 'Open the query'      

End Sub
2020-11-10 02:45:46 +0200 recibió una medalla  Escolar (fuente)
2020-11-08 02:18:46 +0200 comentar respuesta Macro To Open Query

Ratslinger you were correct twice. The quotes around the query name was needed. 2nd There was no query, as sAVAILABLE1,

2020-11-08 02:08:17 +0200 recibió una medalla  Entusiasta
2020-11-07 23:44:29 +0200 comentar respuesta Macro To Open Query

I don't have the paper clip here!!!

2020-11-07 18:11:18 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-11-07 11:57:24 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-11-07 08:55:10 +0200 comentar respuesta Macro To Open Query

I had properties set to table, not query. Now parameter box comes up, but get message: BASIC runtime error. An exception

2020-11-07 08:24:03 +0200 comentar respuesta Macro To Open Query

Ratslinger, Thanks for quick answer..I tried that and got message> BASIC runtime error. An exception occurred Type:

2020-11-07 08:24:03 +0200 recibió una medalla  Comentador
2020-11-07 05:01:37 +0200 realizó una pregunta Macro To Open Query

Macro To Open Query I am trying to write a macro to open a query while in a form. I tried this and got the message,BASIC

2020-05-23 22:30:03 +0200 recibió una medalla  Pregunta Famosa (fuente)
2020-04-27 02:25:15 +0200 comentar respuesta Calculated fields on subform grid show different from Query

Ratslinger The calculations all work, but now I can't enter in the QTY. I had this problem also, would change something

2020-04-27 02:02:10 +0200 editar pregunta Calculated fields on subform grid show different from Query

Calculated fields on subform grid show different from Query I have a form with 1 subform. The subform has a grid with 2

2020-04-27 01:58:27 +0200 comentar respuesta Calculated fields on subform grid show different from Query

Ratslinger, that was great, I thought it would never work. I tried various combinations on the query grid, but not the r

2020-04-27 01:31:18 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-04-26 22:10:51 +0200 editar pregunta Calculated fields on subform grid show different from Query

Calculated fields on subform grid show different from Query I have a form with 1 subform. The subform has a grid with 2

2020-04-26 21:47:26 +0200 comentar pregunta Calculated fields on subform grid show different from Query

I will make a new embedded db file and upload.

2020-04-26 21:36:33 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-04-26 21:34:17 +0200 editar pregunta Calculated fields on subform grid show different from Query

Calculated fields on subform grid show different from Query I have a form with 1 subform. The subform has a grid with 2

2020-04-26 21:34:13 +0200 comentar pregunta Calculated fields on subform grid show different from Query

I can't seem to get the zip file small enough. The .odb 1,5 m and when I zip it, it is still 1.5m ??

2020-04-26 21:24:14 +0200 editar pregunta Calculated fields on subform grid show different from Query

Calculated fields on subform grid show different from Query I have a form with 1 subform. The subform has a grid with 2

2020-04-26 20:57:07 +0200 editar pregunta Calculated fields on subform grid show different from Query

Calculated fields on subform grid show different from Query I have a form with 1 subform. The subform has a grid with 2

2020-04-26 20:54:49 +0200 editar pregunta Calculated fields on subform grid show different from Query

Calculated fields on subform grid show different from Query I have a form with 1 subform. The subform has a grid with 2

2020-04-26 20:54:43 +0200 comentar pregunta Calculated fields on subform grid show different from Query

There is a reason, Sometimes the db doesn't work the same after an upgrade. I will try the extension Change

2020-04-26 20:49:02 +0200 comentar pregunta Calculated fields on subform grid show different from Query

I clicked on the paperclip, clicked on my zip file, it showed up and i clicked ok. But zip was not an accepted file. or

2020-04-26 20:45:21 +0200 editar pregunta Calculated fields on subform grid show different from Query

Calculated fields on subform grid show different from Query I have a form with 1 subform. The subform has a grid with 2

2020-04-26 20:43:15 +0200 editar pregunta Calculated fields on subform grid show different from Query

Calculated fields on subform grid show different from Query I have a form with 1 subform. The subform has a grid with 2

2020-04-26 20:43:11 +0200 comentar pregunta Calculated fields on subform grid show different from Query

The zip file is not on the list

2020-04-26 20:39:49 +0200 recibió una medalla  Editor (fuente)
2020-04-26 20:39:45 +0200 comentar pregunta Calculated fields on subform grid show different from Query

I seem to have trouble adding a zip file.

2020-04-26 20:33:52 +0200 recibió una medalla  Estudiante (fuente)
2020-04-26 20:31:45 +0200 realizó una pregunta Calculated fields on subform grid show different from Query

Calculated fields on subform grid show different from Query I have a form with 1 subform. The subform has a grid with 2

2020-04-10 23:04:34 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-04-10 04:38:11 +0200 editar pregunta How to work around unique constraint or index violation

How to work around unique constraint or index violation This comes up running a subform grid with a list box. It comes u

2020-04-10 04:31:22 +0200 recibió una medalla  Pregunta Popular (fuente)