Report Troubles

[AJ]

I have a report that is set up to immediately open a form from which you
select your query from a drop list. Then on the form is a command button
that you click to run the query.

When I open the report the form opens just as I want it. I can chose from
the combo box then I click the command button and the query runs. The query
shows up in datasheet view. I don't want this. Immediatly upon the query in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet view, how
to keep the dialog box from opening and how to get the info from the query in
the report. (the report is set up to pull from that query).

thanks for any help you can give.

 

[PC Datasheet]

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

 

[AJ]

This helped alot thanks. Just one problem at this point. The Report is
opening the dialog box. I select the name I want and it just sits there. If
I hit enter then I get an error. I double checked, I do have in teh after
update event just as you said Me.Visible = False.

thanks so much for your help.

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

I have a report that is set up to immediately open a form from which you
select your query from a drop list. Then on the form is a command button
that you click to run the query.

When I open the report the form opens just as I want it. I can chose from
the combo box then I click the command button and the query runs. The query
shows up in datasheet view. I don't want this. Immediatly upon the query in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet view, how
to keep the dialog box from opening and how to get the info from the query in
the report. (the report is set up to pull from that query).

thanks for any help you can give.

 

[PC Datasheet]

You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

This helped alot thanks. Just one problem at this point. The Report is
opening the dialog box. I select the name I want and it just sits there. If
I hit enter then I get an error. I double checked, I do have in teh after
update event just as you said Me.Visible = False.

thanks so much for your help.

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

I have a report that is set up to immediately open a form from which you
select your query from a drop list. Then on the form is a command button
that you click to run the query.

When I open the report the form opens just as I want it. I can chose from
the combo box then I click the command button and the query runs. The query
shows up in datasheet view. I don't want this. Immediatly upon the

query
in

datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet

view,
how

to keep the dialog box from opening and how to get the info from the

query
in

the report. (the report is set up to pull from that query).

thanks for any help you can give.

 

[AJ]

Thanks and hopefully this is the last problem. The record source isn't
working properly.

When I open the report the form pops up correct, I select the name I want,
but then I get the error messace that "Record Source '1' spcidied on this
report or form does not exists. What is happening is the number that shows
up correlates to the primary key in the table that generates the list. How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!

You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

This helped alot thanks. Just one problem at this point. The Report is
opening the dialog box. I select the name I want and it just sits there. If
I hit enter then I get an error. I double checked, I do have in teh after
update event just as you said Me.Visible = False.

thanks so much for your help.

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


I have a report that is set up to immediately open a form from which you
select your query from a drop list. Then on the form is a command button
that you click to run the query.

When I open the report the form opens just as I want it. I can chose from
the combo box then I click the command button and the query runs. The
query
shows up in datasheet view. I don't want this. Immediatly upon the query
in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet view,
how
to keep the dialog box from opening and how to get the info from the query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.

 

[PC Datasheet]

In the code in the report's Open event, Change this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
to this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9].Column(1)

If that does not work yet, post back with the list of fields in your table
in the exact order they are in your table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

Thanks and hopefully this is the last problem. The record source isn't
working properly.

When I open the report the form pops up correct, I select the name I want,
but then I get the error messace that "Record Source '1' spcidied on this
report or form does not exists. What is happening is the number that shows
up correlates to the primary key in the table that generates the list. How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!

You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

This helped alot thanks. Just one problem at this point. The Report is
opening the dialog box. I select the name I want and it just sits

there.
If

I hit enter then I get an error. I double checked, I do have in teh after
update event just as you said Me.Visible = False.

thanks so much for your help.

:

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


I have a report that is set up to immediately open a form from

which
you

select your query from a drop list. Then on the form is a command button
that you click to run the query.

When I open the report the form opens just as I want it. I can

chose
from

the combo box then I click the command button and the query runs. The
query
shows up in datasheet view. I don't want this. Immediatly upon

the
query

in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter

here
and no

matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet view,
how
to keep the dialog box from opening and how to get the info from

the
query

in
the report. (the report is set up to pull from that query).

thanks for any help you can give.

 

[AJ]

