在安装了相同版本访问权限的计算机之间更改的图形类型 [英] Graph types changing between computers with the same version of access installed
问题描述
如果这是一个愚蠢的问题，请提前抱歉，因为我不是全职的Access用户。
我开发了一个简单的数据库来处理内部客户的数据，但不幸的是，报告中的图表根据所使用的计算机而产生了更改类型。
图表是MS.Graph.Chart.8类的未绑定对象。
构建版本的Access完全相同，IT支持是声明配置文件是相同的。
任何人都可以建议原因可能是什么，如果有解决方法？即强制图表类型等。有趣的是，如果图形类型在有问题的计算机上手动更正，则不保存更改...
Sorry in advance if this is a silly question as I''m not a full time Access user.
I have developed a simple database to process data for an internal customer but unfortunately the graphs on the reports generated change types depending on the computer used.
The graphs are Unbound objects of the MS.Graph.Chart.8 class.
Build versions of Access are exactly the same and IT support is "claiming" the profiles are the same.
Can anyone suggest what the cause might be and if there is a work around? i.e. force the graph type etc. Interestingly, if the graph type is corrected manually on the computers which have the problem the change is not saved...
推荐答案
我不要我不知道这是否有效，但您是否尝试通过代码更改类型？喜欢报道的On Open事件？我不知道On Open是否会奏效。也许On Load或类似的东西。
I don''t know if this will work but have you tried changing the type through code? Like from the On Open event of the report? I don''t know if On Open will work though. Maybe On Load or something similar.
我试图将图表与脚本联系起来，但没有取得多大成功。
我在报告打开时使用了以下代码...但是得到错误2771您尝试编辑的绑定或未绑定对象框架不包含OLE对象
Private Sub Report_Open（取消为整数）
Dim GraphObj As Object
设置GraphObj = Me！[ OLEUnbound42] .Object.Application.Chart
GraphObj.Type = xlLine
End Sub
I''ve tried to tie the chart down with script but haven''t had much success.
I have used the following code on report open... but get a error 2771 "The bound or unbound object frame you tried to edit doesn''t contain an OLE object"
Private Sub Report_Open(Cancel As Integer)
Dim GraphObj As Object
Set GraphObj = Me![OLEUnbound42].Object.Application.Chart
GraphObj.Type = xlLine
End Sub
我试图将图表与脚本联系起来，但没有取得多大成功。
我在报告打开时使用了以下代码...但是得到错误2771您尝试编辑的绑定或未绑定对象框架不包含OLE对象
Private Sub Report_Open（取消为整数）
Dim GraphObj As Object
设置GraphObj = Me！[ OLEUnbound42] .Object.Application.Chart
GraphObj.Type = xlLine
结束子
I''ve tried to tie the chart down with script but haven''t had much success.
I have used the following code on report open... but get a error 2771 "The bound or unbound object frame you tried to edit doesn''t contain an OLE object"
Private Sub Report_Open(Cancel As Integer)
Dim GraphObj As Object
Set GraphObj = Me![OLEUnbound42].Object.Application.Chart
GraphObj.Type = xlLine
End Sub
是的，我害怕在公开赛上不会奏效。 On Open在加载控件之前发生。看看你是否能找到On On Open后发生的事件。像On Load或On Render。
Yeah, I was afraid On Open wouldn''t work. On Open occurs before controls are loaded. See if you can find an event that happens after On Open. Like On Load or On Render.
这篇关于在安装了相同版本访问权限的计算机之间更改的图形类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
