Subreport links as query parameters?

[k-chan]

Is it possible to use the linked fields for a subreport as the
subreport's query parameter?

 

[Duane Hookom]

IMHO parameter queries are not appropriate user interface
http://www.tek-tips.com/faqs.cfm?fid=6763.

However, you should be able to enter the exact parameter into the link
master property like [Enter Employee ID]. If this doesn't work, try add a
text box to the same report section:
Name: txtEmpID
Control Source:=[Enter Employee ID]
Then set the Link Master to [txtEmpID]

Link master/child does not work with ranges.

 

[k-chan]

Sorry for not mentioning this before, but since the main report is a
list of all employees, and the subreport contains information about
where else the employee works, I don't think having the prompt asking
for each individual employee ID would be appropriate.

I tried get setting the subreport's input parameters as [Report]!
[rptMainReport]![EmployeeID], and it did display the right data, but
only for the first employee. All subsequent employees show the same
subreport containing the work information of the first employee.

I can't directly link the two reports with the Employee ID field as
well, since one employee could have multiple IDs, one for each place
they work. I have the query set up so that the it gets the name of the
employee from the ID passed in, and then searches for all records with
that name, and that's to be displayed in the subreport.

Does anyone know why the subreport just displays the work information
of the first employee?


Thanks in advance

IMHO parameter queries are not appropriate user interfacehttp://www.tek-tips.com/faqs.cfm?fid=6763.

However, you should be able to enter the exact parameter into the link
master property like [Enter Employee ID]. If this doesn't work, try add a
text box to the same report section:
Name: txtEmpID
Control Source:=[Enter Employee ID]
Then set the Link Master to [txtEmpID]

Link master/child does not work with ranges.
--
Duane Hookom
Microsoft Access MVP

Is it possible to use the linked fields for a subreport as the
subreport's query parameter?

 

[Duane Hookom]

I now remember reading your earlier post which confused me about as much as I
am at the moment. I don't understand your table structure(s), how you are
storing your data, why an employee could have multiple IDs, etc.

--
Duane Hookom
Microsoft Access MVP

Sorry for not mentioning this before, but since the main report is a
list of all employees, and the subreport contains information about
where else the employee works, I don't think having the prompt asking
for each individual employee ID would be appropriate.

I tried get setting the subreport's input parameters as [Report]!
[rptMainReport]![EmployeeID], and it did display the right data, but
only for the first employee. All subsequent employees show the same
subreport containing the work information of the first employee.

I can't directly link the two reports with the Employee ID field as
well, since one employee could have multiple IDs, one for each place
they work. I have the query set up so that the it gets the name of the
employee from the ID passed in, and then searches for all records with
that name, and that's to be displayed in the subreport.

Does anyone know why the subreport just displays the work information
of the first employee?


Thanks in advance

IMHO parameter queries are not appropriate user interfacehttp://www.tek-tips.com/faqs.cfm?fid=6763.

However, you should be able to enter the exact parameter into the link
master property like [Enter Employee ID]. If this doesn't work, try add a
text box to the same report section:
Name: txtEmpID
Control Source:=[Enter Employee ID]
Then set the Link Master to [txtEmpID]

Link master/child does not work with ranges.
--
Duane Hookom
Microsoft Access MVP

Is it possible to use the linked fields for a subreport as the
subreport's query parameter?

 

[k-chan]

The reason why an employee would have mulitiple ID at this moment, is
because that ID is just an index of when it was added to the table. So
calling it an Employee ID would be misleading, it's more like a RowID.
Does that make more sense? Also, currently there isn't an Employee ID,
since we're having problems identifying an individual person, but
that's something entirely, and would be sorted out later.

Also, I'm working with two set of tables. One set is called the
WebTables and it deals with all the information processed from a
website we have, while the second set is the BaseTables, where it
contains everything. After proper review of the changes requested
online, the data that has been changed would be copied from the
WebTables to the BaseTables.

The report I'm setting up right now is to show the changes made
online, and that includes changes to employees (as in whether they
changed from working full time/part time, hours they work, etc) with
respect to a specific work location. However, the information of the
subreport comes from the BaseTables (since the other locations that
the employee work at may not have changes made online). So thus, I
can't link the two reports with the ID.

I hope this helps clear the confusion, as I need help with the
reports.

Thanks.

I now remember reading your earlier post which confused me about as much as I
am at the moment. I don't understand your table structure(s), how you are
storing your data, why an employee could have multiple IDs, etc.