now it is the same error execpt it actually has the name instead of the
number. I went and opened the query, to get it to run I have to have the
number else I get an error there too. the query wants the number, but the
form is selecting the name.

In the code in the report's Open event, Change this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
to this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9].Column(1)

If that does not work yet, post back with the list of fields in your table
in the exact order they are in your table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

Thanks and hopefully this is the last problem. The record source isn't
working properly.

When I open the report the form pops up correct, I select the name I want,
but then I get the error messace that "Record Source '1' spcidied on this
report or form does not exists. What is happening is the number that shows
up correlates to the primary key in the table that generates the list. How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!

You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


This helped alot thanks. Just one problem at this point. The Report is
opening the dialog box. I select the name I want and it just sits there.
If
I hit enter then I get an error. I double checked, I do have in teh after
update event just as you said Me.Visible = False.

thanks so much for your help.

:

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


I have a report that is set up to immediately open a form from which
you
select your query from a drop list. Then on the form is a command
button
that you click to run the query.

When I open the report the form opens just as I want it. I can chose
from
the combo box then I click the command button and the query runs. The
query
shows up in datasheet view. I don't want this. Immediatly upon the
query
in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here
and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet
view,
how
to keep the dialog box from opening and how to get the info from the
query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.

 

[PC Datasheet]

Post back with the list of fields in your table in the exact order they are
in your table.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

now it is the same error execpt it actually has the name instead of the
number. I went and opened the query, to get it to run I have to have the
number else I get an error there too. the query wants the number, but the
form is selecting the name.

In the code in the report's Open event, Change this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
to this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9].Column(1)

If that does not work yet, post back with the list of fields in your table
in the exact order they are in your table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

Thanks and hopefully this is the last problem. The record source isn't
working properly.

When I open the report the form pops up correct, I select the name I want,
but then I get the error messace that "Record Source '1' spcidied on this
report or form does not exists. What is happening is the number that shows
up correlates to the primary key in the table that generates the list. How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!


:

You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


This helped alot thanks. Just one problem at this point. The

Report
is

opening the dialog box. I select the name I want and it just sits there.
If
I hit enter then I get an error. I double checked, I do have in

teh
after

update event just as you said Me.Visible = False.

thanks so much for your help.

:

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


I have a report that is set up to immediately open a form from which
you
select your query from a drop list. Then on the form is a command
button
that you click to run the query.

When I open the report the form opens just as I want it. I

can
chose

from
the combo box then I click the command button and the query

runs.
The

query
shows up in datasheet view. I don't want this. Immediatly

upon
the

query
in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here
and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet
view,
how
to keep the dialog box from opening and how to get the info

from
the

query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.

 

[AJ]

Would this work better if I zipped up the database and sent it to you?

Post back with the list of fields in your table in the exact order they are
in your table.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

now it is the same error execpt it actually has the name instead of the
number. I went and opened the query, to get it to run I have to have the
number else I get an error there too. the query wants the number, but the
form is selecting the name.

In the code in the report's Open event, Change this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
to this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9].Column(1)

If that does not work yet, post back with the list of fields in your table
in the exact order they are in your table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com




Thanks and hopefully this is the last problem. The record source isn't
working properly.

When I open the report the form pops up correct, I select the name I want,
but then I get the error messace that "Record Source '1' spcidied on this
report or form does not exists. What is happening is the number that
shows
up correlates to the primary key in the table that generates the list.
How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!


:

You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox
correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


This helped alot thanks. Just one problem at this point. The Report
is
opening the dialog box. I select the name I want and it just sits
there.
If
I hit enter then I get an error. I double checked, I do have in teh
after
update event just as you said Me.Visible = False.

thanks so much for your help.

:

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


I have a report that is set up to immediately open a form from
which
you
select your query from a drop list. Then on the form is a command
button
that you click to run the query.

When I open the report the form opens just as I want it. I can
chose
from
the combo box then I click the command button and the query runs.
The
query
shows up in datasheet view. I don't want this. Immediatly upon
the
query
in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter
here
and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet
view,
how
to keep the dialog box from opening and how to get the info from
the
query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.