Search results

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

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

and all the computers are running the same version.

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.

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.

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.

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

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

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

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

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

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

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

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

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=" &...

did you try ((([tbl_UnitList].[SectionCode]) =" & nbrSec & ") And (([tbl_UT].[APICode]) = "));'

tks allan57 for your replay, with your code i get the error the form name you entered dosen´t follow Microsoft Office Object-naming rules but help me find the solution for my problem. this code works Me("ConsultporBrig_subform" & i).Form.RecordSource = Strsql tks for your help

hi list, i´m trying concatenate a subform name without success. i have 6 suforms with names ConsultporBrig_subform1,ConsultporBrig_subform2,.... i have a loop recorset and the recorsource for this subforms depends on current recordset value. i already try some code(with some ideas found in this...

>How do i call that function from the immediates window so I can see if it gets >the correct value or not? What would I type in? you also can put a breakpoint in the line where you call the function and if you put your mouse in the variable CurrentID you see the value of this variable. you also...

Hi list, i´m having a problem with querydef and connections. i have a function with th path for my database and in the load form i call this function to create a connection 'this is the code Dim cnch3 As ADODB.Connection Set cnch3 = New ADODB.Connection cnch3.Mode = adModeReadWrite cnch3.Open...