--
Duane Hookom
Microsoft Access MVP

Sorry for not mentioning this before, but since the main report is a
list of all employees, and the subreport contains information about
where else the employee works, I don't think having the prompt asking
for each individual employee ID would be appropriate.

I tried get setting the subreport's input parameters as [Report]!
[rptMainReport]![EmployeeID], and it did display the right data, but
only for the first employee. All subsequent employees show the same
subreport containing the work information of the first employee.

I can't directly link the two reports with the Employee ID field as
well, since one employee could have multiple IDs, one for each place
they work. I have the query set up so that the it gets the name of the
employee from the ID passed in, and then searches for all records with
that name, and that's to be displayed in the subreport.

Does anyone know why the subreport just displays the work information
of the first employee?

Thanks in advance

IMHO parameter queries are not appropriate user interfacehttp://www.tek-tips.com/faqs.cfm?fid=6763.
However, you should be able to enter the exact parameter into the link
master property like [Enter Employee ID]. If this doesn't work, try add a
text box to the same report section:
Name: txtEmpID
Control Source:=[Enter Employee ID]
Then set the Link Master to [txtEmpID]
Link master/child does not work with ranges.
--
Duane Hookom
Microsoft Access MVP
:
Is it possible to use the linked fields for a subreport as the
subreport's query parameter?

It's because there are cur

 

[Duane Hookom]

What fields/values do you want to use to limit the display of records in the
subreport?

--
Duane Hookom
Microsoft Access MVP

The reason why an employee would have mulitiple ID at this moment, is
because that ID is just an index of when it was added to the table. So
calling it an Employee ID would be misleading, it's more like a RowID.
Does that make more sense? Also, currently there isn't an Employee ID,
since we're having problems identifying an individual person, but
that's something entirely, and would be sorted out later.

Also, I'm working with two set of tables. One set is called the
WebTables and it deals with all the information processed from a
website we have, while the second set is the BaseTables, where it
contains everything. After proper review of the changes requested
online, the data that has been changed would be copied from the
WebTables to the BaseTables.

The report I'm setting up right now is to show the changes made
online, and that includes changes to employees (as in whether they
changed from working full time/part time, hours they work, etc) with
respect to a specific work location. However, the information of the
subreport comes from the BaseTables (since the other locations that
the employee work at may not have changes made online). So thus, I
can't link the two reports with the ID.

I hope this helps clear the confusion, as I need help with the
reports.

Thanks.

I now remember reading your earlier post which confused me about as much as I
am at the moment. I don't understand your table structure(s), how you are
storing your data, why an employee could have multiple IDs, etc.

--
Duane Hookom
Microsoft Access MVP

Sorry for not mentioning this before, but since the main report is a
list of all employees, and the subreport contains information about
where else the employee works, I don't think having the prompt asking
for each individual employee ID would be appropriate.

I tried get setting the subreport's input parameters as [Report]!
[rptMainReport]![EmployeeID], and it did display the right data, but
only for the first employee. All subsequent employees show the same
subreport containing the work information of the first employee.

I can't directly link the two reports with the Employee ID field as
well, since one employee could have multiple IDs, one for each place
they work. I have the query set up so that the it gets the name of the
employee from the ID passed in, and then searches for all records with
that name, and that's to be displayed in the subreport.

Does anyone know why the subreport just displays the work information
of the first employee?

Thanks in advance

On Feb 25, 11:45 am, Duane Hookom <duanehookom@NO_SPAMhotmail.com>
wrote:
IMHO parameter queries are not appropriate user interfacehttp://www.tek-tips.com/faqs.cfm?fid=6763.

However, you should be able to enter the exact parameter into the link
master property like [Enter Employee ID]. If this doesn't work, try add a
text box to the same report section:
Name: txtEmpID
Control Source:=[Enter Employee ID]
Then set the Link Master to [txtEmpID]

Link master/child does not work with ranges.

:
Is it possible to use the linked fields for a subreport as the
subreport's query parameter?

It's because there are cur

 

[k-chan]

I don't think I need to limit the display of the records in the
subreport, since all that's taken care in the query.
Does that mean I don't need to fill in the linked fields?

What fields/values do you want to use to limit the display of records in the
subreport?

--
Duane Hookom
Microsoft Access MVP

