MS Access 2000中的组合参数??? [英] Combo Parameters in MS Access 2000???

问题描述

我是MS Access 2000的新手，我设计了一个简单的数据库来记录每月旅行的人


我可以将整个人的报告作为向导报告。但是很难得到自己的个人报告编写VB编码..我想从组合框中选择个人，如果可能的话，日期之间的旅行也可以通过。



我们如何通过parimeter获取自己的个人报告？有没有人有想法写MACRO或VB编码来获得自己的？


我会非常感谢这个简单的答案。

Hi,

I am new to MS Access 2000, and i have designed one simple data base to keep record of people travelling every month

I can get the Report as a whole people as wizard report. but have tough time to get its own individidual report writing VB coding.. I want to select the individual from combo box and if possible date travel between can also be passed.


How do we pass the parimeter to get the own individual reports? Do any one have idea to write the MACRO or VB coding to get its own??

I would be very grateful for the simple answer.

推荐答案

有几种方法可以实现这一点，我会把你的方法作为首发，你可以从那里开始。

There are several ways to accomplish this, I''ll give you my approach as a starter, and you can take it from there.

1. 在表单上输入您的报告标准，并验证条目。将OpenArgs参数中的报告标准作为''，''分隔字符串：
   

1. Enter your Criteria for the Report on a Form, and validate the entries. Pass the Criteria for the Report in the OpenArgs Argument as a '','' Delimited String:
   

展开 | 选择 | Wrap | 行号

HI Adeezi，


感谢您的大力帮助，代码帮助我提供了一些信息并生成报告。但是我仍然无法解决它虽然它会给你带来麻烦但如果你能再次帮我解决这些问题我会很有帮助。


1.我做了所有的编码形式：但是当我生成报告所有报告都来了但不是个别报告......所以我确实在Private Sub Report_Open（Cancel As Integer）中编写了代码


作为你的mentiuon。但这一次这是错误。类型不匹配ID = varInfo（0）"



什么可能是问题。



我想向你解释我的表结构：


表1：tblEmployee：带有EmployeeID，名称等

表2：tblCourse：带课程ID，来自tblemployee的EMployee id，课程开始日期，结束日期课程等等。


我想要的是生成个人报告和人们在其间旅行的另一份报告任何日期。



感谢您的帮助，请

HI Adeezi,

Thanks for your great help, the code has helped me little in giving some information and to generate report. But still i couldnot solve it though it would be trouble for you i would be helpful if u can just help me once again with those questions.

1. I did with all the codings in forms: but when i genereate report all the reports comes but not individual reports......so i did wrote the code in "Private Sub Report_Open(Cancel As Integer)"

as mentiuon by you. But this time this is error it comes. Type mismatch in "ID = varInfo(0)""


WHat couldbe the problem.


I want to explain you my table structure:

Table1:tblEmployee: with EmployeeID,Name, etc
table 2: tblCourse: with Course ID, EMployee id from tblemployee, Course Startdate, End date course, etc etc.


What i want is to to generate the individual report and another report which the people are travelled between any dates.


thanks for your kind help please

HI Adeezi ，



1.我做了所有的编码形式：但是当我生成报告所有报告都来了但不是个别报告......所以我确实在Private Sub Report_Open（Cancel As Integer）中编写了代码


作为你的mentiuon。但这一次这是错误。类型不匹配ID = varInfo（0）"



什么可能是问题。



我想向你解释我的表结构：


表1：tblEmployee：带有EmployeeID，名称等

表2：tblCourse：带课程ID，来自tblemployee的EMployee id，课程开始日期，结束日期课程等等。


我想要的是生成个人报告和人们在其间旅行的另一份报告任何日期。



感谢您的帮助请

HI Adeezi,

Thanks for your great help, the code has helped me little in giving some information and to generate report. But still i couldnot solve it though it would be trouble for you i would be helpful if u can just help me once again with those questions.

1. I did with all the codings in forms: but when i genereate report all the reports comes but not individual reports......so i did wrote the code in "Private Sub Report_Open(Cancel As Integer)"

as mentiuon by you. But this time this is error it comes. Type mismatch in "ID = varInfo(0)""


WHat couldbe the problem.


I want to explain you my table structure:

Table1:tblEmployee: with EmployeeID,Name, etc
table 2: tblCourse: with Course ID, EMployee id from tblemployee, Course Startdate, End date course, etc etc.


What i want is to to generate the individual report and another report which the people are travelled between any dates.


thanks for your kind help please

让我们来一个问题时间。

Let''s take one problem at a time.

错误==>类型不匹配ID = varInfo（0）"

Error ==> Type mismatch in "ID = varInfo(0)""

变量ID引用String，Integer，Long等的EmployeeID是什么，即tblEmployee中[EmployeeID]的数据类型是什么？

Is the EmployeeID that the Variable ID is referencing a String, Integer, Long etc., namely, what is the Data Type of [EmployeeID] in tblEmployee?

我想要的是生成单个报告

What i want is to to generate the individual report

您希望Report1显示什么？按逻辑解释，然后列出报告中包含的所有字段。

这篇关于MS Access 2000中的组合参数???的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！