社区服务 统计排行 帮助
  • 124阅读
  • 0回复

Office Professional Plus 2010 X86 How to make TempVars work with OpenRecordset

级别: 侠客
Maarten a blogging site reader asks: with Entry 2007) are excellent,Cheap Office Professional Plus 2007! But I've some issues in working with them. a question that has a TempVar as standards. When I run the query it displays the proper information. But when I open the query in VBA working with OpenRecordset,Windows 7 Sale, I obtain the message: “Run-time error 3061: As well handful of parameters. Anticipated 1.” the anticipated conduct. TempVars are defined in the scope with the Access Software object. While you make use of the CurrentDB.OpenRecordset process,Office Professional Plus 2010 X86, the resulting recordset is defined in the scope for the ACE database engine (DAO).  a workaround. Set up and kind based on the query and assign your recordset to it. A thing like this… "FormName",Office Professional Plus 2010 X86, WindowMode:=acHidden
Set rs = Forms("FormName").Recordset stuff acForm,Buy Windows 7 Home Basic, "FormName"
关键词: Office Professi
描述
快速回复

您目前还是游客,请 登录注册
如果您提交过一次失败了,可以用”恢复数据”来恢复帖子内容