The reason why an employee would have mulitiple ID at this moment, is
because that ID is just an index of when it was added to the table. So
calling it an Employee ID would be misleading, it's more like a RowID.
Does that make more sense? Also, currently there isn't an Employee ID,
since we're having problems identifying an individual person, but
that's something entirely, and would be sorted out later.

Also, I'm working with two set of tables. One set is called the
WebTables and it deals with all the information processed from a
website we have, while the second set is the BaseTables, where it
contains everything. After proper review of the changes requested
online, the data that has been changed would be copied from the
WebTables to the BaseTables.

The report I'm setting up right now is to show the changes made
online, and that includes changes to employees (as in whether they
changed from working full time/part time, hours they work, etc) with
respect to a specific work location. However, the information of the
subreport comes from the BaseTables (since the other locations that
the employee work at may not have changes made online). So thus, I
can't link the two reports with the ID.

I hope this helps clear the confusion, as I need help with the
reports.

Thanks.

I now remember reading your earlier post which confused me about as much as I
am at the moment. I don't understand your table structure(s), how you are
storing your data, why an employee could have multiple IDs, etc.
--
Duane Hookom
Microsoft Access MVP
:
Sorry for not mentioning this before, but since the main report is a
list of all employees, and the subreport contains information about
where else the employee works, I don't think having the prompt asking
for each individual employee ID would be appropriate.
I tried get setting the subreport's input parameters as [Report]!
[rptMainReport]![EmployeeID], and it did display the right data, but
only for the first employee. All subsequent employees show the same
subreport containing the work information of the first employee.
I can't directly link the two reports with the Employee ID field as
well, since one employee could have multiple IDs, one for each place
they work. I have the query set up so that the it gets the name of the
employee from the ID passed in, and then searches for all records with
that name, and that's to be displayed in the subreport.
Does anyone know why the subreport just displays the work information
of the first employee?
Thanks in advance
On Feb 25, 11:45 am, Duane Hookom <duanehookom@NO_SPAMhotmail.com>
wrote:
IMHO parameter queries are not appropriate user interfacehttp://www.tek-tips.com/faqs.cfm?fid=6763.
However, you should be able to enter the exact parameter into the link
master property like [Enter Employee ID]. If this doesn't work, try add a
text box to the same report section:
Name: txtEmpID
Control Source:=[Enter Employee ID]
Then set the Link Master to [txtEmpID]
Link master/child does not work with ranges.
--
Duane Hookom
Microsoft Access MVP
:
Is it possible to use the linked fields for a subreport as the
subreport's query parameter?

It's because there are cur

 

[k-chan]

I'm actually just wondering if I could use the linked fields to pass
in the parameters for the subreport. It seems like referencing the
control on the main report doesn't seem to be working that well, since
all the subreports, no matter for which employee, it is displaying all
work locations which the first employee works at.

I don't think I need to limit the display of the records in the
subreport, since all that's taken care in the query.
Does that mean I don't need to fill in the linked fields?

What fields/values do you want to use to limit the display of records in the
subreport?

The reason why an employee would have mulitiple ID at this moment, is
because that ID is just an index of when it was added to the table. So
calling it an Employee ID would be misleading, it's more like a RowID.
Does that make more sense? Also, currently there isn't an Employee ID,
since we're having problems identifying an individual person, but
that's something entirely, and would be sorted out later.
Also, I'm working with two set of tables. One set is called the
WebTables and it deals with all the information processed from a
website we have, while the second set is the BaseTables, where it
contains everything. After proper review of the changes requested
online, the data that has been changed would be copied from the
WebTables to the BaseTables.
The report I'm setting up right now is to show the changes made
online, and that includes changes to employees (as in whether they
changed from working full time/part time, hours they work, etc) with
respect to a specific work location. However, the information of the
subreport comes from the BaseTables (since the other locations that
the employee work at may not have changes made online). So thus, I
can't link the two reports with the ID.
I hope this helps clear the confusion, as I need help with the
reports.
Thanks.
On Feb 25, 2:45 pm, Duane Hookom <duanehookom@NO_SPAMhotmail.com>
wrote:
I now remember reading your earlier post which confused me about as much as I
am at the moment. I don't understand your table structure(s), how you are
storing your data, why an employee could have multiple IDs, etc.
--
Duane Hookom
Microsoft Access MVP
:
Sorry for not mentioning this before, but since the main report is a
list of all employees, and the subreport contains information about
where else the employee works, I don't think having the prompt asking
for each individual employee ID would be appropriate.
I tried get setting the subreport's input parameters as [Report]!
[rptMainReport]![EmployeeID], and it did display the right data, but
only for the first employee. All subsequent employees show the same
subreport containing the work information of the first employee.
I can't directly link the two reports with the Employee ID field as
well, since one employee could have multiple IDs, one for each place
they work. I have the query set up so that the it gets the name of the
employee from the ID passed in, and then searches for all records with
that name, and that's to be displayed in the subreport.
Does anyone know why the subreport just displays the work information
of the first employee?
Thanks in advance
On Feb 25, 11:45 am, Duane Hookom <duanehookom@NO_SPAMhotmail.com>
wrote:
IMHO parameter queries are not appropriate user interfacehttp://www.tek-tips.com/faqs.cfm?fid=6763.
However, you should be able to enter the exact parameter into the link
master property like [Enter Employee ID]. If this doesn't work, try add a
text box to the same report section:
Name: txtEmpID
Control Source:=[Enter Employee ID]
Then set the Link Master to [txtEmpID]
Link master/child does not work with ranges.
--
Duane Hookom
Microsoft Access MVP
:
Is it possible to use the linked fields for a subreport as the
subreport's query parameter?
It's because there are cur

 

