Recent content by checoturco

  1. C

    onclick don't run macro

    it's solved, the problem was with the user. tks all for you help. Checoturco
  2. C

    onclick don't run macro

    Sorry for the delay, the problem is with the user. If we log in in the same machine with other user the application works well. i'm still trying solve the problem. tks all, Checoturco
  3. C

    onclick don't run macro

    and all the computers are running the same version.
  4. C

    onclick don't run macro

    thanks for you answers. boblarson wrote: >>Again, which version? Not Standard or Professional, but Access 2000, 2002, 2003, or 2007? And are all of the computers running the same version? The version is Access 2003. The problem was not solved with the Professional installation.
  5. C

    onclick don't run macro

    no, the problem is not in the code because in other computers works well. Maybe the version of access that is installed. I have the standard version and i will install the professional one. Then i'll report the result. Many thanks to all.
  6. C

    onclick don't run macro

    yes, i use the code above in the bottom to see where the code stops. Now, i'm looking to see what causes this error (the action "Open Report" was canceled..) and trying to understand why the code works in some computers and in others no.
  7. C

    onclick don't run macro

    the macro should open one report. if i put the code in the buttom: docmd.runMacro "MacroName" aldo nothing happens. if i change the code of this button to open directly the form, i receive the error: the action "Open Report" was canceled.. When a make the debug of the code. ...
  8. C

    onclick don't run macro

    Hello all, i have a form tha has a button which execute a macro in the onclick. in some computers this button works and in others no. we don't receive any error message. we simply press the button and nothing happens. i already set the macro security to low but the problem persists. this...
  9. C

    security level

    Good afternoon, I have a problem with the security level macros in Access. If i change the security level (tools - > macro - > security) and press ok, this new configuration is not saved if i open access again.Appears like the old configuration. If i do this procedure with the rights...
  10. C

    Build Excel Pivot table in Access (Columns)

    hi all, I find this code that i use but I´m having a problem with a sum of on field,this get the count of the fields, please can you tell me how i get the sum of a field. code that i find: ... .PivotFields(5).Orientation = xlDataField 'TOTAL EVENTS .PivotFields(6).Orientation = xlDataField...
  11. C

    Import data from Access to Excel?

    try this Dim FieldName As String Dim TDef As TableDef Dim DataTable As String Const ExcelFile = "C:/PivotFile.xls" DataTable = "tblData" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _ DataTable, ExcelFile, True Set TDef = CurrentDb.TableDefs(DataTable) checo
  12. C

    Passing Dates and Integers in vb

    look cdate on the vb help....here you can see some functions that can interest you. checo
  13. C

    Range in Excel from Access

    I don´t know if this helps you but i use this command to import data from excel DoCmd.TransferSpreadsheet acImport, 8, "tempsuc", txtCaminhosuc, True, "A:K" the range is "A:K" and this cod to export to excel Set MyExcelInstance = New Excel.Application Set Myworkbook =...
  14. C

    how to save Data value for each field entry on a bounded form

    did you try on AfterUpdate event of the control DoCmd.RunCommand acCmdSaveRecord
  15. C

    subforms don´t show the values

    hi all, i´m having a problem with a form that has 9 subforms and this subforms don´t show the values. i set the source for this subforms with this code when the form opens: StrsqlPen = "select bri,tot,totdes,totreu from " _ & "TotalBrigRen where flag=" &...
See more
Back
Top Bottom