[Duane Hookom]

I generally try to only use the Link Master/Child rather than attempting to
set criteria in the subreport's record source.

--
Duane Hookom
Microsoft Access MVP

I'm actually just wondering if I could use the linked fields to pass
in the parameters for the subreport. It seems like referencing the
control on the main report doesn't seem to be working that well, since
all the subreports, no matter for which employee, it is displaying all
work locations which the first employee works at.

I don't think I need to limit the display of the records in the
subreport, since all that's taken care in the query.
Does that mean I don't need to fill in the linked fields?

What fields/values do you want to use to limit the display of records in the
subreport?

:
The reason why an employee would have mulitiple ID at this moment, is
because that ID is just an index of when it was added to the table. So
calling it an Employee ID would be misleading, it's more like a RowID.
Does that make more sense? Also, currently there isn't an Employee ID,
since we're having problems identifying an individual person, but
that's something entirely, and would be sorted out later.

Also, I'm working with two set of tables. One set is called the
WebTables and it deals with all the information processed from a
website we have, while the second set is the BaseTables, where it
contains everything. After proper review of the changes requested
online, the data that has been changed would be copied from the
WebTables to the BaseTables.

The report I'm setting up right now is to show the changes made
online, and that includes changes to employees (as in whether they
changed from working full time/part time, hours they work, etc) with
respect to a specific work location. However, the information of the
subreport comes from the BaseTables (since the other locations that
the employee work at may not have changes made online). So thus, I
can't link the two reports with the ID.

I hope this helps clear the confusion, as I need help with the
reports.

On Feb 25, 2:45 pm, Duane Hookom <duanehookom@NO_SPAMhotmail.com>
wrote:
I now remember reading your earlier post which confused me about as much as I
am at the moment. I don't understand your table structure(s), how you are
storing your data, why an employee could have multiple IDs, etc.

:
Sorry for not mentioning this before, but since the main report is a
list of all employees, and the subreport contains information about
where else the employee works, I don't think having the prompt asking
for each individual employee ID would be appropriate.

I tried get setting the subreport's input parameters as [Report]!
[rptMainReport]![EmployeeID], and it did display the right data, but
only for the first employee. All subsequent employees show the same
subreport containing the work information of the first employee.

I can't directly link the two reports with the Employee ID field as
well, since one employee could have multiple IDs, one for each place
they work. I have the query set up so that the it gets the name of the
employee from the ID passed in, and then searches for all records with
that name, and that's to be displayed in the subreport.

Does anyone know why the subreport just displays the work information
of the first employee?

Thanks in advance

On Feb 25, 11:45 am, Duane Hookom <duanehookom@NO_SPAMhotmail.com>
wrote:
IMHO parameter queries are not appropriate user interfacehttp://www.tek-tips.com/faqs.cfm?fid=6763.

However, you should be able to enter the exact parameter into the link
master property like [Enter Employee ID]. If this doesn't work, try add a
text box to the same report section:
Name: txtEmpID
Control Source:=[Enter Employee ID]
Then set the Link Master to [txtEmpID]

Link master/child does not work with ranges.

:
Is it possible to use the linked fields for a subreport as the
subreport's query parameter?

It's because there are cur